LOOKUP not working to change dimensionality of a line item

LucaRicci · 2024-06-07T08:19:31+00:00

There was an error rendering this rich post.

Hello,

I am trying to change the dimensionality of the line item "layer yearly pt1" from:

to:

in line item layer yearly pt.2

My attempt was to lookup "layer yearly pt1" using a year to scenario mapping as in "WKK17 year to scenario mapping":

However that does not seem to be working, in fact:

How can I fix this issue?

Accepted answers

do you want to lookup FY24 data in Layer Yearly pt2 line item? If yes, check this.

Since you have scenario dimension already in Layer Yearly pt2 line item you don't need a year to Scenario mapping.

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
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…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…