happymappy
Last Activity: Sep 20 '10, 10:07 PM
Joined: Sep 20 '10
Location:
-
No, it's not T-SQL based it's mdx query -
Hi ck9663, I'm a newbe to ssas, could you be a bit more specific? i.e where should I make that sums? in Scope or another calculated member? The expectation is to drag any attributes of MyDimension and should be able to aggregate by all, thanks in advanceLeave a comment:
-
Calculated member depended on dimension value
I have a dimension called MyDimension with attributes
- Model
- ModelValue
One of my measures called MyMeasure.
I need a calculated measure to calculate the value based on existing measure and dimension Model/ModelValue pair above.
In particularly,
...Code:case when MyDimension.Model.MemberValue = "A" then [Measures].[MyMeasure] * [MyDimension].[ModelValue].MemberValue
No activity results to display
Leave a comment: