Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Calculation based on the Selected Dimension value

Author  Topic 

avinashrn
Starting Member

1 Post

Posted - 2010-06-28 : 01:54:04
Hi Guys,

I have a situation where I need to create a calculation in SSAS based on the Selection values in a Dimension. We have a State dimension and a Sales measure where I want to get the difference the sales for the selected States.

For eg. [Calculated Member] =[Sales of State A]-[Sales for State B].

The Calculation has to be generic based on any selection of the pair of states.

Please help me out with the above. Thanks in Advance


Thanks
Avinash
   

- Advertisement -