TI Process with Cube and View Name as Parameter

Post Reply
raeldor
Posts: 32
Joined: Thu Jun 11, 2020 11:08 am
OLAP Product: IBM PAW
Version: Unknown
Excel Version: 365

TI Process with Cube and View Name as Parameter

Post by raeldor »

Is it possible to pass the view and cube name as a parameter of the TI Process for a more 'generic' export process? Can I pick the data source in the Prolog instead? Thanks.
User avatar
Steve Rowe
Site Admin
Posts: 2417
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: TI Process with Cube and View Name as Parameter

Post by Steve Rowe »

You need to read up on TI Local Variables https://www.ibm.com/docs/sl/planning-an ... -variables

Specifically in this case DatasourceNameForServer and DatasourceCubeview
Technical Director
www.infocat.co.uk
raeldor
Posts: 32
Joined: Thu Jun 11, 2020 11:08 am
OLAP Product: IBM PAW
Version: Unknown
Excel Version: 365

Re: TI Process with Cube and View Name as Parameter

Post by raeldor »

Steve Rowe wrote: Fri Apr 19, 2024 8:31 am You need to read up on TI Local Variables https://www.ibm.com/docs/sl/planning-an ... -variables

Specifically in this case DatasourceNameForServer and DatasourceCubeview
This looks like just what I'm looking for. I'll give it a try... thank you!
lotsaram
MVP
Posts: 3656
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: TI Process with Cube and View Name as Parameter

Post by lotsaram »

hmmm ... a generic process for exporting TM1 cube data you say ...
https://github.com/cubewise-code/bedroc ... export.pro
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
ardi
Community Contributor
Posts: 152
Joined: Tue Apr 02, 2013 1:41 pm
OLAP Product: tm1, cognos bi
Version: from TM1 9.4 to PA 2.0.9.6
Excel Version: 2010
Location: Toronto, ON

Re: TI Process with Cube and View Name as Parameter

Post by ardi »

raeldor wrote: Thu Apr 18, 2024 11:40 pm Is it possible to pass the view and cube name as a parameter of the TI Process for a more 'generic' export process? Can I pick the data source in the Prolog instead? Thanks.
Yes you can, you can create the View in a master process and pass the name of the view to the other export process along with name of View

But if you have TM1Py, MDXPy, they will generate the extract much faster than the AsciiOutput for each row in the Data tab
Ardian Alikaj
konstantin-spb
Posts: 12
Joined: Thu Feb 20, 2014 8:42 am
OLAP Product: TM1
Version: PA 2.0.9
Excel Version: 2016
Location: Russia, Saint-Petersburg

Re: TI Process with Cube and View Name as Parameter

Post by konstantin-spb »

Yes you can do it.
See bedrock for an example or use bedrock right away.

https://code.cubewise.com/open-source/bedrock/
Post Reply