I'm building a forecasting application using Express Planner/TM1 Contributor as the front end. Potentially the users are going to want to update this on a monthly basis.
How do I reset the workflow every month? I've worked out you can hack it by editing the }tp_statevalidation control cube (or whichever name it is, I don't have it to hand) but I thought there must be a more robust way to do this? Or is the "correct" way rebuilding the application every month? This isn't possible with the amount of security we have to set up.
Martin
Rolling over in TM1 Contributor/Express Planner
- Martin Ryan
- Site Admin
- Posts: 2003
- Joined: Sat May 10, 2008 9:08 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
- Location: Wellington, New Zealand
- Contact:
Rolling over in TM1 Contributor/Express Planner
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Jodi Ryan Family Lawyer
-
- MVP
- Posts: 352
- Joined: Wed May 14, 2008 1:37 pm
- OLAP Product: TM1
- Version: 2.5 to PA
- Excel Version: Lots
- Location: Sydney
- Contact:
Re: Rolling over in TM1 Contributor/Express Planner
Martin,
From your /pmpsvc URL do you not get a Reset Applications button in the top right? You have to select the application with the tick box on the left before the button activates. This might have appeared in later versions than the one in CX9.5. If you haven't got it, then, as you say, clearing the }tp_application_state cube cube, but setting the State measure to 0 (it is a string measure) will do the trick.
From your /pmpsvc URL do you not get a Reset Applications button in the top right? You have to select the application with the tick box on the left before the button activates. This might have appeared in later versions than the one in CX9.5. If you haven't got it, then, as you say, clearing the }tp_application_state cube cube, but setting the State measure to 0 (it is a string measure) will do the trick.
Andy Key
- Martin Ryan
- Site Admin
- Posts: 2003
- Joined: Sat May 10, 2008 9:08 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
- Location: Wellington, New Zealand
- Contact:
Re: Rolling over in TM1 Contributor/Express Planner
Thanks Andy, it is there in CX9.5. And in fact easy to find in the documentation when you use the pdf instead of the web help...
Cheers,
Martin
Cheers,
Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Jodi Ryan Family Lawyer