Level 1 Model Builder-Create REV03 Margin Calculation Module

Hi-In L1MB Part 12 you need to prepare REV03 Module for Dashboard. I was able to hide Sales Price Growth % and Cost Price Growth% line items. I filtered to show only future periods, by creating a filter based on Time dimension for forecast period (see attached). Once i put the filter on there is no data ( see attached). Do i need add version to the pivot? 

Tagged:

Answers

  • Hi @Kevinc107 

     

    Why does Rev03 have subsidiary views?
    You don't need subsidiary views in this module. Please make sure that the line items have the same dimensions as the module. I believe Time is the dimension with disparity.

    You can do so from the blueprint of the module.