TI Process with Cube and View Name as Parameter
-
- 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
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.
- 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
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
Specifically in this case DatasourceNameForServer and DatasourceCubeview
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- 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
This looks like just what I'm looking for. I'll give it a try... thank you!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
-
- MVP
- Posts: 3661
- 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
hmmm ... a generic process for exporting TM1 cube data you say ...
https://github.com/cubewise-code/bedroc ... export.pro
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.
-
- Community Contributor
- Posts: 154
- 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
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
-
- Posts: 16
- 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
Yes you can do it.
See bedrock for an example or use bedrock right away.
https://code.cubewise.com/open-source/bedrock/
See bedrock for an example or use bedrock right away.
https://code.cubewise.com/open-source/bedrock/