Exporting WebSheets( to pdf or Excel snapshot) via TI

Post Reply
jjramirez
Posts: 33
Joined: Fri Jan 13, 2017 12:33 pm
OLAP Product: IBM Planning Analytics/TM1
Version: 2.0.9.15
Excel Version: Excel 2019

Exporting WebSheets( to pdf or Excel snapshot) via TI

Post by jjramirez »

Hi,
I am trying to find a way to export a published websheet to a pdf or Excel snapshot via turbointegrator but I cannot find any function to allow me that.
Anybody has an idea to achieve it?
burnstripe
Regular Participant
Posts: 218
Joined: Wed May 06, 2020 2:58 pm
OLAP Product: Planning Analytics
Version: 2.0.9
Excel Version: 2016

Re: Exporting WebSheets( to pdf or Excel snapshot) via TI

Post by burnstripe »

Right now there is no function to achieve this natively.

Bursting however is on ibm's road map for Q2 2025
https://bigblue.aha.io/published/30f7b7 ... 10d?page=4

"Workspace book burst includes data export | Workspace book bursts can be configured to include both PDFs of tabs in books and full export of data from selected cube view widgets."

"Workspace book burst service and endpoint | Workspace book bursting can be preconfigured and executed non-interactively. This will support large and complex bursts and uses cases that require automation."

Until this arrives, one could create a script which opens excel, connects to tm1, opens report, refresh report, convert to static, save report.

The script could then be executed within a ti process

But I don't have a script to hand to do this
jjramirez
Posts: 33
Joined: Fri Jan 13, 2017 12:33 pm
OLAP Product: IBM Planning Analytics/TM1
Version: 2.0.9.15
Excel Version: Excel 2019

Re: Exporting WebSheets( to pdf or Excel snapshot) via TI

Post by jjramirez »

Hi burnstripe,

It's a good new to read this is on IBM road map for 2025.
And yes, the option you proposed in the meanwhile is what I am doing right now. But I need to run this without external scripts... So I will stay with this actual process and wait for that new feature in PAW.

Thank you very much for your response.
Post Reply