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

Search for additional results

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