How to join two workbooks in one?

[former_member199448]

Hi Gurus,

Is it possible to mix two workbooks without loose BW Connection ?

I created one workbook (Called "X") and another workbook (Called "Y"). Each of them is based on the same query.

I used the function copy sheet but after the copy the sheet only have an excel-function

Could you please help finding the solution?

Thank you in advance

Cheers

[hai_murali_here · Accepted solution]

Hi Gilo,

You can't mix the workbooks since they are created seperately and having different workbook IDs,but you can mix the worksheets.

If your requirement is showing the same query in different pages,then you can create a single workbook and have multiple worksheets.Each worksheet will have a same query in different formats.

You can make a copy of the worksheet without losing BW Connection and options.

To perform this,you can go to Tools->Copy Sheet of Analysis Toolbox.This will create an exact copy of worksheet to new sheet,so that you will have same query in different worksheets.I mean Sheet1 and Sheet2 will have same query.

Let me know in case of any clarifications.

Rgds,

Murali

[former_member199448 · Accepted solution]

Hi Thank you for replying.

I know that copy functionality.

What i meant was to join two workbooks which where created separatelly but based on the same query.

Thank you for your Input.

Cheers

Pat

[hai_murali_here · Accepted solution]

Hi,

There is no such functionality available with BEx Analyzer to join two workbooks as such.

You may copy the contents of one workbook and paste it in other to join it.

Rgds,

Murali

[former_member199448 · Accepted solution]

Thank you all for replying.

Cheers