Mapping modules dimensioned differently

I want to be able to pull over my Snapshots from SYS: Snapshot Lookup into my time module via lookup using my Week Number and the Code since they are both text. My lookup module isnt dimensioned by time but it shouldn't have to be, what am I missing?

Capture1.PNG

Capture2.PNG

Accepted answers

All comments

Dikshant

Create a mapping of Snapshot Weeks to Anaplan Week (time period: week format) and use the SUM function to get the code or week number. Here is how it can be done:

Just in case your code or week number is in text format, use VALUE function to convert it to number so that you can sum that up in other module.

sydneygouani

@Dikshant thank you for this suggestion! But I would still have to manually map the Map Week line item do you have a work around?

Dikshant

@empressjewel - Yes, I've got a workaround for this, and it can be formula-driven!

FINDITEM(Time, LEFT(NAME(ITEM(Snapshot List)), 6) & 'SYS: Lookup Module'.Current year)

" FY" & RIGHT(TEXT(YEAR(PERIOD(CURRENTPERIODSTART()))), 2)

Try it out!

sydneygouani

@Dikshant so I got the first part. I was able to convert the Current Year to Text. But everytime I try to pullover the Map Week I get this error. This is the formula I am using: FINDITEM(Time, LEFT(NAME(ITEM(Snapshot Scenarios)), 6)) & Time Settings.Current Year Text, using Text format

Capture3.PNG

Capture4.PNG

Dikshant

Replace "FY" with " FY"

Make sure the line item format where you're applying this FINDITEM formula is time period (weeks).

Please share the blueprint mode and paste the formula here.

Dikshant

I think i got the mistake here. you have put in an extra bracket

FINDITEM(Time, LEFT(NAME(ITEM(Snapshot Scenarios)), 6) & Time Settings.Current Year Text)

Replace your formula with this… It must work!

sydneygouani

I removed the extra bracket and added a space in " FY" and I still recieved the same error. I also tried to change the format for the Current Year from Text to Week and I recieved an error

Capture6.PNG

Capture5.PNG

Dikshant

Change the Snapshot week lookup line item to a time period (week).

Change current year text line item to Text

Remove the formula and then change the format and then paste it back.

Try it out and let me know.

sydneygouani

Its populating but not correctly. See attached @Dikshant

Dikshant

Try this

FINDITEM(Time, LEFT(NAME(ITEM(Snapshot Scenarios)), 7) & Time Settings.Current Year Text)

sydneygouani

This helped but weeks 1-9 are gone now. @Dikshant

Dikshant

Try this

FINDITEM(Time, TRIM(LEFT(NAME(ITEM(Snapshot Scenarios)), 7)) & Time Settings.Current Year Text)

ravi

Alternate Formula:
SUBSTITUTE(NAME(ITEM(Snapshot Scenarios)), "Snapshot", Time Settings.Current Year Text)

Dikshant

@ravi good alternative, and it is also good to add TRIM function to remove extra spaces

TRIM(SUBSTITUTE(NAME(ITEM(Snapshot Scenarios)), "Snapshot", Time Settings.Current Year Text))

unknown

This content has been removed.

Quick Links

Can you help?

Unanswered questions

Anaplan Report page issue in the UX
Hello community, I have an issue with anaplan report (functionality). The issue I have is within couple of slides. The data in that report is scrolling into a new page. There is a hierarchy in the rows and line items and time in the columns. My problem is, the hierarchy is getting broken in the second page. One of the node…
Solution for when 2 time dimensions needed
As shown in the screenshot, each monthly amount (Jan, Feb, Mar 2024) needs to be paid down in the future months (Jan–Aug 2025). The paydown must satisfy certain conditions specific to each month between Jan and Aug 2025. If the conditions are met, the paydown can occur. For example, if $20 is available to pay in Jan 2025…
How to get live small project for learning more.
I have completed level 2 certificate still I am not confident. I want practice more, where I get small project for practice.