Skipchecks and Feeders
-
- 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
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
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
- 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
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.
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
Jodi Ryan Family Lawyer
-
- 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
Thanks Martin...
Im unable to open the link viewtopic.php?f=3&t=9931
can you post it again
Regards
Gbehel
Im unable to open the link viewtopic.php?f=3&t=9931
can you post it again
Regards
Gbehel
- 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
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
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
-
- 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
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
this is a great idea to avoid rule based cube and avoid writing feeders..
I really appreciate your help on this
Regards
Gbehel
- 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
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
Jodi Ryan Family Lawyer
-
- 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
Thanks Martin,
Appreciate your help on this
Regards
Gbehel
Appreciate your help on this
Regards
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
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
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
-
- 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
Giresh,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
If you set "JAN12_AVG_QTD" (and others) up as a consolidation, you do not need any rule OR feeder.
Declan Rodger
-
- 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
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
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
-
- 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
Ah, I see.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
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
-
- 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
Thanks Roger,
These are excellent suggestions. Shall try these alternatives
Regards
Gbehel
These are excellent suggestions. Shall try these alternatives
Regards
Gbehel