SAP BW and TM1 through Cognos BI

Post Reply
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

SAP BW and TM1 through Cognos BI

Post by Wim Gielis »

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 1647 times
and
01.png
01.png (81.78 KiB) Viewed 1647 times
and
02.png
02.png (78.84 KiB) Viewed 1647 times
Last edited by Wim Gielis on Mon Apr 09, 2018 2:12 pm, edited 3 times in total.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: SAP BW and TM1 through Cognos BI

Post by Wim Gielis »

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

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply