Skip to Content
avatar image
Former Member

BEx Query OLAP performance Issues

Oct 21, 2016 at 04:33 PM | 81 Views

I have a BEx query that when I try to bring in two hierarchies it is spending forever on the OLAP level. It selects the records from the database in 30 seconds. It then loops through an autogenerated program millions of times to aggregate to the hierarchy level and then renders 500 cells in rsrt.

This process takes 16 minutes and it reads 3 millions lines from the database. The problem I have is why does this happen and how can I help improve it? If I use EPM which uses MDX on the same query and tables it runs in 1 minute.

BW Business Explorer (SAP BEx)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 01, 2016 at 05:16 PM

    This seems to be how OLAP processes the data. It is running quickly but it is parsing a lot of data to aggregate two hierarchies.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Diego Seben
    Dec 02, 2016 at 07:00 PM

    Hi,

    It is difficult to try to come into conclusions here, just based with these information. It would be required to review in more details. I suggest you to record a ST12 trace with your team and review it afterwards to see where the performance is happening.

    Also, run the query and check the statistics, read KBA 1707239 - Analyze Query Performance with Statistics Data in RSRT and verify KBAs 1681396 - Query Performance, 1879725 - Query Memory Consumption.

    Thanks,

    Diego Seben

    Add comment
    10|10000 characters needed characters exceeded