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.
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
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
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
The module in which I apply the filter looks like this. Yes, essentially same way you've filtered.
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. 🤞
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!
🙂
See how each line item is at a different level in the L hierarchy