Skip to main content
J
JoãoRodrigues
July 31, 2024

Creating Expandable and Collapsible Columns with Text1 as an Aggregator

  • July 31, 2024
  • 2 replies
  • 2 views

Each member from entities hierachy has a value for Text1 member.


JooRodrigues_2-1722435683333.png

 

In the report, I use this member to get the columns needed.


JooRodrigues_0-1722435334330.png

It looks like this 


JooRodrigues_1-1722435451214.png

 

Is there a way to make that Text1 (SSC) into an aggregator, from wich I could expand, or collapse, the columns, like a tree?

2 replies

T
TheJonG
July 31, 2024

I think you'd have to create alternate hierarchies of the Entities grouped by Text1 although this would create maintenance and require an additional Consolidation/Aggregation.

Another way would be to setup the Text properties as an attribute dimension and then link those members to the Entity Text 1.


TheJonG_0-1722442366210.png

 

M
Matt-Ha
July 31, 2024

I haven't found a way out of the box to do it.

Like Jon G said one way would be to use attributes.

Another option would be to create a UD8 hierarchy with the members as the Text2 values you'd like to aggregate by. So in your case, one member would be SSC. Those U8s would be set as dynamic calcs, and in the calc you could calculate the sums in memory. So if you pulled E#Tot_MainEntity:U8#SSC, on runtime the calc would pull the base members of Tot_MainEntity and loop over those to get you a total to return.

Terms & ConditionsAccessibility statement