Aliasing column names for Reporting Services

• okbangas

  SSChampion

  Points: 11773

  More actions

  March 30, 2012 at 3:04 am

  #146716

  Please forgive me if some terms are not being used 100 percent accurately, I'll try to explain my issue as precise as I can.

  Given an MDX query similar to this one:

  with

  member A as Measure.X

  member B as Measure.Y

  set C as strtoset("Dim.Member.Children"),caption='Z'

  select non empty {A,B} on 0

  select non empty {C} on 1

  from

  MyCube

  Dom.Level.Childeren is actually delivered as a parameter from Reporting Services. It will always use a single member, but which member will vary. I want Reporting Services to see the result as follows

  CAB

  Val111

  val222

  Unfortunately, what Reporting Services sees is

  MemberAB

  Val111

  val222

  Since the member is varying with the parameter, SSRS cannot know what columns are being returned. Thus, I want the first "column" to always be named C, no matter what member it actually contains.

  How can I achieve this?

  ---

  
  Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

  Concatenating Row Values in Transact-SQL[/url]

• okbangas

  SSChampion

  Points: 11773

  More actions

  April 4, 2012 at 2:40 am

  #1468679

  Seems like the only solution would be to create an additional layer, as a web service or a .NET CLR proc, unless someone has a bright idea.

  ---

  
  Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

  Concatenating Row Values in Transact-SQL[/url]