Calculated Measure Result is Based in Dimension Picked

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » Calculated Measure Result is Based in...

Calculated Measure Result is Based in Dimension Picked

Rate Topic

Display Mode

Topic Options

Author

Message

demitri_baran

Posted Thursday, April 08, 2010 1:55 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, September 21, 2010 5:34 AM
Points: 11, Visits: 117

Dear All,

I have the following Case ... In the Fact:

Person Name Plan ID Earned Days
John Smith A 10
John Smith B 10
John Smith C 10

The requirement is to created a "calculated measure" based on Earned Days...
Its called Exposed Population = Earned Days / 365

The result of this measure is based on the dimension picked

if Dimension is Person then Exposed Population = 10 / 365
(Noticed that 10 is picked only once)

If Dimension is Plan then Exposed Population = (10+10+10) / 365
(Noticed that 10 is picked 3 times)

I would like to have a single calculated measure that deals with this ... I am a bit naive in MDX

Help is kindly appreciated

Regards
Demi

Post #899336

cees van diermen

Posted Thursday, April 22, 2010 5:17 AM

Valued Member

Group: General Forum Members
Last Login: Friday, September 03, 2010 5:15 AM
Points: 57, Visits: 83

Hello Dimitri,

Can you provide more details.

John Smith has 30 Earned Days in total (Right ?),

I would expect that if I select John Smith in the Dimension Person I would get 30 and when I select a specific Plan, lets say A, i would get 10. However that's not what I get from your post.

What are the outcomes you want to see ? It would be helpfull if you post the calculated measure

regards,

Cees

Post #908470

« Prev Topic | Next Topic »

Permissions