I am struggling with one of my reporting action. What I need to do, I have to show the report action on the specific condition which I m going to describe as below.
- I have a Cost Centre dimension and in that dimension I have a hierarchy let say [Management Units Structure] with following structure
- Unit
- Entity
- Activity
- Cost Centre Description
- I have another dimension Say Postal Code and in that dimension I have a hierarchy let say Post Code Structurewith following structure
- Group level-1
- Group Level-2
- Postal Code description
- I have third dimension Say Time dimension with hierarchy let say Years-Month Structure with the following structure
What I would like to have. My report action will only be displayed if user is on Cost Centre Description level in [Management Units Structure] hierarchy and Postal Code description on Post Code Structurehierarchy and Month level on the Years-Month Structure hierarchy but I could not figure out how. I tried the following MDX.
[Dimension FINANCIAL PERIODS].[Years-Month Structure].CurrentMember<>[Dimension FINANCIAL PERIODS].[Years-Month Structure].[All] And
[Dimension COST CENTRE].[Management Units Structure].CurrentMember<> [Dimension COST CENTRE].[Management Units Structure].[All] and [Dimension POST CODE].[Post Code Structure].CurrentMember<> [Dimension POST CODE].[Post Code Structure].[All]
Am I doing the right thing ? Please advise me I will be really grateful
Many thanks
Qazafi