SAP Knowledge Base Article - Public

3227773 - Hierarchy of the dimension is displayed in the table on SAC when use BW live connection even it is inactive in the query definition

Symptom

You selected a hierarchy for a dimension in  the query definition, but did not select the checkbox "Activate Hierarchy Display". 

Then, create a model on this query and a story with table uses the model as the data source. The dimension is displayed as the selected hierarchy.

If you run the query in Analysis for Office, the dimension is displayed as flat presentation. The hierarchy will be used only in the filter dialog in this case. 

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP Ananlytics Cloud 1.0

Reproducing the Issue

Run the story on SAC.

Cause

It is by deign.

Resolution

If you do not want to use the hierarchy, please delete the hierarchy in the query definition by clicking the value help button and select a blank value for "Hierarchy Name".

Keywords

default hierarchy, default value of hierarchy, Query Designer, hierarchy definition , KBA , LOD-ANA-LDC-BW , SAC Live Data Connection BW , BW-BEX-OT-BICS-INA , BW INA provider , Problem

Product

SAP Analytics Cloud 1.0

Attachments

image1.png
image.png
image.png
b4bc2c5fc37ebd94d45bd72c050131e5
b4bc2c5fc37ebd94d45bd72c050131e8
f0bc6c5fc37ebd94d45bd72c05013103