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

elaine.novel

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

anirudh

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