InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 12:22:57 GMT20http://www.sqlservercentral.com/Forums/Topic579804-147-1.aspxTake a look at the BOL material [url=http://msdn.microsoft.com/library/ms145989.aspx]http://msdn.microsoft.com/library/ms145989.aspx[/url] and you can take a look at downloading the Analysis Service sample database, Adventure Works, here [url=http://www.codeplex.com/SqlServerSamples]http://www.codeplex.com/SqlServerSamples[/url]. They have some examples in there also and I am sure you can find plenty more online.Fri, 03 Oct 2008 09:15:09 GMTdenglishbihttp://www.sqlservercentral.com/Forums/Topic579804-147-1.aspxDan English,Thanks for your reply.Can you please post the links to the examples of SCOPE statement.Thanks,Raj.Fri, 03 Oct 2008 09:04:24 GMTraj-897557http://www.sqlservercentral.com/Forums/Topic579804-147-1.aspxIf 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.Thu, 02 Oct 2008 22:43:37 GMTdenglishbihttp://www.sqlservercentral.com/Forums/Topic579804-147-1.aspxI 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.Thu, 02 Oct 2008 10:44:57 GMTraj-897557