How to get data from source module using time range dimension

Highlighted
Contributor

How to get data from source module using time range dimension

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.

 

 

3 REPLIES 3
Highlighted
Community Boss

Re: How to get data from source module using time range dimension

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

 

Highlighted
Contributor

Re: How to get data from source module using time range dimension

hello, thank you for your responsed. I tried it but the values are not showing.
Highlighted
Master Anaplanner/Community Boss

Re: How to get data from source module using time range dimension

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