August 31, 2011 at 12:53 am
Hi Experts,
Here i have replaced input parameter '@Grouping' with '[Product].[Category]'
Following is the query that give different results in SQL 2008 i.e., All
than in SQL 2005 i.e., Each Member in [Product].[Category]
With
Member [Measures].[Category]
Case "[Product].[Category]"
When "All"
Then "All"
Else StrToMember("[Product].[Category]" + '.CurrentMember').Member_Caption
End
The above query doesn't work as desired (as in sql 2005 it used to work).
I need to know why this is happening ? What's the reason for this ?
Please Help :-)!!!
Regards,
Amar S.
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 26, 2011 at 7:02 pm
I don't promise anything, but Mosha explains a bit about this in here:
http://www.mosha.com/msolap/articles/mdxconvertstringtonumber.htm
So maybe that's help?
(If it works don't break it. Publish this as a "new feature" in your blog...)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy