How to Lookup in different dimensions

taku.s

Hi everyone,

I have two module.

I want to post values from a module that does not have a date dimension to a module that has a date dimension.

Also, there are two target Line Items.

The mounting image is as follows.

I would appreciate your advice.

Best regards.

Accepted answers

dmitrii.mamaev

Taku,

Look at attached screenshots. It's clumsy but it works.

Module A.JPG Module B.JPG

Maybe you should change it a bit for your Calendar list. I see that we use different Date formats

Dmitrii.

Module_A_59313.JPG

Module_B_59313.JPG

All comments

dmitrii.mamaev

Hello,

Unfortunately I have some misunderstanding about 2 target line items, so I'll give formula as I understand:

Module A is flat, 'Item' column is List 'ITEM' formated?

Are you really need to enter List member? Not a value?

What about module B dimensions are: time(date) and ITEM, Line item with number format that show count of ITEM in Module A

If it's OK, so you can add system line item in module A with value '1'

Item1='Module A'.'system line item'[sum:'Module A'.'date']

The same formula is for Place

Hope that I understood the problem correct, and my post is useful.

Dmitrii.

taku.s

Hello

Thank you for your reply.

I tried and got an error.
I get the error message "Dimension of mapping used for aggregation doesn't match any dimension of the source".
Module B uses a list of dates as a calendar, not a Time, for the dimension.

Is there any other solution? I am very troubled...

Best regards.

Taku.

dmitrii.mamaev

What is the format of 'Module A'.'Date'?

Could you please give screenshots of blueprints?

taku.s

Thank you for your reply.

Please see it.

There are ModuleA's blueprint and ModuleB's blueprint.

Best regards.

Taku.

dmitrii.mamaev

Taku,

Look at attached screenshots. It's clumsy but it works.

Module A.JPG Module B.JPG

Maybe you should change it a bit for your Calendar list. I see that we use different Date formats

Dmitrii.

Module_A_59313.JPG

Module_B_59313.JPG

taku.s

Dmitrii.

Thank you for your support.

It is very easy to understand.I'll try and get back to you.

I have a question.

How do I display the corresponding values for Item1 and Place1, and Item2 and Place2?

Best regards,

Taku.

Quick Links

Can you help?

Unanswered questions

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
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.…