![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2021\/09\/String1-min.jpg\")
<\/p>\nWhile developing an IBM Planning Analytics (PA) model, you may have come across a situation similar to the following:\u00a0 A rule and feeder are seemingly working correctly, but upon a data change the expected cells are not returning values, implying they are no longer being fed.\u00a0 Consider the example below showing a simple rule from a typical two-cube Workforce Planning (WFP) model, consisting of an input cube (\u201cWFP Input\u201d) where employee information is captured and a summary cube (\u201cWFP Summary\u201d) from which the calculated results of the model (e.g., Employee expense by Department) can be reported.<\/p>\n
<\/p>\n
![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2021\/09\/String2-min.jpg\")
<\/p>\n
But what if the user decides to change the employee\u2019s department from IT to Finance?\u00a0 As you can see, the desired cells are no longer fed as evidenced by the mismatch between the value at the leaf and consolidated levels. Totals not rolling up correctly are a classic symptom of missing feeders.<\/p>\n
![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2021\/09\/String3-min.jpg\")
<\/p>\n
So how can we ensure that the proper cells are always fed? One way would be to constantly process feeders via the CUBEPROCESSFEEDERS(); Turbo Integrator (TI) function.\u00a0 However, this approach can bring about undesired consequences such as locking of the cube for the length of the processing and underfeeding in the event that a user forgets to execute the TI process.<\/p>\n
To understand how we can make the feeder react to any change in input, we must consider when and how feeders are created in PA.\u00a0 When feeding from a numeric cell, a feeder is evaluated only when the cell goes from zero to a non-zero value, hence why changing the department does not update the cell fed. This is observed in the example when feeding from numeric cells for Salary and Headcount.\u00a0 Feeders originating from a string cell are reevaluated any time there is a change in the value of the cell, whether it is from blank to non-blank or between non-blank values.\u00a0 In our example, a feeder from the department measure(string) solves our underfeeding issue.<\/p>\n
![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2021\/09\/String4-min.jpg\")
<\/p>\n
![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2021\/09\/String5-min.jpg\")
<\/p>\n
The above methodology can be expanded to apply to multiple measures and dimensions.<\/p>\n
In closing, there is one consideration to take into account when feeding from a string cell.\u00a0 Unlike numeric cells which only store data at the leaf level, string data can reside at any level of a dimension.\u00a0 In a case where a user mistakenly enters a string value at a consolidated level a feeder will be created for every intersection underneath that cell.\u00a0 This has the potential to create a massive number of unwanted feeders which would lead to a spike in memory consumed as well as degraded performance.\u00a0 This can be guarded against by writing a rule as shown below:<\/p>\n
![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2021\/09\/String6-min.jpg\")
<\/p>\n","protected":false},"excerpt":{"rendered":"
While developing an IBM Planning Analytics (PA) model, you may have come across a situation similar to the following:\u00a0 A rule and feeder are seemingly working correctly, but upon a data change the expected cells are not returning values, implying they are no longer being fed.\u00a0 Consider the example below showing a simple rule from…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[24],"tags":[38,36,51],"class_list":["post-3452","post","type-post","status-publish","format-standard","hentry","category-ibm","tag-how-tos","tag-planning-analytics","tag-planning-analytics-how-tos"],"acf":[],"yoast_head":"\n