TM1 Forum

I want to move value from one to another month in the same cube.
I have a Cube called HR Recruitment with dimensions;

Period
Version
Org_structure
Position_title
HR_Recruitment_Measures ( ‘Number of staff’, FTE at Recruitment, Recruitment Period Input as Numeric elements)

Say I will have financial controller position starting in Dec 2011 which is M+12 with an Index value of 36.
The value for Number of staff for the month of M+12 is 1 by upload.
I would like to show the same value to another month (FTE at Recruitment) say in M+7 which is M+12-5. The number 5 is to be an input value ‘Recruitment Period Input’.

So, the month for FTE at Recruitment is the month of Number of staff – Recruitment Period Input.
How can I write the rule?
I have tried to write the rule as follows

['FTE at Recruitment']=N:

IF(DIMNM('Period',DIMIX('Period','All Periods'))@=(DIMNM('Period',DIMIX('Period','All

Periods')-['Recruitment Period Input'])),DB('All Periods','Dec 2010 version','Number of staff'),0);


CUBE: HR_Staffing_Recruitment
Version Dec 2010 version
Org_Structure Finance


Number of staff Recruitment Period Input FTE at Recruitment
Financial Controller Jun-11 0 0 0
Financial Controller Jul-11 0 0 0 Need rule to populate base on Recruitment period input value say 5
Financial Controller Aug-11 0 0 0
Financial Controller Sep-11 0 0 0
Financial Controller Oct-11 0 0 0
Financial Controller Nov-11 0 0 0
Financial Controller Dec-11 1 5 0



It is not working.I want to move value from one to another month in the same cube.
I have a Cube called HR Recruitment with dimensions;

Period
Version
Org_structure
Position_title
HR_Recruitment_Measures ( ‘Number of staff’, FTE at Recruitment, Recruitment Period Input as Numeric elements)

Say I will have financial controller position starting in Dec 2011 which is M+12 with an Index value of 36.
The value for Number of staff for the month of M+12 is 1 by upload.
I would like to show the same value to another month (FTE at Recruitment) say in M+7 which is M+12-5. The number 5 is to be an input value ‘Recruitment Period Input’.

So, the month for FTE at Recruitment is the month of Number of staff – Recruitment Period Input.
How can I write the rule?
I have tried to write the rule as follows but not working. Any help would be appreciated.

['FTE at Recruitment']=N:

IF(DIMNM('Period',DIMIX('Period','All Periods'))@=(DIMNM('Period',DIMIX('Period','All

Periods')-['Recruitment Period Input'])),DB('All Periods','Dec 2010 version','Number of staff'),0);


CUBE: HR_Staffing_Recruitment
Version Dec 2010 version
Org_Structure Finance


Number of staff Recruitment Period Input FTE at Recruitment
Financial Controller Jun-11 0 0 0
Financial Controller Jul-11 0 0 0 Need rule to populate base on Recruitment period input value say 5
Financial Controller Aug-11 0 0 0
Financial Controller Sep-11 0 0 0
Financial Controller Oct-11 0 0 0
Financial Controller Nov-11 0 0 0
Financial Controller Dec-11 1 5 0



But it is not working. Any help would be appreciated.

Thanks
Regards,
MB

Thanks
Regards,
MB

Hi mbillah,

Bit confused by what you are trying to accomplish - but if you are inputting the data by upload why don't you have the TI process write the necessary data in, will save you having to write this Rule.

With respect to the Rule, can you explain a bit more what it is trying to do. As far as I read it, you say that if you recruit one person in M12, then the value of 'Number of Staff' is 1. But why is the value of Recruitment Period Input (in July?) then 5?

number of staff recruitment period input fte at recruitment
Dec 1 5 0

I am not sure what your "all periods" refer to. I would say without knowing the answer to this question that it is likely to cause you problems. You need to be careful with period dimensions as it is easy to create a circular reference (i.e. the element is equal to the sum).

What about?
['FTE at Recruitment']=N:
DB(DIMNM('Period',DIMIX('Period','All Periods')-['Recruitment Period Input']),'Dec 2010 version','Number of staff');

Also:
Try a worked example, as I am not sure that you will find a situation where the logic test is TRUE.

I normally use a 1 (TRUE) & 0 (FALSE) in my logic to ensure that it is working before completing the statements with actions to ensure the logic is working first.
i.e. in your example
['FTE at Recruitment']=N:
IF(DIMNM('Period',DIMIX('Period','All Periods'))@=(DIMNM('Period',DIMIX('Period','All Periods')-['Recruitment Period Input'])),
1,
0);

Then input test values where you are expecting it to work. You can always use trace calculation in perspectives explorer to see what Tm1 is doing with the logic and where it is failing.
Can you please provide a worked example for your logic as this may help in determing where this is failing.