I am trying to integrate the BI package into TM1 using a Package connector.
Both BI and TM1 are 10.2 versions. And I'm trying this on a Windows 2008 R2 Enterprise on a 64-bit OS.
Steps implemented: I have successfully logged into the TI with the 'Package Connector' option, selected the required package, mapped(or created) the respective dimensions and finally able to test the queries SUCCESSFULLY in the Dimension Tab under the Data Source Tab.
Once after save and running the TI process, my process gets aborted and the Error Message is as follows:
" ..... TM1.Cognos CCognosDimension::BuildDataSource Exception: (TR0168) Transformer could not open the data source .... "
I don't understand what data source it is unable to open. I made sure that all the credentials are correct and we are able to connect to the BI server with the same credentials.
P.S: I have done this in the past with 10.1 version (both BI and TM1) and was successful. This is the first time I'm trying with 10.2 version.
Has anybody tried this in 10.2 version? or Am I missing something here? I would definitely appreciate any suggestions.
Package connector is a 32-bit exe .. I believe there is NO 64-bit for Pkg Connector. Would that be causing a problem... since I'm doing this on a 64-bit OS? (But how did it work previously .. with 10.1 version?)