Calculation Performance

building reports desktopintelligence
1

Hi,

I’ve been using Business Objects for a few months now and have found it to impressive and frustrating in about equal measures. I would be interested to find out what makes Business Objects perform so badly when doing local processing. The reports we have been writing are full of ‘exceptions’ - lots of ‘If then else’ statements, variables, derived variables, custom sorts and formulas. Sometimes it seems maddeningly slow… it seems to like recalculating everything the moment anything changes, even things like changing a bit of text! Switching to the ‘no data’ mode does help though.

From a quick scan through the list archives, the use of FormatNumber and FormatDate has been pointed out as being things that slow down calculation performance. What else should I try to avoid?

Also, has anyone else noticed BO seems to hog memory after opening big reports? After opening, printing and closing 12 or so reports, my PC seems like it’s slowed down. Will a DAS run for months without problems? We’re aiming to have DAS set up to run 60 reports automatically each month.

Regards

Giles Ward

Listserv Archives (BOB member since 2002-06-25)

2

Giles wrote: I would be interested to find out what makes Business Objects perform so badly when doing local processing.

Hi Giles,

Maybe this is something you already know…

If you create measure objects, make sure the sum (or count, avg etc.) function is also in the select statement. This way the grouping will be done by your database and the number of rows returned to your cube will be smaller. Calculations BO has to perform within the cube will perform faster.

Best regards,

Susanne Bakker
ING Netherlands.

Listserv Archives (BOB member since 2002-06-25)