...
You have build a workbook on an obsolete core query and you want to move your workbook on a new core query without recreating it from scratch
0. Open 1-Open the workbook you want to adapt |
|
1. 2-Create (if not existing) a fix header | Add lines on the top and copy/paste your header lines
|
2 . 3-Prepare the new query to fit the existing format | Copy-paste the header in a new tab
Display the 'Design Panel' (1) Open the 'Component' tab (2)
|
Add 4-Add a new data source |
|
5-Select the new core query | For example BW-DP-Budget Review (Core query)
|
6-Check/update the selection |
|
7-Insert a Crosstab to see the query result |
|
8-Insert the query in the new tab below the header |
|
9-Adjust the new query to have the same data |
|
10-Delete the cross tab from the old query | For example delete the cross tab from the Demand Review
|
