I am facing an issue using hierarchies. We do have several accounts with bookings from an ERP system.
Those are coming through fact table.
Controllers now are putting all accounts in a tree structure containing several levels with bottom elements
I managed to get a list box in hierarchical view but can not display figures in a table chart.
Next to that this tree structure is changing two to three times a year. So I need to provide a selection
option for the user selecting the tree structure the figures should be shown in.
So, I do have facts but just would like to change the view on it.
Hope anybody can help.