TM1 connect to a Cognos package

[Wim Gielis]

Hello all

I am trying to load data from a Cognos package (a cube in Powerplay) into a TM1 cube.
I have installed the TM1 Package connector and it works!
I can import all dimensions, but only the measures cannot be selected: if I click on "Select Measures", I get an empty list.
As I cannot select any measure, I have no data at all in my cube

Does anyone have advice on this one? I verified that the measures exist (there should be 6 measures in the Measures dimension), using Powerplay. I add 2 pictures on the TM1 part.

Thanks in advance!

[dr.nybble]

At this time the only OLAP source we permit you to extract fact data from is SAP BW. There is special support for efficient extraction from SAP BW.

The Cognos BI compatible mode query stack does not have good support for null suppression for a variety of sources.

This leads to almost certain failure when extracting facts from PowerCubes or other OLAP sources (either out of memory or waiting forever for the query to complete).

Note: Transformer imposes the same restriction....

You can emit CSV files from Transformer during cube builds for your queries and use that as input to TM1 as an option.

[jim wood]

Indeed Mr Nybble is correct. I recently worked on a project to convert Power Cubes in to TM1 cubes. We simply extracted the content from each Power Play cube and loaded it, then we validated the information through BI. It seems quite a few of the IBM products only communicate on a very adhoc basis. We've seen the same with Controller.

[Wim Gielis]

Okay, thanks for the quick reply. Much appreciated since this is a new area for me.
Looks like I don't have to search anymore in this direction for getting values in the cube.
What's the use of the Package connector if you can only update dimensions?
Thanks!

[David Usherwood]

I tried this out connecting from TM1 to TM1 (a bugbear of mine since Black Belt). Same issue, no measures => no data. Shame.

[Matya]

Hi,

We use lot of custom query (Package Connector) as TI sources. It works properly. If you don't want to create csv, you could create a BI report too.

[whitej_d]

Someone will correct me if I am wrong, but I believe you can only really use Relational style packages, or the above mentioned SAP as data sources with the package connector.

[karkea]

We use also heavily Package Connector to extract data from relational DW via FM models. Especially the custom query option that came with 10.1 is very useful. To my understanding you can only use SAP as a source for the non "custom query" packages (i.e. standard packages in package connector).

[Michel Zijlema]

We use also heavily Package Connector to extract data from relational DW via FM models. Especially the custom query option that came with 10.1 is very useful. To my understanding you can only use SAP as a source for the non "custom query" packages (i.e. standard packages in package connector).

Good to hear the custom query is working for you. We're testing the PC custom query option currently in an AIX environment and from time to time the only thing the PC is updating is the TM1 process core dump file . We have a PRM open at IBM. I need to see whether this is an environment specific bug or a configuration issue (although this should never lead to server crashes...). At this point the instability makes the tool useless for us.

Michel

[theblackdawn]

Well.
I was trying to do something similar - Loading Data from a Cognos Package into a TM1 Cube.
But to my surprise, I was able to select the measures and everything was correctly placed.
But Again... I was NOT ABLE to select another dimension as a Measure Dimension to which the data should load into.

This screenshot shows that the measures can be selected.

BI_TM1_Screenshot.png (37.85 KiB) Viewed 7866 times

But we need to add another dimension as 'Measure' dimension to which the data should get loaded. Am I right here?
And the Package Connector does not allow to add a new dimension, like the way we add in the Variables tab (when loading from a csv or ODBC) when a dimension count is less.

BI_TM1_Screenshot2.png (25.05 KiB) Viewed 7866 times

Any suggestions or help appreciated here.
Kindly correct me if my approach itself is incorrect.