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.
| Author |
Topic |
|
rahulnadkarni
Starting Member
5 Posts |
 Posted - 2007-07-02 : 09:39:13
|
| Hi,I am facing a strage problem. In my Cube I have a calculated member as follows: Local Currency:='IIF([Currency].currentmember.Name = "USS" OR NOT ISLEAF([Currency].currentmember),NULL,IIF([Market].[Standard].currentmember.Name <> "All Market" AND [Market].[Standard].CurrentMember.properties("HasData") = "-1" ,[Measures].[Hidden Local Currency],NULL))' As per this condition, if a user selects currency as USS or the Rollup "Total Currency",then the NULL will be returned tio the user.Else if user selected a valid market and currency combination, he can view the data. When I am trying to browse the cube in the SQL Server management studio thro Browse Cube,and selecting UK as market and EUR as currency, it's still returning NULL. But IF i write a MDX query or if I browse the cube thro Excel Pivot Table feature,the result is correct and it returns the expected value. On further investigation I found that irrespective of the currency selected, it's going to Null condition.i.e. ([Currency].currentmember.Name = "USS" OR NOT ISLEAF([Currency].currentmember) is not getting executed thro SQL Server management studio thro Browse Cube feature. It's preety strage to find that this basic feature is not working. Please let me know there is anyworkaround to get the valid result thro Browse Cube feature. Also let me know if anyone has faced this kind of problem before. Thanks,Rahul |
|
|
|
|
|
|
|
Problem with calc members in SQL manage. studio