Question Re: Improve performance in Web Intelligence Drill Down in Technology Q&A

Improve performance in Web Intelligence Drill Down

Former Member — Wed, 27 Oct 2010 14:26:50 GMT

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

Re: Improve performance in Web Intelligence Drill Down

Former Member — Wed, 27 Oct 2010 14:55:19 GMT

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)

Re: Improve performance in Web Intelligence Drill Down

Former Member — Thu, 28 Oct 2010 15:58:10 GMT

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

Re: Improve performance in Web Intelligence Drill Down

Former Member — Thu, 28 Oct 2010 19:35:11 GMT

What database are you using?

Re: Improve performance in Web Intelligence Drill Down

Former Member — Thu, 28 Oct 2010 21:37:06 GMT

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

Re: Improve performance in Web Intelligence Drill Down

Former Member — Thu, 28 Oct 2010 21:45:22 GMT

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.

Re: Improve performance in Web Intelligence Drill Down

Former Member — Fri, 29 Oct 2010 21:38:58 GMT

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