Hi,
I have a small cube with cells which their value is populated by a few rules.
How to write feeder for these cells that is not based on another cell?
or is it better to omit skipcheck and feeder?
Thanks.
Kenneth
Feeder for cells with value based on rule
- gtonkin
- MVP
- Posts: 1192
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: Feeder for cells with value based on rule
This would be a very rare case as generally the values being used in the calculation should be coming from an assumptions or driver cube which could then be used to feed the result.
I worked on a cube recently which had values for a probability of default per client rating band-15 maturity buckets needed to be derived using a formula.
I chose to load to probabilities into the cube alongside the ratings and then feed to ALL buckets rather than hard-coding into rules.
Whenever a client tells me that the values will never change, I immediately build a model to handle changes!
In terms of feeders, I would try and feed from an assumptions cube unless you can populate the dependent values into the cube (or another cube) like I did above with my probabilities.
In terms of skipcheck vs no skipcheck/feeders - I would go with "it depends" - if you do feed and you get it wrong, performance can be worse than no skipcheck/feeders (depending on cube size). Going to suggest you try both options but don't forget that you may need to restart the model to compare results.
I worked on a cube recently which had values for a probability of default per client rating band-15 maturity buckets needed to be derived using a formula.
I chose to load to probabilities into the cube alongside the ratings and then feed to ALL buckets rather than hard-coding into rules.
Whenever a client tells me that the values will never change, I immediately build a model to handle changes!
In terms of feeders, I would try and feed from an assumptions cube unless you can populate the dependent values into the cube (or another cube) like I did above with my probabilities.
In terms of skipcheck vs no skipcheck/feeders - I would go with "it depends" - if you do feed and you get it wrong, performance can be worse than no skipcheck/feeders (depending on cube size). Going to suggest you try both options but don't forget that you may need to restart the model to compare results.
-
- Regular Participant
- Posts: 194
- Joined: Thu May 30, 2013 1:41 pm
- OLAP Product: Cognos
- Version: Planning Analytics 2.0.7
- Excel Version: 2010
Re: Feeder for cells with value based on rule
Thanks.
For now I'll probably skip the skipcheck. The size of the cube is so small that there's no noticeable performance issue.
For now I'll probably skip the skipcheck. The size of the cube is so small that there's no noticeable performance issue.
gtonkin wrote: ↑Thu Jan 18, 2018 5:36 am This would be a very rare case as generally the values being used in the calculation should be coming from an assumptions or driver cube which could then be used to feed the result.
I worked on a cube recently which had values for a probability of default per client rating band-15 maturity buckets needed to be derived using a formula.
I chose to load to probabilities into the cube alongside the ratings and then feed to ALL buckets rather than hard-coding into rules.
Whenever a client tells me that the values will never change, I immediately build a model to handle changes!
In terms of feeders, I would try and feed from an assumptions cube unless you can populate the dependent values into the cube (or another cube) like I did above with my probabilities.
In terms of skipcheck vs no skipcheck/feeders - I would go with "it depends" - if you do feed and you get it wrong, performance can be worse than no skipcheck/feeders (depending on cube size). Going to suggest you try both options but don't forget that you may need to restart the model to compare results.