Hi Aleksandre,
To clarify on CA, you can create reports in CA based on TM1 content and burst (distribute) the CA report out, but the CA report cannot pick up TM1 generated reports. You connect to a TM1 package which will contain one or more cubes and from there you can select the elements / subsets you require. The TM1 Package can be created using Framework Manager or directly from the TM1/PA connection setup in Cognos Analytics Administration.
The only way I know to get your TM1 generated reports into CA would be to use TM1Web API and embed TM1Web with a CA report using iFrames and pass the title elements within the URL for TM1Web where applicable. This method also gives CA users write back capability but you should check if this would cause any licencing issues with IBM or IBM Partner.
Using CA can yield a more flexible UI/higher report finish but it would require significant development time, and would be a significant learning curve.
And if you're trying to set up a connection to Planning Analytics or TM1 in CA for the first time, don't forget to migrate the IBMTM1.arm (SSL) from Planning Analytics into the Java keystore for Cognos Analytics if your model uses usessl=T property, otherwise you'll just get a connection error.
------------------------------
Simon Saul
------------------------------
Original Message:
Sent: Tue March 16, 2021 12:28 PM
From: Aleksandre Metreveli
Subject: Report Distribution
Thank you all for your responses!
Robby, yes we are using CA as well. So are you saying that if CA is connected to TM1, we can distribute TM1 reports thru CA?
Could you please elaborate little bit on this? Appreciate your help!
------------------------------
Aleksandre Metreveli
Original Message:
Sent: Tue March 16, 2021 01:16 AM
From: Robby Meyers
Subject: Report Distribution
You could always use Cognos Analytics. If you are on premise you can use CA for no additional charge as long as it only connects to TM1. If CA isn't an option then you could use a TI on a chore to execute your commands to update your excel files and email them out.
Robby
Original Message:
Sent: 3/15/2021 1:38:00 PM
From: Aleksandre Metreveli
Subject: Report Distribution
Hi All,
Just wondering if planning analytics allows you to set up auto report distribution for dynamic reports.
We want to distribute financial reports to specific recipients on 17th day of each month..
Please let me know if that is a possibility.. Thanks you for your help!
------------------------------
Aleksandre Metreveli
------------------------------
#PlanningAnalyticswithWatson