Level mismatch on common dimension

i would like to get inventory DOI calculation from module-KPI DOI to module-Inventory ending report. Therefore, i inserted 1 line item call DOI into module-Inventory ending report then put formula as below.

Then i get below error message.

You can refer to attached document for 2 modules blueprint.

Module inventory ending report - Dimension Division L3, Scenario

Module KPI DOI - Dimension division HFM, FX,Report version.

How to match the dimension then retrieve data DOI from module KPI DOI to Inventory ending report?

thanks

Alice

Level_Mismatch_common_dimension_74473.xlsx

Accepted answers

All comments

Panji

Hi,

in module inventory ending report(3 dimension) and KPI DOI(2 dimension) you have different dimension, if you want get data form different dimension you need to mapping, example (division HFM to division L3).

Thanks,

Panji

tz9lawa

hi,

Not too sure you are refer to general list mapping? If you refer to screenshot below, the mapping Division L3 and Division HFM already done.

So, what is next for the formula?

thank you

Alice

Panji

Hi,

you need add lookup funtion in your formula and refer to division L3.division HFM

regard,

panji

einas.ibrahim

Hi @tz9lawa

first of all, are you sure you need FX as a dimension and not an attribute?

Does one division have multiple currencies?

Now to your main issue .... when you have a Source and a Target module where you want to reference or retrieve a value, you can only use target module line item = Source mosule.Line Item - like the formula you provided - only if all the dimensions of both modules match.

When you have a difference in dimensions -like the current case- you have to use the LOOKUP function.

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/LOOKUP.html

A basic concept of using the Lookup function is to match the dimension of the source and target modules through mapping.

To help you determine this, could you please tell me what are the relationships between you source and Target modules?

tz9lawa

For source module - KPI-DOI, we do need FX in the dimension to support multiple Fx per country.

Source module is supporting module to calculate inventory DOI which using Profit & Loss Cogs information for calculation.

So, source module with dimension division HFM (mainly for financial reporting use), FX, Report version (each backup version)

Target module is inventory ending balance report to gather all inventory balances from each type of inventory.

Dimension at Division L3 (mostly use in working module), Scenerio (RF, Budget, Business Plan)

In order to have complete inventory report, we also need DOI appear in the report.

Hope above explains.

Alice

einas.ibrahim

What’s the relationship between Division HFM and any of the dimensions in the Target module! Is there any Parent child hierarchy ?

Same question for other dimensions. I see about 6 dimensions im both modules and can’t see the relationships

could you please illustrate the desired outcome using Excel?

tz9lawa

Division HFM and DIvision L3 have same parent.

Kindly refer attached document for relationshipt division HFM and Division L3, desired outcome tab.

Level_Mismatch_common_dimension_Doc2_74758.xlsx

CommunityMember111647

Hi Alice, As you mentioned that there exists the mapping, but the hierarchical relationship isn't there, please try making use of the [SUM: Division L3.Division HFM] in the formula.

Quick Links

Can you help?

Unanswered questions

How to create identical child items for multiple parents
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
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.…