We currently operate WEBI Reports on BOXI Rel 2.0., but are experiencing difficulties with report sizes and performance. Most of our reports are approximately 20Mb in size, but we have some approaching 100MB, 20 times the Business Objects recommendatuions. We have a hierarchy of offices, regions etc., totalling to a National figure, data monthly building to up to 12 months.
Original advice from Business Objects was to use dimensionally modelled data, but in order to address some performance issues we have been creating “Materialised Views” with query refresh in ORACLE. These necessarilly “flatten” the data.
Grateful for any advice on how to improve performance and find out what others have experienced. Is Dimensional best ?
Check out the following things in report level for performance issues!!
Are you using Auto Height option?
Are you using Auto Width option?
Are you using Wrap Text option?
These options would need more time to process the report, there on it takes more time. By removing these options would show an signification improvement in the performance for large reports.
Check out the following things in database level.
Did you run Explain Plan and checked the performance bottlenecks?
Dimensionally modelled data will most likely reduce your query time, but not necessarily the size of your reports, which is for the most part determined by the number of records you retrieve and the formatting you’ve applied. Data marts are almost always synonymous to dimensionally modeled data, instead of normalised data.
How many pages do your reports have? Sounds like you are essentially doing a data extract of your database or that the universe measures are not defined properly using a SQL aggregate function. Also look at the feature of drilling and drill filters in a Webi document as well as parameterizing your Webi documents by using Prompts.
Dimensional modelling is a standard (see R. Kimball), you could also look at deploying OLAP technology or in-memory technology for faster query execution time (see for example SAP BW Accelerator plug-in/add-on for SAP BW, etc.)
(BOB member since 2008-08-20)
(BOB member since 2006-08-31)
(BOB member since 2007-05-31)
(BOB member since 2002-06-20)