A query is returning unexpected results when multiple selections on the same characteristic are used in nested selections or nested restricted key figures. It seems, that some of the selections/restrictions are ignored.
Sample: In the following query for the value 4,00 EUR for Germany (3rd column) no data is expected. The restriction of the structure element "AT + DE (restricted AT)" seems to be ignored.
The 3rd column "AT + DE (restricted AT)" is a selection that applies to the restricted key figure (RKF) used in column 2 "AT + DE".
The restricted key figure "AT + DE" has the basis key figure 0AMOUNT and is restricted to the countries "AT" and "DE" and is also used on column 2 for better understanding.
SAP BW 7.X
multiple selections; wrong data; incorrect data; RKF; CKF; restriction , KBA , BW-BEX-OT-OLAP , Analyzing Data , BW-BEX-OT , OLAP Technology , How To
About this pageThis 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.