Selecting a constant using MDX

• s_osborne2

  SSCertifiable

  Points: 6726

  More actions

  November 12, 2012 at 3:20 am

  #143899

  Hi,

  I'm a real newbie when it comes to writing MDX. I'm trying to build an ssrs report off a cube and so have used the query builder to build up the query i want to execute. I'd like to know how to select a string constant, if that's even possible...

  SELECT

  NON EMPTY { [Measures].[Policy Count] } ON COLUMNS,

  NON EMPTY { ( [Insurer].[Insurer].[Insurer].ALLMEMBERS * [Product].[Product].[Product].ALLMEMBERS ) } ON ROWS

  FROM

  (

  SELECT

  { [Time].[Year].&[2012] } ON COLUMNS

  FROM

  [MyCube]

  )

  WHERE

  [Time].[Year].&[2012];

  I'd like the output to look something like this:

  PolicyCount

  ConstantInsurerProductN

  ConstantInsurerProductN

  ConstantInsurerProductN

  ConstantInsurerProductN

  ConstantInsurerProductN

  The query i've got so far returns the insurer, the product and the policy count but i can't seem to work out how to select the constant. Google doesn't seem to have come up trumps for me either. Hopefully this is going to be dead easy for someone to answer...

  Thanks,

  Simon

  ---

  
  MCSE: Data Platform
  MCSE: Business Intelligence
  Follow me on Twitter: @WazzTheBadger
  LinkedIn Profile: Simon Osborne