3567035 - The Model Does not Meet the Prerequisites for Non-Cumulative Measures: Record Type field (integer) and Time Dimension (date).

creating non-cumulative measure in Analytic Model and getting the error:

The model does not meet the prerequisites for non-cumulative measures: Record type field (integer) and time dimension (date). 

• SAP Datasphere.
• SAP Analytic Cloud.

Add Non-Cumulative Measure in Analytic Model.

Prerequisites for creating a Non-Cumulative Measure are:

1. Dataset that includes the RecordType column.
2. A Fact source dimension with a Date attribute.
3. The attribute MUST have an Association with a Time Dimension.

On the Fact source view ensure:

1. Dataset includes the RecordType column with Datatype Integer and values allowed for this column are 0 (delta), 1 (reference point), or 2 (delta included in reference point). Example below shows:

      2. The Fact source dimension must have a Date attribute. See example in the screenshot above.

      3. The Date attribute from the source Dimension MUST have an Association with a Time Dimension.

      3.1 On the Analytic Model properties, scroll down to Association and click on the plus (+) sign:

       3.2 Click on Association and the below example window opens:

    3.3 Type in the search field: Time or time dimension to find the Time Dimension to use and select it - as in this example:

     3.4 The Select option becomes ungreyed. Click on it to add associate it to the Analytic Model.

     3.5 Map the desired Date column from the Time Dimension to the analytic Model Date column as in this example:

      4. Save and Deploy the fact view.

       5. Create the Analytic Model:

      5.1 The analytic Model is created:

      6. Create the Non-cumulative Measure. Change the name if needed and select the Source Measure:

      6.1 On the Analytic Model Properties panel scroll down to the Measures and click on the plus (+) sign to add Non-Cumulative Measure:

     6.2 On the properties panel, scroll down to Record Type and select the Record Type column - RecordType in this example:

      6.3 Select the Date column for the Time Dimension - Booking Date in this example:

      6.4 Optionally enter Earliest Reporting Date and Latest Reporting Date eg:

      6.5 Optionally select also Exception Aggregation eg here:

     7. Save.

       8. Deploy. And ensure it deploys without error.

       9. Now you can preview the analytic Model and the result can be viewed:

KBA , DS-MD-AM , Analytic Model , Problem