How to get data from source module with time dimension to target module without time dimension

elaine.novel
elaine.novel
in Modeling

Dear Team, 

 

Hi again!

 

I would like to inquire on how to get data from source module with time dimension to target module without time dimension. For illustrate further:

Module 1 - Upload of Year to date balances - with time dimension (Month)

Module 2- Deduct the current period(month) from previous period(month) to arrive at my Month to date balances (following given rules that cannot be derived using Module 1). This is also with time dimension(Month)

Module 3. Set up time system module to manually check the current month at work
Module 4. Using the Module 2, but without time dimension, i need to be able to move the amounts using Module 3 as the new time system module instead.

 

Been trying to do workarounds on this but am having difficult t

Tagged:

Best Answer

  • anirudh
    anirudh
    Answer ✓

    Hi Elaine,

     

    Can you please elaborate more on what's happening in Module 3 and Module 4

    Do you want only the current period data in Module 4

    If yes, please set up the modules this way:

     

    Module 3; No dimension line item, format to month and use the formula: PERIOD(CURRENTPERIODSTART())

    If you don't want to use a formula, this line item can also be input

     

    Module 4; No time dimension, other dimensions same as Module 2

    Formula: Module 2.Data[LOOKUP: Module 3.Current Month]

     

    Please let me know if this works

Answers

Categories