Is there a way of creating a picklist for the parameter in TM1 TurboIntegrator Process directly on TM1 Architect (not via Excel Worksheet or Contributor ) ?
Thx
Picklist for TM1 Process
-
mukeshrajdass
- Posts: 36
- Joined: Tue Sep 07, 2010 11:34 am
- OLAP Product: Cognos TM1
- Version: 10-2-2
- Excel Version: 2014
-
lotsaram
- MVP
- Posts: 3706
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Picklist for TM1 Process
No.
(Good idea. Would be nice to have.)
(Good idea. Would be nice to have.)
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
dan.kelleher
- Community Contributor
- Posts: 128
- Joined: Wed Oct 14, 2009 7:46 am
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 11
- Location: London
Re: Picklist for TM1 Process
You can create a picklist in a cube and and select the approriate parameter, then reference this in your TI process via a CellGetN/S in the Prolog to obtain the parameter at run-time. To avoid a situation where the process is run without the parameter being selected first, clear it in the epilog of the process and jump out of the process if the parameter is blank. You can also use TM1User() and the }Clients dimension to allow for parameter sets per user.
-
mukeshrajdass
- Posts: 36
- Joined: Tue Sep 07, 2010 11:34 am
- OLAP Product: Cognos TM1
- Version: 10-2-2
- Excel Version: 2014
Re: Picklist for TM1 Process
Hi
Appreciate the idea...but would be 'clunky' in this situation...Thanks anyway.
Regards
Appreciate the idea...but would be 'clunky' in this situation...Thanks anyway.
Regards