Number of cells count conclusion exam

AngeloB

Hello everyone.

I have successfully completed my module builder certification training. There was question during the exam that I was not able to resolve. This was related to the cell count for the export model to transfer the final demand from the supply chain model onto the FP&A model:

 

 

 

This is the formula I used to pull demand data:

'INV01 Inventory Ordering'.Final Shipment Amount[SUM: 'SYS08 SKU Details'.Distribution Center]

 

My formula drives a cell count of 746K for a total model size of 776K cells, when I know the model should be around half of that size (365K)

 

 

Any ideas in how to resolve this issue? 

Thanks in advance for any comments / help. 

Angelo

AngeloB

Thanks Bruno for the prompt reply, much appreciated. I have changed the summary method to 'none' and it has reduced it. I presume the learning here is that since an aggregated level is not needed for the aimed purpose of the module, then the summary methods can be set up as none. This will save space.

However, by applying the new summary method I am getting closer to the result but not to the exact number. Any ideas as to why? 

The correct cell count for the Dem04 module should be 365,476 cells

I am persisting on this as I dont want to miss an important concept / practice. 

Thanks again for the support

Angelo

 

 

 

 

AngeloB

Thanks, fully clear now. The learning is that is not enough to set up the subsidiary views as 'Non applicable' in their time scale but also to narrow them down to their specific dimension. 

 

Thanks again for the useful content, hoping that others can benefit from it. 

With regards

Angelo