cancel
Showing results for 
Search instead for 
Did you mean: 

Dimension Hierarchy Drilldown

bautayakool
Explorer
0 Kudos

Hi experts,

I have created a story which has date and account dimension. The account dimension has 1 level parent-child hierarchy. We expected that we would be able to select the drill option, so that all the leaf members of the account will be displayed at the same time.

However, it turns out that we cannot select the drill down option. SAC shows the following message when we tried to select the drilldown option.

SAP Blog Question- Drilldown V2.png

Please advise, if this is intentional technical limitation, or if there is any way that we can solve this issue.

Thank you.

Bhumirapee A.

View Entire Topic
N1kh1l
Active Contributor
0 Kudos

@bautayakool 

Can you show how your NCP Accounts is set up. I see no problem in drilling down even if its 1 level only

N1kh1l_0-1709631531886.png

My Account setup

N1kh1l_1-1709631571903.png

Also select the NCP Account and check what is the drill state for it in table option

N1kh1l_2-1709631706052.png

Br.

Nikhil

bautayakool
Explorer
0 Kudos

I have just reopened the story with the same account and somehow, I can drill to lower levels now.
Sorry for the inconvenience, and thank you for your prompt response!