Syensqo IS - Customer Support

Page tree

Versions Compared

Old Version 4

changes.mady.by.user PERRILLAT-COLLOMB, Nathalie

Saved on

compared with

New Version Current

changes.mady.by.user PERRILLAT-COLLOMB, Nathalie

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

Image Removed

1.    

Image Added

2-Create (if not existing) a fix header 

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

Image Removed

Image Added

2 .

3-Prepare the new query to fit the existing format

Copy-paste the header in a new tab 

Image Removed

Image Removed

Image Added


Display the 'Design Panel' (1)

Open the 'Component' tab (2)

Image Removed Add

Image Added



4-Add a new data source

Image Modified

Select :

5-Select the new core query 

For example BW-DP-Budget Review (Core query)

Image Modified

6-Check/update the selection

Image Modified

7-Insert a Crosstab to see the query result

Image Modified

8-Insert the query in the new tab below the header

Image Removed

Image Added

9-Adjust the new query to have the same data

Image ModifiedImage Modified

10-Delete the cross tab from the old query

For example delete the cross tab from the Demand Review

Image Modified