Dependent List(dimension) selection

Hi All,

I have two dimensions, Employee and Activity.

and this two are to be used a dimension in my Final module,

I want to include a condition when a particular employee is selected from dimension drop down then only the relevant activity(this mapping is available in Activity List) should be visible in the Activity drop down.

I know this is possible by dependent drop down for when my Employee and Activity both are line items in a module.

but in this case, I have both as dimension(list)and I want in my module the dimension lists to dynamically update when the Employee is selected.

Thanks

Madhu

Accepted answers

All comments

prabhu

Hi @MadhabikaM - You can achieve this by using FILTER.

Create a System Module with employee and Activity as Dimension and 1 Boolean formatted Line item.

Mark true for the employees who are active in certain activity.

can be done manually or formula depends on scenario.

Apply this filter in your current module.

Thanks,

Sorna Raja Prabhu.

MadhabikaM

Hi Sorna Raja Prabhu,

This would work but issue here us ,if I should have my Line(boolean) items in page while pivot to apply filter.

but I need my both dimension in page to change dynamically , when a employee is selected or a activity is selected.

Thanks
Madhu

Misbah

@MadhabikaM

Your only choice is dependent dropdown here. Page Selector can't be filtered based on the selection in another page selector.

If it is about the filtering the module then you can apply @prabhu solution

Hope that helps

Quick Links

Can you help?

Unanswered questions

Unable to use one page for multiple DEV models that are partially in sync
Hello, Our model builders are normally making changes to all structural changes in a DEV model. Because we are now in a Prod freeze and we don't want to move structural changes to PROD until end of year, we created a copy of the DEV model (standard mode) - 'DEV2' model, where we are only making changes to urgent issues…
Anaplan for Microsoft 365
Using the excel addin for Microsoft 365 when I try to add a card to import data I get the message 'Cannot insert data from a custom view'. I am not using a custom view. Any ideas what I am missing here?
Data Split between Many to Many Relationship Mappings
Hello Anaplan Community, I am encountering an issue with one of my development work and would be greatly appreciated your assistance. There are 2 different modules involved in my model: 1) INP01 Percentage Input by Product (Applies To: P3 List) 2) REP01 Percentage Split by Department (Applies To: Departments List) The…