SAP Knowledge Base Article - Public

2867370 - "FILTER_EXTENSION_DIMENSION_NOT_IN_DRILL" error in story data view in SAP Analytics Cloud (SAC)

Symptom

  • The following error message occurs instead of the list of measures in story data view for import models
    {"code":"FILTER_EXTENSION_DIMENSION_NOT_IN_DRILL","message":"The dimension 'Time' is required by a measure defined by a modelling formula. Modelling formulas requiring the time dimension on the time axis of a Time Series chart are not supported.","details":null}
  • In addition to that the following error is visible in the google chrome developer tool network panel:
    Messages: [{Number: 42578,…}, {Number: 42709,…}, {Number: 42709,…}]
    Text: "Current Member Filter Extension cannot be applied : Dimension for which current member navigation is specified is not in drill. Dimension/field specified is: Time"
    Text: "The selection returned more records than the limit in MaxResultRecords: : actual/query/default = 124408227/25000000/1000000"
    Text: "The selection returned more records than the limit in MaxResultRecords: : The selection returned more records than the limit in MaxResultRecords: : Number of data records exceeded: 124408227"

Environment

SAP Analytics Cloud 2019.21.8

Reproducing the Issue

  1. Logon to SAP Analytics Cloud.
  2. Open a Story.
  3. Go to data view.
  4. Notice the error.

Cause

This issue is currently under investigation by Development.

Resolution

This issue is currently under investigation by Development.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-BI-DES , Analytic Models incl Story Design & Visualisations , Problem

Product

SAP Analytics Cloud 1.0