Boolean: TRUE if any of the children is TRUE

Screenshot 2024-10-23 at 11.56.05 AM.png

Hello Guys, in this Module I am checking eventual input errors in the "Amount" line item. The 'Error?' line item works fine. This module uses 'Employees#' list, that is hierarchically under 'Business Unit' list.

In another module that uses 'Business Unit' list, I am trying to populate a Boolean to check if there is an error in a business unit. I tried with 'DAT04 Anual Employee Augmentation'.'Error?'[LOOKUP: 'Employees#'.Business Unit] and the same lookup with a module I have that correlates Employees with their respective business units, but in both cases I have an error that says the dimension of is source doesn't match.

Can anoyone help me with this please?

Accepted answers

AjayM

Then it must be the time dimension. If you don't have time dimension in the target module, use select upon time.all periods. Hope it's enabled in your model calendar settings?

All comments

iWonder

Did you try using ANY: instead of LOOKUP:? ANY is more useful for booleans.. maybe try it out?

https://help.anaplan.com/any-8ad06ef2-8b17-4f21-b2df-990eca953ac4

Ayoubette

I am using "Any" for it.

AjayM

If business unit and employee lists have parent and child relation, you don't need to use lookup. Just refer the error lineitem, since it has summary enabled anyways.

Cheers!

Ayoubette

@AjayM I tried this already but it doesn't work. The formula is valid but it doesn't work.

AjayM

Then it must be the time dimension. If you don't have time dimension in the target module, use select upon time.all periods. Hope it's enabled in your model calendar settings?

iWonder

'DAT04 Anual Employee Augmentation'.'Error?'[ANY: 'Employees#'.Business Unit]

Like this?

Ayoubette

@iWonder I tried this formula. It is valid but doesn't work. It is just always unchecked for all Business Units.

Ayoubette

@AjayM it works now ! It was indeed the time dimension. Thanks a lot !

AjayM

@Ayoubette , if you don't have time dimension in the target module, then it should be 'DAT04 Anual Employee Augmentation'.'Error?'[Select: time.all periods]
If time dimension is present at the target, then you wouldn't need this select function.

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385