Hierarchy performance issues

[Former Member]

Hi,

We have a customer hierarchy with 5 levels, the lowest level contains 67,000 nodes under which are assigned 450,000 customers.

I can't display the hierarchy or create node variables as my PC falls over when trying to display this amount of data.

Does anyone have any idea how I can improve the performance of this hierarchy?

I appreciate it is huge but it can't be the biggest hierarchy out there.

Many thanks,

Rachael

[Former Member]

Hi Rachael,

If you have problem performances using your hierarchy, you should think about creating a new navigational attribute to your info object. You may also have problems accessing different levels of the hierarchies in an infocube; you can use aggregates to improve your performance. This will cost disk space and aggregate rebuild time, but it gives you a lot of options.

You need to make more analysis on ST03 workload analysis in Expert mode for BW system. It will show where the query takes lot of time Database, OLAP Cache , Master data or front end. Based on that you need to look for solutions.

Hope it helps.

Regards,

Srikanth.

[Former Member]

Maybe a secondary index on the hierarchy table could help.