Lists as page selectors

Hi,

Is it possible to create dependent page selectors when more than one list is published as a page selector?

I have a module that forecasts demand for SKUS in different country.

Currently when the user selects the country the next selection is SKU but the SKU dropdown shows SKUs for all countries. I created a filer module for Country and SKU and I am using the filter to show SKUs by country.

This seems to work then my SKUs are in rows but not when I pivot the SKU dimension to page selectors.

Is it possible to have one page selector (list) filtered based on another page selector(list)?

Accepted answers

All comments

rob_marshall

@BahalR ,

If you create a list of your SKU's rolling up to your Countries, that would do the trick.

Rob

BahalR

Hi @rob_marshall

That would mean changing the dimensionality of the module to use the new hierarchy and it will have a trickle down effect on other modules correct?

It seems though that might be the only option.

rob_marshall

@BahalR ,

Yes and no....Yes it would be a new hierarchy, but if you do it correctly where the code is a concatenation of the Country code and SKU code (100_100987) then you can use this for reporting but still be able to get back to the SKU Flat list (because it is part of the code) as well as the Country. Plus, your module will be much smaller in size because not every SKU (I am assuming) will go to every Country. This way, it actually opens you up to more possibilities. If your SKU does span multiple Countries, then make that a numbered list and have the display name be list formatted back to the SKU Flat list. That way, if the SKU ever changes, it will automatically be updated in this list. Lastly, if you the requirement that only certain folks can see certain Countries as well as SKU's, then you can put selective access on this new list.

Hope this helps,

Rob

DavidSmith

@BahalR

One option you could try is to have a line item that is a a dependant drop down and a drive line item

You could publish these two line items instead of a page selector. You should then be able to set up a filter on the displayed grid

You would need to create a dummy list of SKU rolling up to Countries

more details can be found here on how to set this up

https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Dropdowns/One-to-many_Filtered_Picklists.htm

https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Dropdowns/Many-to-many_Filtered_Picklists.htm

Alternatively, you could create a "SKU selector" module, which is synchronised, or filtered based on the country. This could then by published to the side or top of the dashboard and then used to synchronise the bottom grid

I hope this helps

David

Quick Links

Can you help?

Unanswered questions

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
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