cancel
Showing results for 
Search instead for 
Did you mean: 

Why can't I use Account dimension in the editor for Calculated dimension on story table ?

ychernikov
Explorer
0 Kudos
103

Hi,

I am trying to create a calculated dimension in a story with IF condition on Account dimension + Functional Area dimension.

While Functional area is available in the editor selector, I can not add Account dimension :

ychernikov_0-1741772989559.png

I am using an optimized story.

Any ideas why I am not able to operate with Account dimension ?

Thank you,

Yulia

 

Hi,

Many thanks for the inputs.
I need to build a calculated dimension /calculated measure with cross dimensional reference.
IF condition on Functional area dimension in combination with some members from alternate hierarchy of Account dimension.
I tried to follow your suggestion with ACCOUNTLOOKUP function ,but looks like it's not possible to use with alternate hierarchy of account :

ychernikov_0-1742803420211.pngychernikov_1-1742803429880.png

Would appreciate any suggestions on how this can be achieved,

Thank you

View Entire Topic
AbdullahShaffi
Explorer
0 Kudos

Account dimension behaves similar to a measure.

1. You can create Restricted account

AbdullahShaffi_0-1742384874609.png

 


Or you can use this function in Calculated Measure.

AbdullahShaffi_4-1742384907797.png

 

Need more details on the requirement.

 

ychernikov
Explorer
0 Kudos
Thank you! I added details and elaboration above