Skipchecks and Feeders

Post Reply
gbehel
Posts: 49
Joined: Fri Dec 27, 2013 8:35 am
OLAP Product: TM1, Cognos EP, Contributor
Version: 10.2.2
Excel Version: 2013
Location: India

Skipchecks and Feeders

Post by gbehel »

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
User avatar
Martin Ryan
Site Admin
Posts: 1988
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Skipchecks and Feeders

Post by Martin Ryan »

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.
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
gbehel
Posts: 49
Joined: Fri Dec 27, 2013 8:35 am
OLAP Product: TM1, Cognos EP, Contributor
Version: 10.2.2
Excel Version: 2013
Location: India

Re: Skipchecks and Feeders

Post by gbehel »

Thanks Martin...

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

can you post it again

Regards
Gbehel
User avatar
paulsimon
MVP
Posts: 808
Joined: Sat Sep 03, 2011 11:10 pm
OLAP Product: TM1
Version: PA 2.0.5
Excel Version: 2016
Contact:

Re: Skipchecks and Feeders

Post by paulsimon »

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
gbehel
Posts: 49
Joined: Fri Dec 27, 2013 8:35 am
OLAP Product: TM1, Cognos EP, Contributor
Version: 10.2.2
Excel Version: 2013
Location: India

Re: Skipchecks and Feeders

Post by gbehel »

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
User avatar
Martin Ryan
Site Admin
Posts: 1988
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Skipchecks and Feeders

Post by Martin Ryan »

Warmware error, correct link is here: http://www.tm1forum.com/viewtopic.php?f=21&t=388
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
gbehel
Posts: 49
Joined: Fri Dec 27, 2013 8:35 am
OLAP Product: TM1, Cognos EP, Contributor
Version: 10.2.2
Excel Version: 2013
Location: India

Re: Skipchecks and Feeders

Post by gbehel »

Thanks Martin,

Appreciate your help on this

Regards
Gbehel
gbehel
Posts: 49
Joined: Fri Dec 27, 2013 8:35 am
OLAP Product: TM1, Cognos EP, Contributor
Version: 10.2.2
Excel Version: 2013
Location: India

Re: Skipchecks and Feeders

Post by 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
declanr
MVP
Posts: 1815
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Skipchecks and Feeders

Post by declanr »

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.
Declan Rodger
gbehel
Posts: 49
Joined: Fri Dec 27, 2013 8:35 am
OLAP Product: TM1, Cognos EP, Contributor
Version: 10.2.2
Excel Version: 2013
Location: India

Re: Skipchecks and Feeders

Post by gbehel »

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
declanr
MVP
Posts: 1815
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Skipchecks and Feeders

Post by declanr »

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.
Declan Rodger
gbehel
Posts: 49
Joined: Fri Dec 27, 2013 8:35 am
OLAP Product: TM1, Cognos EP, Contributor
Version: 10.2.2
Excel Version: 2013
Location: India

Re: Skipchecks and Feeders

Post by gbehel »

Thanks Roger,

These are excellent suggestions. Shall try these alternatives

Regards
Gbehel
Post Reply