Is it possible to read and filter the dimension hierarchy from live connection to SAC Planning model

[azm_azm]

Hi Everyone,

On SAP Datasphere, there is a dimension hierarchy defined and I want to use the same hierarchy to filter out the members on my SAC planning model. For Example, Industry is a dimension and under it there are multiple leaf members like Automobile, Food, Retail, Pharma. I have not maintained the same hierarchy in SAC Planning model but rather have maintained only the leaf members.

The requirement is if the user selects the "Industry" hierarchy in the story, the table should filter only those members which are part of Industry hierarchy by reading it from SAP Datasphere analytical view. Is it possible to enable this functionality using scripting in SAC or is it mandatory to maintain the hierarchy in SAC Planning model for this requirement?

Anyone who has faced this issue recently or knows the workaround in this scenario. Their comments would be deeply appreciated.

Thanks.

[N1kh1l · Accepted solution]

@azm_azm 

It will be simpler if you maintain the hierarchy in SAC. Scripting option will still require you to create a story using the DS Analytical model as there is now way for SAC scripting to directly work off DS Analytic Model. Even if the scripting works you will be forced to add the Analytical model story  and the scripting code to all planning stories where you need this filter to work. have not tried this but you will first have to

• create a story with a table using the DS Analytical view and allow it to get filtered by user selection based on hierarchy selection.
• Read the table using script for the members of the industry dimension and store it in a variable,  refer getSelections()
• Use this variable to set dimension filter on Planning story tables. refer setDimensionFilter()

Its just too many moving parts here.

Nikhil

Nikhil