Hi All-
We use TM1 in our organization. We would like to pull data into powerpoint slides and wondering if TM1 has any tools (PAx, PAw) that allow pulling data into powerpoint or ms word. Please suggest
TM1 and Powerpoint
-
- MVP
- Posts: 1815
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: TM1 and Powerpoint
It depends largely on what you want to do.
With workspace there is an export as PowerPoint option, so a whole book can be set up in workspace and then exported as a PowerPoint - each tab becomes a slide. Since you can also embed other webpages (non PA pages) in workspace you could theoretically create quite a nice reporting pack with those other webpages linking through to things in share point (as an example) that could hold the other stuff you want in your PowerPoint that isn’t PA based.
If you have a PowerPoint already and just want some tables embedded that are periodically refreshed with data from PA then you could go fairly low tech and just have the PowerPoint table linked to a table of data in an excel file. That excel file could get overwritten as and when required by a chore in PA.
I think word has similar embedding options.
You could link PowerPoint/word directly to PaX but for PaX to update you’d need to be able to logon and I assume you likely have consumers who aren’t users in the PA system. It’s always worth talking to an IBM partner or rep in these sorts of cases as there have been some public cases (such as I believe SAP and Diageo) where the software provider and the customer had differing views of what constitutes a consumer of data and where the licensing requirement line stops.
With workspace there is an export as PowerPoint option, so a whole book can be set up in workspace and then exported as a PowerPoint - each tab becomes a slide. Since you can also embed other webpages (non PA pages) in workspace you could theoretically create quite a nice reporting pack with those other webpages linking through to things in share point (as an example) that could hold the other stuff you want in your PowerPoint that isn’t PA based.
If you have a PowerPoint already and just want some tables embedded that are periodically refreshed with data from PA then you could go fairly low tech and just have the PowerPoint table linked to a table of data in an excel file. That excel file could get overwritten as and when required by a chore in PA.
I think word has similar embedding options.
You could link PowerPoint/word directly to PaX but for PaX to update you’d need to be able to logon and I assume you likely have consumers who aren’t users in the PA system. It’s always worth talking to an IBM partner or rep in these sorts of cases as there have been some public cases (such as I believe SAP and Diageo) where the software provider and the customer had differing views of what constitutes a consumer of data and where the licensing requirement line stops.
Declan Rodger
-
- Posts: 5
- Joined: Mon Feb 11, 2019 8:39 pm
- OLAP Product: TM1
- Version: PAX37
- Excel Version: 2016
Re: TM1 and Powerpoint
Thanks a lot for the reply. I'm wondering if I embed the data from PAx into powerpoint, will it automatically update the data if any things change?