Bex Report Performance

[former_member194802]

Dear Friends,

I would like to know is the complex authorizations can also cause the Bex report performance.

One of my scenerio is like there are two users A & B

A is having relevant authorizations for reporting, Drill down etc which are required.

B is having SAP All authorization.

When the same report has been executed by both users on the same system.

the data retrieved by user B(SAP_ALL authorization) is quite faster than User A.

Its like ther diffference of about 10 minutes.

There are some exsclude selections in report.

So my conclusion is like the complex authorizations do also hampers the query performance.

Please confirm & share your views.

Thanks & Best Regards,

Vivek Tripathi

+91-9372313000

[former_member194802]

SOlved issue

[Former Member]

Hi Vivek

Can you help us understand what was the exact problem and how you resolved it / solution at Extraction / Modeling / Reporting end.

I have a quite similiar issue with my report i have Header + Item report on Infoset

u2022 Header report takes seconds and item report takes minutes

u2022 The same report executed with exact parameter has inconsistent performance results meaning one time it takes 1 minutes next time same report same user and same authorization takes 5 minutes.

Any help on this would be really greatfull. Suspecting is not an issue with the report at all , as no changes happened between the pre and post check.

_Additional Information : _

We Create Secondary -Bitmap index every week end i do not see that is one of the route cause.

Except that we have our regular daily loads that are running for master data loads and transaction data loads in series.

Thanks in Advance.

Much Regards

Jagadish Thirumalachetty.

Edited by: Jagadish Thirumalachetty on Jul 14, 2010 1:35 PM