How to Lookup in different dimensions

[takushimozuru]

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.

[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.

[dmitrii.mamaev]

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.

[takushimozuru]

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? 

[takushimozuru]

Thank you for your reply.

Please see it.

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

Best regards.

Taku.

[dmitrii.mamaev · Accepted solution]

Taku,

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

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

Dmitrii.

[takushimozuru]

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.