SAP Knowledge Base Article - Public

3641171 - Data preview of an Analytic Model fails when the number of entries filtered on the Time dimension exceeds the value supported by MDS_PARAM_NCUM_MAX_REF_TIME_RANGE

Symptom

Data preview of an Analytic Model fails with the error:

The query executed with errors. The non-cumulative time reference dimension contains more than the limit of entries provided by parameter MDS_PARAM_NCUM_MAX_REF_TIME_RANGE (default 10,000). Please set an appropriate time dimension reporting filter for the Analytic Model. Moonlight section "NonCumulativeSettings". Properties are called "ReportingMinStartTime" and "ReportingMaxEndTime" : 10592 entries found. Limit is: 10000

Environment

SAP Datasphere

Cause

Expected behaviour

Resolution

Use a smaller date range for the Non-cumulative measure's Time Dimension.

Keywords

Analytic model, non-cumulative measure, MDS_PARAM_NCUM_MAX_REF_TIME_RANGE, time dimension, preview , KBA , DS-MD-AM , Analytic Model , Problem

Product

SAP Datasphere all versions