Mapping Issue for CC mapping to Driver List

Monpero · 2024-04-24T12:21:04+00:00

There was an error rendering this rich post.

Monpero

Hi All,

I'm having issue mapping Cost centre and a Driver List.

Conditions on the Mapping are :-

Driver List items to be mapped to all the Cost Centre
Some Driver List item to be mapped to some of the Cost Centre

What would be the best practice to do the mapping? How can the mapping be done.

Below is the screenshot for mapping

Thanks a lot.

Accepted answers

rob_marshall

@Monpero

Yes, on the matrix concept. As for the list formatted line items, you can use those or not, I have seen it both ways and it just depends on how this will be used. As for the import, I would think it is setting it up one time and then as new cost centers are created, the "owner" of this matrix or the model admin (or process admin), checks the boolean for that cost center/driver combination.

All comments

Dikshant

Create a driver and cost center list and SYS: Driver details module and you can store the mapping as a line item in the Driver module. Line Item has to be list format (cost center). Map it manually or load it via CSV file. Let me know if there is any complexity or scenario we are missing here?

Monpero

@Dikshant thanks for the response I appreciate it, the complexity is that

All the Driver List items needs to be mapped to all the Cost Centre
Some Driver List items needs to be mapped to some of the Cost Centres excluding the other Cost Centres.

How can this be possible achieved?

rob_marshall

@Monpero

I agree with @Dikshant in you will need to create a Drivers list, but I would create a module that has the driver list by the cost centers as this will allow the Divers to "apply" to multiple cost centers, like Street Manager Noticing System and Management Training. Typically, I try to use a boolean, but you can also use a list formatted line item, either the driver or cost center.

Monpero

Thanks @rob_marshall for the input.

Monpero

From my understanding is to have a matrix of SYS: Module dimensioned by Cost Centre List and Driver List then a lineitem (Boolean Formated) to capture the valid combinations.

And another line item (List Formated: either Driver List of Cost centre List) use a formula like IF line item (Boolean Formated)= TRUE then ITEM(Driver List) on the line item (List Formated)

Do I import the list formated into a New Module dimensioned by CC or Driver on a line item (List Formated) base on the import list. To then be able to do [SUM:] using that list?.

Thanks

rob_marshall

@Monpero

Dikshant

I missed the many mapping part, so yes, as Rob mentioned, if you want to map one driver item to multiple cost centers, create a cross-section module and use a Boolean line item.

If you want to use it as a dependent dropdown in input module, create a combination list and add property of for driver and cost centers and create as many combination you want. This is when you have many to many mapping.

Monpero

Thanks @rob_marshall and @Dikshant this was really helpful.

If there can be any possible example mock up this will be really helpful.

If there could be an write up in future on the best practice to achieve boolean mapping with complexities such as this one that would help a lot of model builders. Mapping is one of the challenging bits in Anaplan.

Quick Links

Can you help?

Unanswered questions

Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…