Skip to Content
0
Former Member
Apr 10, 2012 at 10:31 AM

RCA on BW-BO long running Report

65 Views

Hello Gurus,

I have created a Business layer (universe) through IDT on top of a BW - DSO. DSO has 5 fields in Data part, 1 in Key part and 2 Measures.

Data volume is just 55 records. It's a simple star schema between Fact table and some dimension tables.

When i created a query on top of the business layer, it takes 77000 ms just to retrieve 17 rows with 3 column to display.

In Webi rich client too the run time goes like this, i am afraid what would be the situation for my gigantic cubes how long the query will run.

Being a BW consultant, i do remember our ST12, ST05 work process level,SQL and ABAP trace to do a Root cause Analysis. Does BO provides anything similar to that which would give me a breakup of the runtimes.

Can we activate any log in CMS to do a diagnosis. Please suggest.

Thanks,

Tilak