SAP BW and TM1 through Cognos BI

Post Reply
Wim Gielis
MVP
Posts: 1784
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

SAP BW and TM1 through Cognos BI

Post by Wim Gielis » Mon Apr 09, 2018 12:24 pm

Hi all,

At a major TM1 site where I spend a good deal of my time, they have SAP ECC, SAP BW and this is coming to TM1 through the use of both:
1. Cognos BI (which dumps data extracts from SAP BW queries overnight into text files)
2. the TM1 Package Connector, straight to SAP BW.

Both metadata and data will be transferred to TM1.

In the past, only option 2 was chosen, but the night window was too short to handle it all. Since end of last year, users can still launch TI processes with option 2, and at night we schedule jobs in BI to do the exports.

This more or less works but nevertheless we get a number of strange errors. Sometimes in a night all of the jobs (about 20-30 jobs) fail, the night after all are fine, and yet another night some jobs fail and some succeed.

It is for example:
- the connection from BI to SAP BW cannot be established, while the network shows no problems whatsoever
- memory issues
- the errors below.

Does anyone know more about this connection and how we can improve it ? Technical references maybe?
Do we have specific error log files other than the ones displayed in Cognos Connection with the report / task itself ?
Anyone having experience with this kind of errors ?

Cognos C10.2.1 is used, TM1 10.2.2 FP4.

Thanks a lot !

Wim
00.png
00.png (56.01 KiB) Viewed 244 times
and
01.png
01.png (81.78 KiB) Viewed 244 times
and
02.png
02.png (78.84 KiB) Viewed 244 times
Last edited by Wim Gielis on Mon Apr 09, 2018 2:12 pm, edited 3 times in total.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 105 TM1 articles and a lot of custom code
Newest blog article: Looping over input files

Wim Gielis
MVP
Posts: 1784
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: SAP BW and TM1 through Cognos BI

Post by Wim Gielis » Mon Apr 09, 2018 12:25 pm

And 2 more screenshots:
03.png
03.png (46.05 KiB) Viewed 242 times
and
04.png
04.png (66.88 KiB) Viewed 242 times
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 105 TM1 articles and a lot of custom code
Newest blog article: Looping over input files

Post Reply