SAP Knowledge Base Article - Public

2965902 - Error: The data query returns empty result set" and "Object CUBE:t.2:<DIMENSION> was not found" in SAP Analytics Cloud (SAC) & SAP Digital Boardroom KBA Template

Symptom

The following error occurs in SAP Analytics Cloud (SAC):

  • The data query returns empty result set

The Cloud Connector logs show the error:  "Object CUBE:t.2:<DIMENSION> was not found."

Environment

  • SAP Analytics Cloud (Enterprise) 2020.17.4
  • SAP Business Warehouse (BW)

Reproducing the Issue

  1. Set User Preferences Data Access Language to a language different from the BW System
  2. Create an Import Data Connection towards the BW system, set the language to English
  3. Create a Model out of the BW Import Data Connection
  4. Create a Story out of the Model , error is thrown:   The data query returns empty result set 
  5. The Cloud Connector logs show the error:  "Object CUBE:t.2:<DIMENSION> was not found."

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, sap analyst cloud, connected, failure, stopped, Object CUBE, empty result set , KBA , LOD-ANA-DES , Model, Story Design & Visualizations , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0