Log in  ::  Register  ::  Not logged in

 Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 Add Measures from different Dimensions Rate Topic Display Mode Topic Options
Author
 Message
 Posted Thursday, October 02, 2008 10:44 AM
 Forum 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 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 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 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

 Permissions

 Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.