How to get data from source module using time range dimension

DMManalili
DMManalili
in Modeling

Hi,

Question please. How can I get data from source module using time range dimension to target module with model calendar time dimension?

Scenario:  I need to get the beginning balance of FY18 from the module to be able to transfer it to the target module which calendar year starts with FY19. Please ss.

SYS Time

DMManalili_0-1597633192241.png

Source Module 

DMManalili_1-1597633252398.png

 

Target Module

I tried this formula but I did not get the values.

DMManalili_2-1597633374214.png

 

thank you.

 

 

Tagged:

Best Answer

  • anirudh
    anirudh
    Answer ✓

    Hi,

    Try using this formula on the line item "Beg Balance"
    IF ITEM(Time) = Time.'Jan 19' THEN 'ATR - Actual - PY-Beg Balance'[SELECT: Time.'FY18'] ELSE 0

    We should avoid hardcoding like I've done above, but let me know if this works and I will then explain how to remove the hardcoding

    Regards,
    Anirudh

Answers

  • ArunManickam
    ArunManickam

    You need to use Lookup. See if this helps.

     

    ArunManickam_0-1597634581741.pngArunManickam_1-1597634623971.png

    PY Year = PREVIOUS(ITEM(Time))

     

    ArunManickam_2-1597634666641.png

     

    Thanks

    Arun

     

  • DMManalili
    DMManalili
    hello, thank you for your responsed. I tried it but the values are not showing.

Categories