Aggregation Weight Display in Cube View

Hi Ben,

Makes sense to follow the path that Jack suggested, in case the account are available through multiple hierarchies and with different aggregation weights.

To avoid the setup of manual cube view rows, you could consider writing an XFBR function that you can use in your cube view. Conceptually you could:

1. Pass through a top account in the XFBR function from where you want to build up the cube view;
2. In the XFBR function, identify the children of the top account. At this stage, you know the parent of each child;
3. Build a recursive function to get the children of the children, until you have reached base level. If the query calls itself, you will have to make sure you pass on the child as a parent, which allows you to work with the unique parent-child relationships;
4. In the recursive function you can create a member filter where you would add the GetDataCell suggestion from Jack for each account and you can pass on the parent account as a parameter;
5. End result would be a list of all accounts under a certain top account with the aggregation weights, relative to that structure.

With this approach you can avoid static rows in the cube view, but will not have any indentation (not sure if that would matter).

Regards,
Paul