Aliasing column names for Reporting Services

  • okbangas

    SSChampion

    Points: 11773

    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

    C A B

    Val1 1 1

    val2 2 2

    Unfortunately, what Reporting Services sees is

    Member A B

    Val1 1 1

    val2 2 2

    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

    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]

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply