mdx issue

• mnr123

  SSC-Addicted

  Points: 425

  More actions

  August 10, 2017 at 10:16 am

  #151126

  SELECT NON EMPTY { [Measures].[Observation Value] } ON COLUMNS, NON EMPTY { ([GDF_Series].[Topic].[Indicator_Name].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( [GDF_Series].[Topic].Properties( "Code" ) ) ON COLUMNS FROM [GDFADV]) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

  getting this error

  TITLE: Microsoft SQL Server 2012 Analysis Services
  ------------------------------

  The Axis0 function expects a tuple set expression for the argument. A string or numeric expression was used.

  ------------------------------
  BUTTONS:

  OK
  ------------------------------