How to join two workbooks in one?
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
Muralikrishnan E replied
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.