BusinessObjects Board

SAP BusinessObjects Analysis, background processing

other Xcelsius - Crystal Dashboard Design
#1

Hi,

I have created a large report in Analysis that runs poor because of lot of datasources, and therefore many sheets.

Does anyone have an idea if it is possible to do background processing in this tool, like it is possible in Design Studio?

Currently my report only have a couple of datasources on sheet 1, that I want to load immediately and then when those are loaded I want to display the sheet. Afterwards I want to have other datasources for other sheets to load in background.

Any help appreciated.

/Mick

mkan (BOB member since 2016-03-03)

#2

Mick,
I don’t think the standard product support this, but I assume youre talking about analysis office, so you may be able to use some form of excel macro/vba to control this.

also how many rows are you returning ?

Thanks

Al.

Botfield77 (BOB member since 2016-10-04)

#3

Hi Al,

yes I am refering to analysis for office. If anybody knows some from vba to control it, that would be great.

Now sure about the rows. I have 5 sheets with approx 10 datasources on each sheet. (I would limit the datasource use on main sheet, if background processing via VBA is possible)

mkan (BOB member since 2016-03-03)

#4

so this appears to be 50 query executions ? (5x10)

that’s a helluva lot of data without even talking about volumes.

seems better to just schedule the refresh of the workbook - then you don’t need to worry about refresh times ?

Botfield77 (BOB member since 2016-10-04)

#5

Yes approx. 50 executions :slight_smile:

Scheduling is atm not an option as we do not have a precalculation server installed as far as I know.

mkan (BOB member since 2016-03-03)

#6

if you have a BO Server you can calculate it via scheduling ,you don’t need the BW Pecalculation server.

Botfield77 (BOB member since 2016-10-04)