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 » Tue Jan 14, 2014 6:14 am

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: 1957
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 » Tue Jan 14, 2014 7:21 am

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 » Tue Jan 14, 2014 7:28 am

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: 749
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 » Tue Jan 14, 2014 1:59 pm

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 » Tue Jan 14, 2014 9:14 pm

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: 1957
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 » Wed Jan 15, 2014 2:38 am

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 » Wed Jan 15, 2014 10:50 am

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 » Wed Jan 15, 2014 12:42 pm

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: 1657
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 » Wed Jan 15, 2014 12:48 pm

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 » Wed Jan 15, 2014 2:37 pm

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: 1657
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 » Wed Jan 15, 2014 2:44 pm

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 » Wed Jan 15, 2014 6:40 pm

Thanks Roger,

These are excellent suggestions. Shall try these alternatives

Regards
Gbehel

Post Reply