Improve performance in Web Intelligence Drill Down

[Former Member]

Hello,

I have a webi report in XI 3.1 SP3 that uses a hierarchy (Custom Universe Hierarchy), Region -> Country -> Customer, but when I drill down through the options is very slow, is like 5 minutes doing that. The "Use Query Drill" is enable by default as recomendation of a perfomance guide.

What else can I do? Why I have this problem?, I don't have a big amount of data.

Thanks & Regards

SU

[Former Member · Accepted solution]

Hey SU,

Data is less okay, what about rest of the objects?? (Dim, Measure & Detail obj's in report)

Do you have Complex Query filters?

Any Prompts?? (@Universe & @Query)

Do you have all Custom Hierarchy objects in Report??

Gracias...!!

Let's play with Aurora (BO XI 4.0)

[Former Member · Accepted solution]

Hello,

Thanks for your response,

Dim (9 in Data Available - 1 in the report - Region)

Measure (3 Available - 1 in the report - Quantity)

Detail obj's in report (0) Region/ Quantity is my report

Do you have Complex Query filters? No

Any Prompts?? (@Universe & @Query) No Prompts

Do you have all Custom Hierarchy objects in Report?

Yes, the hierarchy is Region -> Country -> Customer

Also, do you know when Aurora is going to be available?

Thanks & Regards

SU

[Former Member · Accepted solution]

What database are you using?

[Former Member · Accepted solution]

Hello Prasun,

I'm using for BOE - SQl Server 2008 and I'm getting the information from a SAP BW 7.0 System

Thanks & Regars

SU

[Former Member · Accepted solution]

If you have followed the best practice document in your design, then you are left with the following few options.

1. Try using the Query Cache option in BW.

2. Try creating aggregates in the cubes.

However, try finding the performance in SAP BI server when you are firing the queries in BO. This will give you understanding on where the query is spending its time.

[Former Member · Accepted solution]

Hello,

Thanks for your ideas, I 've applied a combination of your recommendations and now is working better. Also another thing I've done is in the universe improve the parameter fetch array size to 200.

Thanks & Regards

SU