I am trying to create one Calculated member and my requirement is to set dimension dynamically.
For example: Consider following query where I have used Color attribute of Product dimension for calculation but if user selects some other attribute from any other dimension then calculated member should be able to calculate values as per that dimension,
like if user selects attribute "Number of cars owned" from "Customer" dimension then calculated member should be able to calculate in place of [Product].[Color].CurrentMember
And I want to create only one Calculated member not for each dimension attribute.
MEMBER [Measures].[x] AS
,[Measures].[Internet Order Count]
View Complete Post