Bex reports are slow

[Former Member]

Hi All,

I am struggling with this problem.

BEx reports are taking lot of time to execute & it is running slow.

Please tell me reason why this can happen & possibe solution.

Kindly let me know.

Thanks.

[Former Member]

take out few char IO from rows and put them into the free char then try drill down on those char IO instead of showing them into report in one go, and try to run the report in chunks like dont run the report for more than let say 6 months, and you can do one thing is you can reduce the no. of selections like restricting any perticular char to a perticular selection.

Regards,

Jai

[Former Member]

Is this happening in your system or in all other computers too?

Are you executing the reports in browser?

if you alone is facing this issue, it might be the problem with your browser.

If everyone is facing this issue, it depends on the restrictions in the query and the selection criteria in the variable screen.

[yogesh8984]

Hi,

There can be many reasons for slow response.

1. Try putting the values in all selection variables while executing report.

2. You may have to add more selection variables to get the limited data from the server.

3. You can use partitioning feature (For Cubes) or secondary indices (For ODSes) to improve the performance.

Please check what is feasible for you.

Hope this info helps you.

Regards,

Yogesh.

[Former Member]

Hi,

Can we see what are the changes done by user last time in this query.

Because i can see date when changes were done but i want to see what are changes done.

Thanks.

[yogesh8984]

Hi,

You can find the "last change" information in the Query Properties. When you open the query in BEx, click on "Query Properties" tab. There you will find the "last change" information.

Regards,

Yogesh.

[Former Member]

You can find the user who had last changed but you cannot find the changes done.

If the same query is present in another system which is not changed i.e., earlier one, cross check with that query and find out the difference. By this you can find the changes done.

So, we should follow a process that we should save the query first and then save the changes to the new one rather than disturbing the original query.

[Former Member]

Hi Anand,

One of the reasons could be due to some complicated calculations that you might be using in your report.Are you using any formulas/calculated key figures?.

Also there could be large amount of data for the selection specified by you.Try to restrict the data by specifying more selections and check if there is any change.

Hope it helps.

[Former Member]

Hi,

Can we some how see the last changes done to the query by another user. I know when changes were made but i dont know what are those changes done by user.

Is it possible.

Thanks.

[Former Member]

Hi Anand,

It is not possible to get the list of changes made to a query by another user.You can only get the name of the person who changed it.

If your query was transported to the next system before the changes, and the new changes are yet to be transported, you can compare your query with the one present in the next system.Otherwise it is impossible to get the list of changes based on a user.

Hope it helps.