Hide specific leafs and parents from a hierarchy
We have been working a lot with HANA, Hierarchies and Design Studio these last months but we have a problem quite challenging. We have a hierarchy like this in our DataSource:
We would like to hide (and not to filter, this is important) some of the nodes at different levels. For example, we would like to show a simple crosstab with RESULTADO NETO and EBITDA, hiding these nodes: RESULTADO A.I.S., RESULTADO antes extra... and EBIT.
The problem is that if we filter RESULTADO NETO and EBITDA, the crosstab shows RESULTADO NETO but with all the childs not only EBITDA so, you know if there is a way to hide some elements of the hierarchy?
We though of creating a flag attribute for the hierarchy with HANA, so if the flag is 1 for RESULTADO NETO and EBITDA, we filter this flag = 1 instead of the hierarchy, but using this method arises more problems because the measure for RESULTADO NETO is not correct, because filtering makes the current aggregation to forget the others childs of RESULTADO NETO and only sums EBITDA.
We have already searched for similar threads and found some nice addons like Visual BI or ChartPlus, but we think these addons cannot fulfill our requirement.
Thanks in advance for any help you can give us!