Search code examples
ssasparent-childmdxpivot-tableolap

New Named Set in SSAS used in Pivot Table - MDX

I created a New Named Set called DB III o. PE defined as DB III, Umlage HL, Umlage NV, Umlage UL . When I use this new Set in a Pivot Tabel or in MDX I see the content of this Set and not his given name DB III o. PE. Is there a possibility to see the given name instead of his content?

Example attached:enter image description here

The set is created like this:

enter image description here

UPDATE: I created also a measure called [Amount Standard Set] because before Set I needed first to multiply with -1 the Amount of Umlage HL, Umlage NV, Umlage UL .

The measure is defined as: 

case 
    when [Kostenart Hierarchy].[Kostenart Hierarchy].currentmember= [Kostenart Hierarchy].[Kostenart Hierarchy].&[148]
        then -1* [Measures].Amount
    when [Kostenart Hierarchy].[Kostenart Hierarchy].currentmember= [Kostenart Hierarchy].[Kostenart Hierarchy].&[147]
        then -1* [Measures].Amount
    when [Kostenart Hierarchy].[Kostenart Hierarchy].currentmember= [Kostenart Hierarchy].[Kostenart Hierarchy].&[150]
        then -1* [Measures].Amount


    else Amount
end
Solution

  • I think it is behaving as it should. A set is several distinct members.

    You require a custom member that is the amalgamation of your set.

    Create a custom member called DB III o. PE Agg and define it as something like the following mdx:

    `Aggregate([DB III o. PE])`

    This is using the Aggregate function:
    https://msdn.microsoft.com/en-us/library/ms145524.aspx

    Create this custom member in the dimension where the elements of the set {DB III, Umlage HL, Umlage NV, Umlage UL} are found.

    If you are using Excel 2013 you should have a option in the OLAP Tools menu "MDX Calculated Member.."