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?