SAP Knowledge Base Article - Public

3364069 - BW condition 'TOP N' not working in Numeric point chart in SAP Analytics Cloud story

Symptom

  • BW condition 'TOP N' not working in Numeric point chart in SAP Analytics Cloud story
  • Chart Widget is Numeric chart with applied BW condition of TOP 25. Instead of sum of top 25, numeric chart is showing overall total.

Environment

  • SAP Analytics Cloud 1.0 (SAC)

Reproducing the Issue

  1. Create a BEx query, with Condition 'TOP N'.
  2. Create a Live to BW model in SAC with the BEx query.
  3. Create a table based on the Live to BW model, the total result is displayed as Condition 'TOP N' is applied to the table.
  4. Create a Numeric point chart based on the Live to BW model, the total result is displayed regardless the Condition 'TOP N' is applied to the table. 

Cause

This is expected behavior.

BW Condition is only working in table with defined context as in Bex query.

The condition working in BW is based on context. Means it will consider the selected dimensions in query selection, same behavior could be observed in transcation RSRT as well.
While in SAC, numeric point chart is chart without dimensions or context, so the condition in numeric point chart will be working as condition in RSRT without adding any dimension, same in both, overall result of total will be displayed.
 
For example, in transcation RSRT, overall result output with condition is not considering the TOP N Condition as well, if the selected dimension is different. 

Resolution

This is expected behavior.

Keywords

KBA , LOD-ANA-DES-CHART , SAP Analytics Cloud core charting , Problem

Product

SAP Analytics Cloud 1.0