Cannot Create Boolean based on LOOKUP for Write Access Driver
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:
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:
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.