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 2, 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 2, 2008 10:43 PM
 Old Hand Group: General Forum Members Last Login: Tuesday, October 13, 2015 9:37 AM Points: 349, Visits: 1,362
 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 3, 2008 9:04 AM
 Forum Newbie Group: General Forum Members Last Login: Monday, November 17, 2008 3:43 PM Points: 5, Visits: 43