SAP Knowledge Base Article - Public

3453159 - Query returns NULL value when applying filter on the dimension in SAP Analytics Cloud (SAC)

Symptom

  • Dimension shows null value filtering on it.
  • When applying no filter, same dimension shows a specific value.

Environment

SAP Analytics Cloud

Connection - Import to Integrated Business Planning

Reproducing the Issue

  1. Login to SAC.
  2. Go to Modeler.
  3. Create a classic account model.
  4. Select Integrated Business Planning as the datasource.
  5. Select the connection.
  6. Enter a query name.
  7. Select the query.
  8. Select the required measures and dimensions.
  9. Apply the filter on the dimension whose value is required.
  10. Click on Create. The data will be created as a draft data.
  11. Open the drafted data and notice that the value is 0.

Cause

The issue is under investigation by the development team.

Resolution

The issue is under investigation by the development team.

Keywords

KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0