Need Clarification on MDX Query (StrToMember and StrToValue) in SQL 2008

• H4K

  Hall of Fame

  Points: 3374

  More actions

  August 31, 2011 at 12:53 am

  #150467

  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

• hila

  SSC Enthusiast

  Points: 124

  More actions

  October 26, 2011 at 7:02 pm

  #1399968

  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...)