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 2005 Forums
 Analysis Server and Reporting Services (2005)
 Solve order in SSAS

Author  Topic 

vini83_4
Starting Member

2 Posts

Posted - 2007-07-10 : 01:35:31
Hi,


I need your help in SSAS, kindly do the needful.


As part of migration from AS to SSAS, we had to create many calculated members.

There is a dimension called Version, which has members that are calculated members, when I add this dimension to the rows and add the Measures dimension to column,

I want the intersecting cell to show, the Measures value (the result of the Measure’s MDX) but right now the MDX of the Calculated member in Version dimension is shown.



How do I set the order in which the values are shown in a cell. I have set the correct solve order, but still I have the problem.



Does recreating the Calculated member solve the issue, or any other setting needs to be set in SSAS to make this happen?



Thanks in advance.



Vinaya.
   

- Advertisement -