Expand 2 following columns with one expander

#1

Hi everyone,

I have created a table which shows monitoring data. There are 3 columns which are expandable. Is there a possibilty that I can connect 2 columns?

Beispiel
Beispiel.PNG1046×332 14.9 KB

The Picture shows an example. Then I expand the column “Quelle” both of the following columns ("Archiv-Objekt, Dokumentenart) should expand too. As you can see, so far only the next column expands.

Thanks

#2

You could connect them at the data cube level with a calculated element where you append the value from the Dokumentenart column to the value from the Archiv-Objekt column, and then use this new column in your metric set. Especially if Archiv object is unique and doesn’t repeat for differeng Dokumentnart values.

https://dundas.com/support/learning/documentation/cleanse-consolidate-modify-data/transforms/common/calculated-element

Since each hierarchy parent has to have at least one child, the table won’t expand based off assumptions, but you can get around this by creating a unified column so that no further expansion is needed.

#3

Thanks for your help. I will try this.

#4

Hi,

If every Archiv Objekt always has exactly one Dokumentenart value, Dokumentenart could be considered an ‘attribute’ of each Archiv Objekt value. If you create a hierarchy from the main menu for Archiv Objekt where Dokumentenart is added as an attribute, these values will be always be expanded together when they are displayed together like this (and there won’t be expander buttons anymore in the Archiv Objekt column as they aren’t needed).