October 2, 2008 at 10:44 am
I have a Cube with 2 Dimensions and 2 Measures.
[Code]
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)
[/code]
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.
October 2, 2008 at 10:43 pm
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
October 3, 2008 at 9:04 am
Dan English,
Thanks for your reply.
Can you please post the links to the examples of SCOPE statement.
Thanks,
Raj.
October 3, 2008 at 9:15 am
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply