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]
Else StrToMember("[Product].[Category]" + '.CurrentMember').Member_Caption
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 :-)!!!
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQLPlease visit... ApplyBI