Page 1 of 1
Picklist for TM1 Process
Posted: Thu Apr 03, 2014 12:34 am
by mukeshrajdass
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
Re: Picklist for TM1 Process
Posted: Thu Apr 03, 2014 6:16 am
by lotsaram
No.
(Good idea. Would be nice to have.)
Re: Picklist for TM1 Process
Posted: Thu Apr 03, 2014 9:33 am
by dan.kelleher
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.
Re: Picklist for TM1 Process
Posted: Tue Apr 08, 2014 5:44 am
by mukeshrajdass
Hi
Appreciate the idea...but would be 'clunky' in this situation...Thanks anyway.
Regards