0
votes

I am new to SSAS, I am creating a cube and I need to have a calculated member.The complexity is I have property name as one dimension which has members like "a,b,c,d". Each of this member will be having one value per date in a measure called 'property value'.

I have another measure "Volume" which will be one value per day(date dimension).

I need to do calculation of (a*volume + b* volume) as a calculated member.

Please advice.

2

2 Answers

1
votes

I would try a Measure expression of:

[Measures].[property value] * [Measures].[Volume]

If those source measures have AggregateFunction set to Sum, then the aggregation will happen automatically.

0
votes

Finally I got the answer which is very simple, using tuple we can access measure value for a particular dimension member as,

([Measures].[PropertyValue],[Property].[PropertyName])