Frontend Performance

[Former Member]

Hallo Experts,

we just have a query with a really bad performance.

I made ST03N (experts) and got the following result:

%init: 0,02

%OLAP: 1,26

%DB: 1,08

%Front-End: 97,43

% master data: 0,21

so I know the problem is the Front-End Performance.

But know i do´t really what i can do.

Thanks Santra

[Former Member]

There is a good document on front-end performance on SAPNET (alias /bi) under the Performance Heading entitled Frontend Performance

Use following link to get there.

https://websmp105.sap-ag.de/~sapidb/011000358700001394912002

Regards

[Former Member]

Thanks for the link, but i can´t find some solution in this paper i know just know that the SAP Performance TEST was done with queries that have 1500 and 10000 result cells. In our case the query has 153119 result cells (QNUMCELLS). So what have i to do?

Thanks Santra

[Former Member]

BEx with a hierarchy used in the query/wkbk?

If so, the rendering of the hierarchy is probably the culprit for the Frontend time being high. You could verify this by removing the hierarchy and checking the timings. The next thing to do is verify the frontend patch level you are using (could be different on each users PC). There have been some updates to the frontend patch levels that can improve the frontend time dramatically for queries with hierarchies.

Think it was 3.5 FEP 5 and 3.1 FEP 15 (or maybe 16?) that provided the change for hierarchy display. As an interim solution to updating the FEP on a client PC, you could install just the sapbex.xla file that was part of the patch.

I'll see if I can track the Note down.

[Former Member]

Check this thread for more discussion and a couple of Note references