Cascading filter - allow *none*

#1

I am using a cascading filter for a 3 level hierarchy. The rationale for a cascading is that my hierarchy has a grand total of 5M row, with just a few hundred per level. My hope was that a search could run per level instead of across the 5M rows, thus speeding it up (well, it speeds up but it’s really not fast. At least now it completes).

My issue is that I have to fill up all 3 levels of hierarchy. I apparently cannot just select the top level.

I notice that because the query sent to my DB only uses the default data (defined in the data cube - the filter is bound to a bridge parameter) if I do not select something in all 3 levels.

I could not find a way to allow none for the second and third level. Is it at all possible? Or am I stuck with the non-cascading filter?

#2

On a side note, I know about the show tokens setting in the property of the filter, but I can only select all or data default as well as advanced, but nothing else.

#3

Hi Guillaume,

You can select a level by enabling the ‘Set Value On Any Filter Change’ from the properties panel of cascading Hierarchy.

setbyfilterchange
setbyfilterchange.png437×595 17.2 KB

Please, keep me updated and let me know if you have any other questions.

Regards,

#4

Hi Armin,

Thanks for your answer. I already found that out and wrote an answer, but actually forgot to post it.

I did try before it but as it duplicates the value of the last level selected into the lower level, it is not was I expected and thought it was wrong. Well it was not, and I’m glad it works,