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
- Create a BEx query, with Condition 'TOP N'.
- Create a Live to BW model in SAC with the BEx query.
- Create a table based on the Live to BW model, the total result is displayed as Condition 'TOP N' is applied to the table.
- 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