Page 1 of 1
Exporting WebSheets( to pdf or Excel snapshot) via TI
Posted: Tue Oct 22, 2024 6:52 pm
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?
Re: Exporting WebSheets( to pdf or Excel snapshot) via TI
Posted: Tue Oct 22, 2024 9:36 pm
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
Re: Exporting WebSheets( to pdf or Excel snapshot) via TI
Posted: Thu Oct 31, 2024 3:37 pm
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.