Page 1 of 1
TI Process with Cube and View Name as Parameter
Posted: Thu Apr 18, 2024 11:40 pm
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.
Re: TI Process with Cube and View Name as Parameter
Posted: Fri Apr 19, 2024 8:31 am
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
Re: TI Process with Cube and View Name as Parameter
Posted: Fri Apr 19, 2024 2:56 pm
by raeldor
This looks like just what I'm looking for. I'll give it a try... thank you!
Re: TI Process with Cube and View Name as Parameter
Posted: Mon Apr 22, 2024 7:56 am
by lotsaram
hmmm ... a generic process for exporting TM1 cube data you say ...
https://github.com/cubewise-code/bedroc ... export.pro
Re: TI Process with Cube and View Name as Parameter
Posted: Tue Apr 23, 2024 12:04 pm
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
Re: TI Process with Cube and View Name as Parameter
Posted: Fri Apr 26, 2024 9:41 pm
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/