Quickly promote or copy a PAW book

Ideas and tips for enhancing your TM1 application
Post Reply
User avatar
Posts: 1071
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL; PAW 2.0.71
Excel Version: Office 365 64-bit
Location: JHB, South Africa

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
Posts: 2912
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL
Excel Version: Microsoft 365
Location: Brussels, Belgium

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

Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 120 TM1 articles and a lot of custom code
Newest blog article: Documenting processes and rules https://github.com/wimgielis
Posts: 72
Joined: Wed Apr 03, 2019 12:10 am
OLAP Product: IBM PA
Version: 2.0.9.x
Excel Version: Office 365 x32

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.
Community Contributor
Posts: 216
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: PA
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.
Posts: 131
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
Post Reply