DataSourceODBOCatalog
Posted: Fri Oct 23, 2009 1:13 pm
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
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