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.