source and targert modules are dimensioned by two different dimensions

MaheshKosuri
Occasional Contributor

source and targert modules are dimensioned by two different dimensions

 

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

 

3 REPLIES 3
JaredDolich
Moderator

Re: source and targert modules are dimensioned by two different dimensions

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


Jared Dolich
MaheshKosuri
Occasional Contributor

Re: source and targert modules are dimensioned by two different dimensions

@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
Community Boss

Re: source and targert modules are dimensioned by two different dimensions

Hi , @MaheshKosuri 

 

use sum instead of lookup