SAP Knowledge Base Article - Public

2774357 - The data query returns empty result set error when trying to import data from an SAP BW data source in SAP Analytics Cloud

Symptom

The following error occurs when trying to import data from an SAP BW data source into SAP Analytics Cloud (SAC):

  • The data query returns empty result set.

Environment

  • SAP Analytics Cloud

Cause

No available presentations for a characteristic were selected in the Select Presentations dialogue (wrench icon).

Resolution

Select at least one available presentation in the Select Presentations dialogue (wrench icon) for the dimensions (characteristics) selected in the Build SAP BW Query dialogue window (Selected Data section):

  • Key (DISPLAY_KEY)
  • Key (Internal) (KEY)
  • Long Text (LONG_TEXT)
  • Medium Text (MIDDLE_TEXT)
  • Short Text (SHORT_TEXT)
  • Text (TEXT)

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, available presentations, spbw, bw, datasource, bex query , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0