Varying Key Figure Combinations

[ebrahim_bhika]

Hi Experts

We have picked up a varying in key figure Planning Object Combinations within a master data workbook based on the Time period filter selected. For certain period filters the combinations are approx. 6000 and adding in 4 to 5 more weeks into the filter increases the number of combinations to +-8500. at first we thought it was due to these additional combination having data defined within the new a periods but these periods are completely blanks. Why would combinations with blank periods pull through for certain periods but not others?

Regards

[riyazahmed_ca2 · Accepted solution]

Hello Ebrahim,

There is a concept called Planning Level Initialization which explains this case. The simplified definition is extending the combination to period or Time Period Creation for a combination. We know SKU at a Location being sold for a customer is the process. To set it up technically, we need to make the combinations of them by extending them to the relevant periods. Lets say after 2 months, we dont want to continue with a particular SKU or customer, then we dont need to initialize the planning combinations from the 3rd month onwards.

Currently we dont focus much on saving the space in cloud or performance. Otherwise it would be an earlier advice not to initialize the combinations unwantedly.

Also note that - Not all blank cells refers to the un-initialized cells. They might be already initialized, but there are no values in it.

Refer the below example to know your case.

There are 6 combinations extended to 10 periods which makes it 60 planning objects in first look. but the first combination is not extended to P7 and hence SKU1-LOC1-CUST1 at P7 would be left out in the total combination count that makes it 9.

If we see second combination, the actual combination created in only 7. So total planning objects in this case is not 1 * 10 = 10, but 1 * 7 = 7..

Third combination is extended in all the periods and hence total combinations is 10.

and so on..

Hence there are cases with in your planning objects that are not initialized and that plays a major role in the combination counts that you see..

Best Regards,

Riyaz