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

Source Module

Target Module

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

thank you.

Accepted answers

anirudh

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

All comments

ArunManickam

You need to use Lookup. See if this helps.

PY Year = PREVIOUS(ITEM(Time))

Thanks

Arun

DMManalili

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

anirudh

Quick Links

Can you help?

Unanswered questions

Hide the cards under "Models" section once connected
Hi Is there a way to hide the cards under the "Models" section once connected, as I would like the users to see only the links to the apps? Thank you
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…