Work book taking longer time to open

[Former Member]

Hi,

We created a workbook and embedded one input ready query in it. The query when executed separately takes 1 minute to load. But when the work book is opened for the same selections, it takes 3-5 mins.

There is no Macros written in the workbook and no functions are called while loading work book.

What might be the reason for this. Is there any way by which we can improve the performance?

Please suggest.

Thanks,

Seetharaman

[Former Member]

Hi there,

Open BEx Analyzer.

Click on global settings (before opening the workbook) and mark the option "Repair workbook while running" (option available since BEx Analyzer support package 5 and above)

Now open the workbook (it will still take the 3-5 minutes).

Now save the workbook

Remove the option you have just marked before ("Repair workbook while running").

Close BEx Analyzer and test it again.

Diogo.

[Former Member]

Hi Diogo,

Is it a one time process..

Thanks,

Seetha

[Former Member]

Hi there,

Yes,

only a time process. This will improve your workbook from that point on.

Diogo.