CODEWITHSUNDEEP
ssasmdxolap-cube
kannan
kannan

Reputation: 87

SSAS CUBE Calculated member based on different members in dimension and different measures

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.

Upvotes: 0

Views: 1403

Answers (2)

kannan
kannan

Reputation: 87

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])

Upvotes: 0

Mike Honey
Mike Honey

Reputation: 15037

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.

Upvotes: 1

Related Questions