Flagging different values at children for same parent

adpinto

I am looking for an efficient solution for the following:

I have a module that is multiple levels, compound list - think of it as L1 and L2
A line item within that list is an ID for each L2
I would like to flag all L1 members that have multiple IDs for their respective children (L2).
In the screenshot, there are two different LEAD_ID that exist within the hierarchy

Thank you!

Accepted answers

M.Kierepka

Hi,

Easiest solution I can think of (based on your screenshot, I assume your LEAD_ID line item has summary:Last Non-Blank enabled, if not, enabe it), I also assume that your L2 list has SYS module with line item "Parent", which for each L2 item gives their L1 parent (if not, make such):
Add new line item, format: Boolean, summary: Any, formula: ISNOTBLANK(LEAD_ID) AND LEAD_ID <> LEAD_ID[LOOKUP:SYS.Parent]

Because summary is Any, it will give you TRUE at L1 level if there are at least 2 different IDs.

All comments

M.Kierepka

Hi,

Because summary is Any, it will give you TRUE at L1 level if there are at least 2 different IDs.

adpinto

@M.Kierepka - Thank you for the reply. A couple of clarifying questions and we can use the real dimension names

Child = Unit
Parent = Building
Module 1. 'Applies to' is Unit
SYS Module is 'SYS Unit.' It does have a line item for Parent which yields the Building for each unit

In which module am I adding the new line item?

M.Kierepka

So in "SYS Unit" just add "Parent Building" line item, with format of Building and formula as "PARENT(ITEM(Unit))".
In Module 1 add new line item (let's call it "Multiple?"), format: Boolean, summary: Any, formula: ISNOTBLANK(LEAD_ID) AND LEAD_ID <> LEAD_ID[LOOKUP:'SYS Unit'.'Parent Building'].

Example (I placed Parent in the same module for simplicity and clarity):

Blueprint (notice that LEAD_ID is text, but can have format of any list and this should still work):

adpinto

Yeah, I got it. Thanks for the follow-up though! much appreciated!

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
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…