Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Add Measures from different Dimensions Expand / Collapse
Author
Message
Posted Thursday, October 02, 2008 10:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 17, 2008 3:43 PM
Points: 5, Visits: 43
I have a Cube with 2 Dimensions and 2 Measures.

CUBE(FactTable F)
DIMENSION A(DimensionTable A)
DIMENSION B(DimensionTable B Based on some sql)
MEASURE A(FactTable Column based on some conditions from DimensionTable A)
MEASURE B(FactTable Column based on some conditions from DimensionTable B)

Columns C1, C2, C3 are common in Dimension Tables A and B.

Is it possible to add up these 2 measures i.e., Measure A and Measure B.

Thanks,
Raj.
Post #579804
Posted Thursday, October 02, 2008 10:43 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 22, 2013 7:25 AM
Points: 347, Visits: 1,344
If you only have one fact table and both dimensions are related to the fact table then I see no reason why you couldn't do this. Sounds like you have some specific scenarios and conditions on how you want this to work, so I would recommend exploring SCOPE statements to make this to work the way you want it. If I recall the Adventure Works DW SSAS project on codeplex has some examples of SCOPE statements if you are not familiar with them. Just setup the SCOPE statements and/or calculations in the cube.

----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Post #580050
Posted Friday, October 03, 2008 9:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 17, 2008 3:43 PM
Points: 5, Visits: 43
Dan English,

Thanks for your reply.

Can you please post the links to the examples of SCOPE statement.

Thanks,
Raj.
Post #580350
Posted Friday, October 03, 2008 9:15 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 22, 2013 7:25 AM
Points: 347, Visits: 1,344
Take a look at the BOL material http://msdn.microsoft.com/library/ms145989.aspx and you can take a look at downloading the Analysis Service sample database, Adventure Works, here http://www.codeplex.com/SqlServerSamples. They have some examples in there also and I am sure you can find plenty more online.



----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Post #580364
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse