SAP Knowledge Base Article - Public

3566986 - SAC Hiearchy in the Data Analyzer not shown correctly when opening from story

Symptom

  • When displaying a hierachy in the Data Analyzer on top of SAP Datasphere Analytical Model, it is displaying different comparing the hierarchy from story. 
  • With values selected in filters from Story table, when jumping to Data Analyzer, it should keep the same values filter but it is not the case
  • From Data Analyzer, when selecting "All" values in filter, but excluding 1 parent node, the table still display the parent item excluded in filter.

Environment

  • SAP Analytics Cloud (Enterprise) 

Resolution

Here are a simple Story scenario to be something you can turn on for Data Analyzer :

  • We have a Dimension with Hierarchy X active that looks like the following

A1D1

->A1D2

->->A1D3

->A2D2

B1D1

->B1D2

  • Filtering based on the same Hierarchy X on “A1D2” and “B1D1” we get the following in Story : 

A1D1

->A1D2

->->A1D3

B1D1

->B1D2

 Note : The parent of A1D2 is still shown

  •  Now using the same filter in Data Analyzer with Hierarchy X used both for the filter and in the Table we get :

A1D2

->->A1D3

B1D1

->B1D2

 Note : The parents of A1D2 is not shown and it now appears at drill level 1

If you want to have behaviour changes where the filtered nodes parents are NOT shown, and hence a feature request for Data Analyzer, please follow this Knowledge Base Article to create an enhancement request: https://launchpad.support.sap.com/#/notes/2424376

See Also

Keywords

KBA , LOD-ANA-DAN , SAC Data Analyzer , Problem

Product

SAP Analytics Cloud all versions