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.
Read more...
Environment
SAP Ananlytics Cloud 1.0
Product
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
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.