Save via Excel-Toolbar vs. Save via BEx-Toolbar (InfoCatalog)

[Former Member]

Hi all,

in the last time I occupy oneself with BW and BEx to automate querys. I think there are two ways to save an Excel-Workbook:

1. you can save it as workbook in the InfoCatalog (saveoption in the BEx toolbar)

2. or save it classical as .xls by Excel

Now my question: there are any reasons against Variant 2? I find it’s a little easier to write only one Excel-Workbook-Macro. For Variant 1 I need 2 Workbooks, one „Autostart-Workbook“ that opens the sapbex.xla and the second Workbook from the InfoCatalog.

Is the choice only a matter of taste?

Best regards

Tim

Message was edited by:

Tim Loeck

[Former Member · Accepted solution]

Not so simple Tim when save it by saveoption in the BEx toolbar this means you are saving your definition in BW server's metadata repository. So you store it more secure place.

But saving it localy with excel, this means you can loose it easily anything happens to local pc or network drive.

Sarhan.

[Former Member · Accepted solution]

Hello Sarhan,

thank you for the answer.

The security of the data storage is one site, but are there any reasons against Variant 2 because of missing functions? For example the option "refresh query after opening workbook" won’t work with Variant 2. It’s not a big problem, because you can manage it with a VBA-Code. Are with Variant 2 anticipate any trouble? Has anybody experience with Varinat 2?

Best regards

Tim

[Former Member · Accepted solution]

Hello again Tim,

As you said that in option 2, you are alone with all that BW related functions. Because the workbook is not recognized by BW metadata, so you have to anything regarding BW server, you have to handle it, this is main challenge.

Sarhan.

[Former Member · Accepted solution]

Hello Sarhan,

hope, you had a nice weekend and thank you for the answers.

Best regards

Tim