I am having Employee Status as an element in a measure dimension whose Values Are 'Existing','Retiered' and 'As Is' (made a picklist of it) Another element is ExistingEmpCount And Next is Leftout EMp Count.
if the Status of the employee is 'Existing' or As Is then value in ExistingEmpCount is 1 and
if the Status of the employee is 'Retired' then value in LeftOutEmpCount is 1.
And there also time scale As Full Year-Q1-Jan,Feb,Mar Q2-Apr,May,Jun........
i Want if the employee is retired in suppose march month then the Status should be turned as 'retired' from april month to dec (Rest of the year) it should contain Retired in Status.
plz help.
Need Hepl when Employee Status changes in between a year
-
- Posts: 2
- Joined: Wed Aug 10, 2016 11:59 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
- Steve Rowe
- Site Admin
- Posts: 2464
- 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: Need Hepl when Employee Status changes in between a year
It sounds to me like rules would be able to deliver the behaviour you want.
Your logical requirements are fairly clearly stated in your post and it should be straightforward to translate them into Rules.
Can I ask what the issue is?
Your logical requirements are fairly clearly stated in your post and it should be straightforward to translate them into Rules.
Can I ask what the issue is?
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Need Hepl when Employee Status changes in between a year
He wants you to write the rules for him.Steve Rowe wrote:Can I ask what the issue is?

- Steve Rowe
- Site Admin
- Posts: 2464
- 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: Need Hepl when Employee Status changes in between a year
Hmmm, I'm shocked...Seems like the OP did not read the guidelines (http://www.tm1forum.com/viewtopic.php?f=3&t=1037).
Technical Director
www.infocat.co.uk
www.infocat.co.uk