SAP Knowledge Base Article - Preview

1951436 - How to use feature 'Constant Selection' instead of functions such as SUMCT or %CT

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:

sumct_1.png

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.

sumct_2.png

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

SAP NetWeaver 7.0 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.