Page tree


User case :

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


1-Open the workbook you want to adapt

2-Create (if not existing) a fix header 

Add lines on the top and copy/paste your header lines

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)



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

The best way to get IT support is to use the new Service One Platform.