Add Measures from different Dimensions

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » Add Measures from different Dimensions

Add Measures from different Dimensions

Rate Topic

Display Mode

Topic Options

Author

Message

raj-897557

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

denglishbi

Posted Thursday, October 02, 2008 10:43 PM

Old Hand

Group: General Forum Members
Last Login: Monday, May 13, 2013 9:09 AM
Points: 347, Visits: 1,339

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

raj-897557

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

denglishbi

Posted Friday, October 03, 2008 9:15 AM

Old Hand

Group: General Forum Members
Last Login: Monday, May 13, 2013 9:09 AM
Points: 347, Visits: 1,339

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 »

Permissions