SQL table up to date from IBM COGNOS TM1 cube

Post Reply
Azharuddin
Posts: 1
Joined: Wed May 31, 2017 7:54 am
OLAP Product: SAP BPC
Version: 10.0
Excel Version: 2016

SQL table up to date from IBM COGNOS TM1 cube

Post by Azharuddin »

Can anyone recommand a good approach to keep an SQL table updated with the data from IBM COGNOS TM1 cube ? is there any way to create a process that runs daily and extract data from TM1 in xls or csv format? If I have the files it's simple with an ETL process and an SSIS package...
Edward Stuart
Community Contributor
Posts: 247
Joined: Tue Nov 01, 2011 10:31 am
OLAP Product: TM1
Version: All
Excel Version: All
Location: Manchester
Contact:

Re: SQL table up to date from IBM COGNOS TM1 cube

Post by Edward Stuart »

Have you tried looking here?
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: SQL table up to date from IBM COGNOS TM1 cube

Post by lotsaram »

712.gif
712.gif (62.82 KiB) Viewed 2231 times
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Post Reply