Dynamic Filter Dimension

Hello,

I would like to build a filter where the user can select the dimension (list) by which they want to filter and then have another grid next to it where the selected dimension's members appear. Is this possible to have this flexibility ?

Example: I have a module with the dimension "Orders" containing the sales of my organization. In the module I have the line items "Country", "Client", "Region" all of which are fomatted in the eponym list.

I display the sales in a page for the users and on top of the page I would like a first card showing a selection menu between "Country", "Client" and "Region" then a second card with the members of the list selected on the first card.

On the second card, I would select the members I want to filter by, using a boolean, and the sales data would adjust accordingly.

I have no issue filtering the sales data by a specific dimension in a regular scenario, but I do not know how to have a dynamic dimension there.

Can anyone let me know if this is possible and if so how to get the desired result ?

Thank you for the help !

Accepted answers

All comments

Ashutosh

Hi,

Please see this article. It will solves your problem.

https://community.anaplan.com/discussion/158405/how-i-built-it-limitless-interdependent-multi-select-filters

Regards

Ashutosh

PulkitChawla

@QZ - You can go with the video link shared above. It will also tell you about the actions for clearing your filters as well.

Hello,

Thank you for the suggestion. While the video was informative, it does not provide the solution I am looking for.

In the video, there are four dimensions in card, each being available even if the user does not need to filter the data using one of these dimensions.

My goal was to have only one dimension on the top part of the page instead of four, and have it dynamically update based on an earlier selection.

Using the video as an example, my ideal case is:

One grid asks me to select between Segment, Product Manager, Lifecycle, Vegan.
One grid displays the members of the eponym list based on what was selected just before.

Is this possible ?

Thanks !

PulkitChawla

@QZ - You can make 4 selection dependent on users and then make a User filter based on that.

Here is the logic you can follow.

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…