SSRS that uses SSAS cube as data source

• ywondimu03

  Newbie

  Points: 9

  More actions

  July 28, 2010 at 12:10 pm

  #223841

  I have a report that uses a cube as its data source. And I have defined the parameters. I wanted to display the parameters as a report title , when I tried it displays as [DimensionName].[AttributeName].&[Value]. I don't want to see the dimension and attribute name to be displayed

  Example: [Address].[City].&[Washington] is displayed on the report I only wanted to see Washington .

  I would apperciate your prompt response.

• Don Shields-368041

  Ten Centuries

  Points: 1189

  More actions

  August 4, 2010 at 4:23 pm

  #1202428

  Add:

  DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME

  to your MDX right before "From [Cube]"

  I use that in exactly the same situation querying the cube in SSAS from SSRS. you might also want to Google "Dimension Properties" for more info.

  Don

• mvee

  Hall of Fame

  Points: 3634

  More actions

  August 5, 2010 at 3:05 am

  #1202580

  Try something like this:

  WITH

  MEMBER [Measures].[ParameterCaption] AS '[Geography].CURRENTMEMBER.MEMBER_CAPTION'

  MEMBER [Measures].[ParameterValue] AS '[Geography].CURRENTMEMBER.UNIQUENAME'

  SELECT

  {

  [Measures].[Results],[Measures].[ParameterCaption],[Measures].[ParameterValue]

  } ON 0,

  nonempty([Geography].[Region])

  on 1

  FROM [MyCube]

• benlatham

  SSC Eights!

  Points: 933

  More actions

  August 6, 2010 at 1:52 am

  #1203284

  If you want to see the parameter caption on the report (as opposed to its value) use =Parameter!State.Label.