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

[ychernikov]

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 :

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 :

Would appreciate any suggestions on how this can be achieved,

Thank you

[AbdullahShaffi]

Account dimension behaves similar to a measure.

1. You can create Restricted account

Or you can use this function in Calculated Measure.

Need more details on the requirement.

[ychernikov]

Thank you! I added details and elaboration above