Symptom
Operators such as SUMCT or %CT are not showing the expected results (the following can be applied to SUMGT, SUMRT, %GT, %RT operators as well).
Symptom 1)
Results for a certain value combination in detail rows change with different navigations steps
Running a query in transaction RSRT:
In the above graphic, you can see that the market share of region 'DE/BAY' in year 2010 is 38%.
Now, if we just swap the 2 characteristics 'Calendar Year' and 'ZREGION', all of a sudden the result is different and the market share for the same region is 33% as the subtotal result changes in this grouping.
This is not a bug. The SUMCT etc. functions are calculated based on the displayed data. If you need to use navigations such as drilldown, different filterings etc, then the use of these functions might lead to unexpected results.
Symptom 2)
Different data for a SUMCT column when using the query in APD or in an MDX Statement
Certain interfaces such as MDX, RSCRM (used in APD) do not support so called list calculations or functions such as SUMCT, %CT etc. You have to change the query design in order to realize the expected scenario (one sample resolution is presented below).
Read more...
Environment
SAP BW 7.X
Product
Keywords
SUMCT, SUMGT, SUMRT, %CT, %GT, %RT, APD, MDX, RSCRM, wrong data, incorrect data , KBA , BW-BEX-OT , OLAP Technology , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.