Workbooks

[Former Member]

Hello,

We created a workbook with several queries inside.

After saving the workbook as Excel file (.XLS) some of the queries are not recognized and we cant refresh or open them.

Pease help,

Amir

[Former Member]

Hi,

when u open BW 3.x workbooks and save them in BI 7.0 BEx , you can not open those in BW 3.X versions.

Query, Reporting & Analysis Design

1. Vista & Office 2007 support (Stack 12, only as of BI 7.0 ADDON FOR

SAP GUI 7.10 Patch 1 !)

2. BEx 7.0 (2004s) Tools support for combination of GUI 7.10/Windows

Vista/Office 2003

3. BEx 7.0 (2004s) Tools support for combination of GUI 7.10/Windows

Vista/Office 2007

4. Remark: new files format (OfficeXML) not supported yet (Stack 14)

5. Please note that BEx 7.0 (2004s) tools wonu2019t be supported for Vista in

combination with GUI 6.40

6. Please note that BEx 7.0 (2004s) tools wonu2019t be supported for Office 2007

in combination with GUI 6.40

so ask your client to check these ..

Hope this helps u..

Best Regards,

VVenkat..

[Former Member]

Hello,

I forgot to mention that this problem happends only in 7.0 workbooks. We are working with 3.X workbooks for a long time and the workbooks never lost the connection to one of the queries.

In 3.X workbook, You can save the workbbok in a role (sa suggested by Praveen) or you can save them localy. Both ways should work. Is this functionality changed in 7.0 workbooks?

Thank you,

Amir

[former_member205352]

Hmm just a minute can you tell me the steps you followed to insert queries in new sheets of the workbook.

Its different in BI 7.0, as you dont have "Insert Query" (in 3.X) option.

[Former Member]

Hi Praveen,

I added a new Data Provider to the workbook and connected it to the wanted query and to the analysis grid.

all the queries in the workbook are refreshed. but after i save it localy sometimes, some of the queries disconnect from the table and i have to insert them again (create a new analysis grid).

Thanks,

Amir

[former_member205352]

By saving locally you mean saving it as local file ?

Even if you save it locally and later open it with Bex analyzer (7.0) it should open (as long you have saved it to roles or favorites before).

Does it work fine when you choose "Refresh workbook on open" property and open it using

Open Workbook option in Bex ?

Edited by: Praveen G on Jan 13, 2009 8:18 AM

[Former Member]

In BW 3.X I didnt have to save it to roles or favorites .I could save it only to a local file.

[former_member205352]

You used Bex toolbar to "save workbook" or used the normal excel "Save" ???

You need to use Bex toolbar to save.