SAP Knowledge Base Article - Preview

1962321 - Understanding BW Query Results of 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, no data instead of the value 4,00 EUR for Germany (3rd column) might be expected. The restriction 'AT' 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
  • SAP BW/4HANA All versions

Product

SAP BW/4HANA all versions ; 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 , BW4-AE-CORE , Core Services , 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.