source and targert modules are dimensioned by two different dimensions

MaheshKosuri
MaheshKosuri
in Modeling

 

How can we link these EMP02 and REP04 modules to get total car costs by the region and role. When I am using formula i.e car costs = emp02 .carcosts[lookup: sys08.region, lookup.sys08.role] it is throwing folowing error. I under stand my REP04 is dimensioned by Region and Role where source module Emp drivers dimension by Department and Role

 

MaheshKosuri_2-1614966719131.png

 

Rep 04

MaheshKosuri_0-1614966467639.png

 

Emp 02

MaheshKosuri_1-1614966511804.png

 

thanks in advance

 

Tagged:

Answers

  • JaredDolich
    JaredDolich

    @MaheshKosuri 

    In your system module SYS08 make sure Role is formatted as a List:Role.

    You can only use LOOKUP and SUM on list formatted line items.

    See if that helps.

  • MaheshKosuri
    MaheshKosuri

    @JaredDolich 

     here my role is list format. In My REP04 report Salary and Bonus I am able to write formulae those are reading source dimensions without any mapping issue. But for next line items it is showing mapping  error when I use SUM and formatting error when I use Lookup.

    Help appreciate.

     

     

    MaheshKosuri_0-1614967739075.png

     

  • Kanishq17
    Kanishq17

    Hi , @MaheshKosuri 

     

    use sum instead of lookup

     

Categories