Dynamic page selector filters, depending on other selectors

[Hayk]

Description:As a page builder, I would like to filter page selectors with a line item, which has dimension of other page selectors. This filter should filter page selector based on what's chosen in another page selector.

Example:Forecast input dashboard,productsandcustomersare page selectors. Each customer has own set of valid products, which he wants to see in page selectors. Currently New UX prompts you to choose certain customer, where it'll lookup for filter values (see screenshot). It should be possible to choose "Current selection" to enable dynamic filtering of a selector.

Definition of done:Suppose we have a boolean filter, where productsAandBfiltered forCustomer 1and productsA,CandDfor客户2. If I select Customer 1 in a page selector, I should see only proudct A and product B in a product page selector. Similarly for Customer 2, it should be A, C and D. For total customers all 4 products should be in page selector.

[Akhilesh9025]

Currently, we don't have that type of filtering ability between 2 independent lists.

To achieve the dynamic page selector, we need to create a relationship between them.

If the relationship is 1 to 1, then adding a property in one of the list and using that to create a filter would work.

But if you have many to one relationship, then a hierarchy should be created to establish relationship between them

For example,

In many to one relationship, Create a Product Hierarchy list with Customer as parent.

Use a process with flush and import actions to update the hierarchy list frequently.

You can still have the flat products list to hold the data but a mapping could be used to setup relationship between Hierarchy and flat list to solve any further issues.

Unless any kind of relationship entity(property or hierarchy) is created in Anaplan, the dynamic filtering in pages with the pages cannot be established

[rodolfo_hr]

@Akhilesh9025this will not work if the item you want to filter is set up as a selector. One of the cool features of the NUX is that you can actually add a filter into a page selector, but this is not possible with these type of cases.

[DelahayeOlivier]

Would be an interesting feature to add to the UX!

+1

[darcydean]

This would be a huge add to the UX. Allowing context selectors to drive line items that are formatted with the same list as the context selector. Sometimes with space issues you don't want to add another dimension to a module and instead use line item to create that list relationship!

[CWPorter]

This is a very good proposal and would make for better/simplified page experience for end-users