ODBO and MSAS

[Herman Moller]

Hello,

Connect to ODBO to extract MSAS data to TM1

I found the following so far....

Problem 1) CAM Security and MSAS

- ODBO is a nightmare to connect with TM1. I am still working around getting MSAS and loading into TM1 cube with CAM Security. IBM have the following note:

"Connecting to an OLE DB for OLAP Datasource When Using CAM Authentication
If your TM1 server is configured to use Cognos Access Manager (CAM) authentication, you must specify the CAM namespace ID used by the TM1 server when establishing a connection to an ODBO datasource.

If you are running a 32-bit version of the TM1 server, you can specify the CAM namespace in the Additional Connection Parameters section of the Connection tab in TurboIntegrator. The CAM namespace ID must be specified using the following format:

Provider String="CAMNamespace=<CAM Namespace ID"
<CAM namespace ID> must be the internal CAM namespace ID, not the descriptive name of the namespace.

If you are running a 64-bit version of the TM1 server, you must specify the CAM namespace ID through a connection string, using the same format noted above. For example the following connection string specifies a CAM namespace ID named NTLM_NAMESPACE:

Provider=TM1OLAP.1;Location=localhost;Data Source=empty;UserID=tm1user;Password="abc123";
Provider String="CAMNamespace=NTLM_NAMESPACE";InitialCatalog=empty
You cannot use the TurboIntegrator user interface to specify the CAM namespace when running a 64-bit TM1 server; you must use a connection string. "

If you dont have the CAM security then you can pick up the Analysis Service Drivers else you need to add them in using the IBM method which still doesnt work for me.

2) Dataloading with MSAS

a) Physical Cube only loads structures and NOT data

- Why is this not working?

b) Virtual cube loads data from analysis but you can not do the following:

- Extract Data or Export data.

Any Experience and Thoughts would be most helpful.

Thanks in Advance

Herman

[luminita.ciuca]

Hello Herman!

Regarding the dataloading issue from MSAS into TM1, have you found anything new mean while?
I´m currently dealing with the same issue when trying to load data from MSAS 2008.

Is anyone else having a better approach when it comes to loading MSAS cube data into TM1 (better than/different from ODBO)?

Thank you!
Lumi

[tomok]

It appears your whole discussion surrounds using TM1 as a data source for another OLAP tool, not using another tool, in this case Microsoft, as a source for TM1. TM1 could care less about CAM authentication when connecting to some other OLAP, like Microsoft. What you should be concerned about is providing the right connection string to connect to the Analysis Services cube to use in your TI process.