Cannot Create Boolean based on LOOKUP for Write Access Driver

johan.marketoft
johan.marketoft
in Modeling

Hi,

 

I'm trying to build a module with a line item boolean looking if a Manager is in a specific Cost Center to later work as a Write Access Driver if a Manager can do certain actions in relation to that Cost Center:

Target Module:

Module dimensions: Manager, Cost Center.

Line Item: Is Manager in Cost Center? (Format: Boolean)

 

I have a SYSTEM module for the Manager based on the People # List. I do have both Manager and Cost Center as formatted line items in this module:

SYSTEM Module for People:

Dimensions: People

Line items: Is a Manager? (Boolean), Manager (Format: Manager), Cost Center (Format: Cost Center).

 

Manager is a subset of the People list. 

 

I am trying to pull in TRUE in the target module by the following formula:

SYSTEM MODULE.Is a Manager?[LOOKUP: SYSTEM MODULE.Manager, LOOKUP: SYSTEM MODULE.Cost Center] 

 

I get an error saying "Format of mapping used for lookup doesn#t match any dimension of the source."

I only get the error based on the "Cost Center"-lookup, as when I only do a LOOKUP for the Manager I don't get an error but then I get everything Boolean in the target module which is also not the result I want. I only want booleans to be TRUE for the cells where dimensions match according to the System Module.

 

Best regards,

Johan

Tagged:

Best Answer

  • jasonblinn
    jasonblinn
    Answer ✓

    You don't have these as dimensions in the source module, so lookup will not work. Try changing from LOOKUP, to ANY.

     

    Is a Manager?[ANY: SYSTEM MODULE.Manager, ANY: SYSTEM MODULE.Cost Center] 

     

    This is essentially a way to sum over Booleans to get it into your target module correctly.

     

    Jason

Categories