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

UX Filter
Hi ALL, I have a module where a line item (Assignments column) is formatted by a large ‘Projects’ list. Each record is assigned to a Project and this module is published to a UX page. When users apply a filter on the Assignments column, the filter dropdown displays the entire Projects list (since the column is…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?