How to Lookup in different dimensions

Highlighted
Contributor

How to Lookup in different dimensions

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.

 

image.jpg

 

I would appreciate your advice. 

 

Best regards.

6 REPLIES 6
Highlighted
Certified Master Anaplanner

Re: How to Lookup in different dimensions

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.

Highlighted
Contributor

Re: How to Lookup in different dimensions

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.

Highlighted
Certified Master Anaplanner

Re: How to Lookup in different dimensions

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

Could you please give screenshots of blueprints? 

Highlighted
Contributor

Re: How to Lookup in different dimensions

Thank you for your reply.

 

Please see it.

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

 

 

ModuleA.jpgModuleB.jpg

 

Best regards.

 

Taku.

Highlighted
Certified Master Anaplanner

Re: How to Lookup in different dimensions

Taku,

 

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

Module A.JPGModule B.JPG

 

 

 

 

 

 

 

 

 

 

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

 

Dmitrii.

Contributor

Re: How to Lookup in different dimensions

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.