SAP Knowledge Base Article - Preview

1962321 - Understanding results for nested selections on the same characteristic

Symptom

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.

RSRT_NR_MUSE_1.PNG

The 3rd column "AT + DE (restricted AT)" is a selection that applies to the restricted key figure (RKF) used in column 2 "AT + DE".

QD_selection.png

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.

RSRT_NR_MUSE_2.png


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

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 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.