Skip to Content
Former Member
Sep 14, 2005 at 03:59 AM

Deactivate Hierarchy symbols in excel


Does anyone know how to remove the display of the Hierarchy symbols within bex analyser.

Our problem is that we have a large hierarchy which is expanded by another hierarchy, in total about 2000 rows and 9 columns. Within ST03N it can be seen that 98% of approximate 600sec processing time is occupied by the front end. The front end PC is appropriately spec'd ~ less than 3 months old and is consistent with other users.

From what I can tell this performance is related to the display of the many hierarchy symbols in excel. So I would like to know if I could remove them. I am aware that they can be changed, however no real performance improvement is noticed.

We are on BW 3.0B SP20.