September 15, 2015 at 6:16 am
Hi,
In SSAS, I want to add a calculated measure and set that measure as the Parent of existing measure. For example I have the measures as A and B from the fact table. Now i want to add a calculated measure as C and set this measure as Parent for measures A and B. How to do that in SSAS. Thanks.
September 15, 2015 at 6:50 am
What do you exactly mean saying Parent Measure? can you share any example/detail and desired output ?
September 15, 2015 at 7:01 am
I have a fact table with below columns
FactID
Date
Location
Measure A
Measure B
Measure C
Measure D
And now I want to create calculated measure and that looks like
Measure S
Measure A
Measure B
Measure C
Measure D
that is Measure S is the parent for Measure A and Measure B.
How to do it?
September 15, 2015 at 7:17 am
When you say Measure S you mean Sum of Measure A + Measure B?
if so then just your Measure A + Measure B you will get your desired result.
And when you say Parent Measure, there isn't any thing called Parent Measure.
usually, your dimensions have Parent - Child relation ships not the measures.
September 15, 2015 at 7:54 am
Thanks for the reply.
Looks like it is available in Essbase to create Parent child measure.
We want to migrate from Essbase to MSBI. So, We need to achieve this functionality.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply