How do i create a filter that used three dimenions ?

hinamahmood1994

I need to create a filter that pans across three dimensions.

I've tried using a boolean box, applying that to the lists I need to select. I think I'm going about it wrong.

Essentially what I need to be able to do is - if I select a product, I want only to be able to see the components that are within that product. I also have a factory as a dimension. In blueprint view - selected the relevant lists.

That's not working as I'd need to select certain products by component.

Accepted answers

All comments

nathan_rudman

Hello,

additional question: Is there no child/parent relationship within these lists ?

Usually, you would have a mapping module where you haver the relationship of Product / Component and another one with Product / Factory. No need to create a filter that combines the three (although it would work).

So you can apply a filter on the component dimension, using the Product/Component mapping and a filter on the factory dimension using the Product/Factory mapping (or the contrary, filter on product with the mapping if you want to start your selection by Factory).

When you select a product, filter will work, hiding non mapped components and non mapped factories.

Don't forget that a filter is not only the line item that you use, but you actually need to APPLY it in the module/view from Data > Filter

hinamahmood1994

Hi,

No, there isn't a parent/child relationship in either of the dimensions. They're all flat, with a top-level.

I've created a mapping of components and models. I have yet to do product/factory. I've tried applying the component/model filter. It doesn't seem to work. List stays the same.

Here is what've done for the mapping. My dimensions are p4 and c1.

Thanks,

Hina

mapping_c_to_p_53682.JPG

nathan_rudman

do you apply the filter like this ? my Q1 product would be your component and the line item I'm using is the same as the mapping you showed me

productcomponent filtering.png

hinamahmood1994

The module in which I apply the filter looks like this. Yes, essentially same way you've filtered.

filter_image_for_mapping_53696.JPG

MarkWarren

This should work but it looks like in your mapping module the data line item has a summary set to Any (in mapping c to p.JPG). So in the filtered module your Product dimension (current page) is at a summary level - so may be showing all the Components with Any summary. If you select a leaf level product the filter should be right. 🤞

hinamahmood1994

The filters work! I didn't realise the rows/columns could have an effect on filter working/not working.

Thank you both for your help!

🙂

ChrisAHeathcote

The trick here is that you need to establish a relationship between lists via a composite hierarchy and then build a series of line items dimensioned at different levels which feed into the summary of the next level in the hierarchy
Build a filter system module dimensioned at the lowest level of the hierarchy.
Add line items representing each level of the hierarchy to be present in the filter. Format as number.
Create a filter selection module with line items for each level of the hierarchy. Format as boolean.
Back to the filter module for each of these line items create subsidiary views for each corresponding level in the hierarchy other than that at the lowest level.
For each line item create a formula which queries the selection and returns 1 when true and 0 when false.
Create two additional line items in the filter module called technical and final filter ( this last one will feed the filter on the dashboard ).
Technical type =1 in the formula bar and select formula as the summary method.
Final filter = the line item corresponding to the lowest level.
For each line item summary method use ratio. Set each summary to query the line item at the next level up in the hierarchy as the numerator and the technical line item as the denominator.

See how each line item is at a different level in the L hierarchy filter 2.JPG filter 3.JPG filter 4.JPG

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…