Quickly promote or copy a PAW book

Ideas and tips for enhancing your TM1 application
Post Reply
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Quickly promote or copy a PAW book

Post by gtonkin »

Ever needed to quickly copy a PAW Book from Dev to Prod or Prod to Dev?
You could use the Lifecycle Management to do this but it takes time to select, map, copy over move etc. etc.

To short-circuit this you could simply copy the code behind the book and paste it into the new book.

Access the book specification using Ctrl + Q + /
Copy this to your clipboard.
Create a new book in the environment you need it, open up the board specification and update from your clipboard.
Update the specification then Save your book into the desired location and you are done.

For the more adventurous, you can edit the specification to reference control objects e.g. when syncing action buttons and applying security requiring }Clients or }Groups.

Also useful should you have some code snippets you want to inject into the sheets/books e.g. an image at a certain location, similar to pinned objects.
Wim Gielis
MVP
Posts: 3103
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Quickly promote or copy a PAW book

Post by Wim Gielis »

Thans you George. Just to add that on my keyboard it is Ctrl-q-:
This is an Azerty keyboard, which is popular in my country.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Adam
Posts: 94
Joined: Wed Apr 03, 2019 12:10 am
OLAP Product: IBM PA
Version: 2.0.9.x
Excel Version: Microsoft 365 x64

Re: Quickly promote or copy a PAW book

Post by Adam »

This is a good one, not sure why this is hidden away. Might be a good IBM PA AMA question for next time.

I’ve also used this for pixel perfect column width across sheets, which can be important for some users.
Take care.
Adam
ascheevel
Community Contributor
Posts: 286
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: PA 2.0.9.1
Excel Version: 365
Location: Minneapolis, USA

Re: Quickly promote or copy a PAW book

Post by ascheevel »

Great stuff, thanks for sharing George. This must be a small product of the initiative to bring the cognos and and planning analytics teams closer together. Copying report specifications in report studio was a much appreciated feature.
Emixam
Posts: 139
Joined: Tue May 21, 2019 3:33 pm
OLAP Product: TM1
Version: PA 2.0.x
Excel Version: 2016
Location: The Internet

Re: Quickly promote or copy a PAW book

Post by Emixam »

This is a life changer !! Thanks a lot for sharing
David Usherwood
Site Admin
Posts: 1453
Joined: Wed May 28, 2008 9:09 am

Re: Quickly promote or copy a PAW book

Post by David Usherwood »

I've just done some testing of this. My findings so for are that it works for pointing an existing briefing (or copy) to the same cube on another server, but it does not work for pointing an existing briefing (or copy) to a second cube (with the same dimensions and view name). Clicking the Settings coglike icon on the right and selecting Context Information shows a connection to the old cube.
Suggestions welcome. This would be very handy for testing and reconcilation.
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Quickly promote or copy a PAW book

Post by gtonkin »

Should all be text in the JSON file - have you done a find and replace?

Trick is to find the correct reference to update and there is possibly also some kind of save state which may be base 64 encoded (and may have a reference that you need to tweak too). I have not tried to update to a different cube myself so guesswork at this stage.

Edit: The query state is Base64 encoded. If you copy it out to a site like https://base64.guru/converter/decode/file, you can save the resulting file which is in fact a Zip file. From there you can unzip to view the query.json file within the archive. This does seem to keep the various widget settings.
Adam
Posts: 94
Joined: Wed Apr 03, 2019 12:10 am
OLAP Product: IBM PA
Version: 2.0.9.x
Excel Version: Microsoft 365 x64

Re: Quickly promote or copy a PAW book

Post by Adam »

Nice little use case:

When creating an action button in PAW and you link it to a process, when setting parameter picklist, you cannot specify control dimension, e.g. }Clients.

So pick some other dimension, then do Ctrl + Q + / and you can find/replace all references of the dummy dimension with the intended control dimension, e.g. }Clients.

Works like a charm!
Take care.
Adam
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Quickly promote or copy a PAW book

Post by Steve Rowe »

Worth noting that I can not get this to work with workbenches, rather annoying.

Does anyone know of a method of promoting / repointing a workbench?

They do not show up in Lifecycle Management either
Technical Director
www.infocat.co.uk
Post Reply