TM1 Forum

All,

Im just starting to work with Skipchecks and feeders. Nee your suggestion on below :

Calculation :
##QUARTERLY VALUES
JAN11_AVG_QTD = N: (DEC10_MTD+JAN11_MTD)/2
FEB11_AVG_QTD = N: (DEC10_MTD+JAN11_MTD+FEB11_MTD)/3
MAR11_AVG_QTD = N: (DEC10_MTD+JAN11_MTD+FEB11_MTD+MAR11_MTD)/4

APR11_AVG_QTD = N: (MAR11_MTD+APR11_MTD)/2... and so on for each quarter till DEC15_AVG_QTD

##YEARLY CALCULATIONS
JAN11_YTD= (DEC10_MTD+JAN11_MTD)/2
FEB11_AVG_QTD = N: (DEC10_MTD+JAN11_MTD+FEB11_MTD)/3
MAR11_AVG_QTD = N: (DEC10_MTD+JAN11_MTD+FEB11_MTD+MAR11_MTD)/4
APR11_AVG_QTD = N: (DEC10_MTD+JAN11_MTD+FEB11_MTD+MAR11_MTD+APR11_MTD)/5 ... so on till December of every year.

Any advise on what the feeders will look like. I understand that each calculation will need a feeder. Any headsup will be appreciated

Kind Regards
Gbehel

Try method 3 here: http://www.tm1forum.com/viewtopic.php?f=3&t=9931

Consolidations are faster than rules and also easier in a situation like this.

Thanks Martin...

Im unable to open the link viewtopic.php?f=3&t=9931

can you post it again

Regards
Gbehel

Hi

I couldn't open that link either, although a search may find it. However, I think what Martin was saying is that you would be better to include consolidations in your time dimension

Instead of

JAN11_AVG_QTD = N: (DEC10_MTD+JAN11_MTD)/2

Have a consolidation

JAN11_AVG_QTD
DEC10_MTD 0.5
JAN11_MTD 0.5

Where 0.5 is the element weight - multiplying by 0.5 is the same as dividing by 2

You can use formula in an Excel Dimension Worksheet to generate this or use a TI process.

I would also advise you to change the naming convention for your periods to eg

2011-01_AVG_QTD

If you do this then your elements will sort in the correct order.

Consolidations calculate 100 times faster than rules and don't need feeding, which means you don't have to know how to right the feeders, and you avoid the memory taken up by feeders and result cells.

Regards

Paul Simon

thanks Paulsimon,

this is a great idea to avoid rule based cube and avoid writing feeders..

I really appreciate your help on this

Regards
Gbehel

Warmware error, correct link is here: http://www.tm1forum.com/viewtopic.php?f=21&t=388

Thanks Martin,

Appreciate your help on this

Regards
Gbehel

Hello Martin and Paulsimon,

The approach suggested by you worked and data is looking fine. Thanks for your help

However, im still curious to know how will the feeder for below calculation look like ?


['JAN12_AVG_QTD' ] = N: (['DEC11_MTD']+['JAN12_MTD'])/2;
['FEB12_AVG_QTD' ] = N: (['DEC11_MTD']+['JAN12_MTD']+['FEB12_MTD'])/3;
['MAR12_AVG_QTD' ] = N: (['DEC11_MTD']+['JAN12_MTD']+['FEB12_MTD']+['MAR12_MTD'])/4;

Will it look something like this?
['DEC11_MTD']=> ['JAN12_AVG_QTD' ] ,['FEB12_AVG_QTD' ],['MAR12_AVG_QTD' ] ;
['JAN12_MTD']=> ['JAN12_AVG_QTD' ] ,['FEB12_AVG_QTD' ],['MAR12_AVG_QTD' ];
['FEB12_MTD']=>['FEB12_AVG_QTD' ],['MAR12_AVG_QTD' ];
['MAR12_MTD']=>['MAR12_AVG_QTD' ] ;

Im not sure if i did the right thing here. Suggestions/Corrections are most welcome

Regards
Gbehel

gbehel wrote:Hello Martin and Paulsimon,

The approach suggested by you worked and data is looking fine. Thanks for your help

However, im still curious to know how will the feeder for below calculation look like ?


['JAN12_AVG_QTD' ] = N: (['DEC11_MTD']+['JAN12_MTD'])/2;
['FEB12_AVG_QTD' ] = N: (['DEC11_MTD']+['JAN12_MTD']+['FEB12_MTD'])/3;
['MAR12_AVG_QTD' ] = N: (['DEC11_MTD']+['JAN12_MTD']+['FEB12_MTD']+['MAR12_MTD'])/4;

Will it look something like this?
['DEC11_MTD']=> ['JAN12_AVG_QTD' ] ,['FEB12_AVG_QTD' ],['MAR12_AVG_QTD' ] ;
['JAN12_MTD']=> ['JAN12_AVG_QTD' ] ,['FEB12_AVG_QTD' ],['MAR12_AVG_QTD' ];
['FEB12_MTD']=>['FEB12_AVG_QTD' ],['MAR12_AVG_QTD' ];
['MAR12_MTD']=>['MAR12_AVG_QTD' ] ;

Im not sure if i did the right thing here. Suggestions/Corrections are most welcome

Regards
Gbehel

Giresh,

If you set "JAN12_AVG_QTD" (and others) up as a consolidation, you do not need any rule OR feeder.

Thanks Rodger,

Based on suggestions from Martin and Paulsimon (and as you said), i have already set the *_AVG_QTD/*_AVG_YTD as consolidations and data is loaded and working fine. However, I was curious to know on how the feeders would turn out to be in case a rule is written instead of consolidation and needed advise on the one i wrote.

Appreciate your help

Regards
Gbehel

gbehel wrote:Thanks Rodger,

Based on suggestions from Martin and Paulsimon (and as you said), i have already set the *_AVG_QTD/*_AVG_YTD as consolidations and data is loaded and working fine. However, I was curious to know on how the feeders would turn out to be in case a rule is written instead of consolidation and needed advise on the one i wrote.

Appreciate your help

Regards
Gbehel

Ah, I see.
Well in that case, feeders as you have written would work but they would be very messy.
I would however be more inclined to set up a number of attributes for both the rule and the feeders so that you would be able to use just a few lines of rules with variable attributes and a few lines of rules for the feeders.

You are correct in noting that you would need to feed from each constituent part, since if any 1 of them contains a value then the rule will return a value.
Another option for the feeder would be to set up a 2-dim cube, with both dims being the "Period" dimension (1 a copy of it), put 1's in the cells where the row needs to feed the column etc and just have 1 feeder line to your other cube.

Thanks Roger,

These are excellent suggestions. Shall try these alternatives

Regards
Gbehel