Bring in Data formatted data from one module to another where Target does not have Time dimension

CommunityMember125342

Hello Gurus,

I have this scenario.

Module 1 has the following:

Time dimension (Month)

List A

Line Items including a line item called ExpiryDate that is date formatted.

Module 2 has the following dimension (does not have time dimension).

List B

Line items (some line items plus one called Date where i need to bring in ExpirtyDate from Module 1

One of the line items that I have in module 2 is the List A members as well.

How can i pull the date to module 2 which does not have time dimension?

Thanks

Accepted answers

rob_marshall

@CommunityMember125342

Create a module, I called my SYS Global, that doesn't have any list in the Applies To. Create a line item called Current Period.

Now, you don't have to use a Lookup to get that period.

Rob

All comments

M.Kierepka

Hi,
You can, but you need to ask yourself what you want to achieve - from which time period you want to pull this date. From last, first, or maybe there is only one expirydate for list a member filled in the whole timeline (then lastnonblank/firstnonblank)? Or maybe from some specific month, like current, previous or next.
Then, you probably need to use the right combination of LOOKUPs (for list A and some specific month), or LOOKUP for List A and right Time summary in the source/TIMESUM (with proper argument).

CommunityMember125342

Hi,

I wanted to pull data from the Current Period (Say April 21 is set as current period).

'TargetModule'.EXPDATE[LOOKUP: 'SYS00 Time Settings1'.Current Period?, LOOKUP: LIST]

However, I do not get any values.

Since the line itme i am trying to pull is Time, can i use timesum for this instance?

Do I need to add add a different syntax?

Thanks

rob_marshall

@CommunityMember125342

Create a module, I called my SYS Global, that doesn't have any list in the Applies To. Create a line item called Current Period.

Now, you don't have to use a Lookup to get that period.

Rob

CommunityMember125342

@rob_marshall - You are great.

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…