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 » Wed Jun 13, 2018 8:55 am

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: 214
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 » Wed Jun 13, 2018 9:27 am

Have you tried looking here?

lotsaram
MVP
Posts: 3070
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TM1, CX
Version: TM1 10.2.2 PA 2.0x
Excel Version: 2010 2013 365
Location: Switzerland

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

Post by lotsaram » Wed Jun 13, 2018 10:27 am

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

Post Reply