NO Time dimesin module to Time dimension module

143kishornaidu
143kishornaidu
in Modeling
Capture.PNG

HI

I want bring the data from non time to time module. as mentioned screen shot

Answers

  • HimanshuRaj
    HimanshuRaj

    Hi @143kishornaidu

    You can follow below steps:

    1. Source module can look like this as per your example
      Capture 1.png
    2. In target module, create 2 line items - UOM & Final UOM
      Capture 2.png
    3. See the formula for UOM, Use system module in place of ITEM(Time). This formula is identifying the period for which values should be populated
    4. In Final UOM, use Cumulate function to sum Product list item values
      Capture 3.png

    Cheers!!

Categories