DataSourceODBOCatalog

[bergstrand]

Hi,

I am creating a process for loading a TM1 cube and dimensions from MS Analysis Services. For this I am using TI with ODBO source and MDX query to extract the data and elements of the AS-cube and -dimensions. So far so good.

Now I am trying to figure out a way to have the AS-database as a parameter, to make possible a selection of which AS-cube to load from, without having to edit the process itself. I have tried changing the variable DataSourceODBOCatalog in the Prolog-tab but this does not work (I guess perhaps the connection to the AS-database is made before the Prolog-script is run). Do you have any ideas what might work here?

Cheers!

Martin Bergstrand

[bergstrand]

Ok, just solved this myself. It was a simple case of the TM1 servcie account not having access to the AS-cube I was trying to connect to.

Thus changing the variable DataSourceODBOCatalog in the Prolog-tab to switch between cubes work just fine!

Cheers!

Martin