Cascading filter is not working on 0CALDAY dimension filter in lumira designer 2.0

[former_member602155]

Hello Experts,

I have three dimension filters in my dashboard in lumira designer 2.0.

1. First dimension filter is on 0calmonth

2. Second dimensio filter is on 0calweek

3. Third dimension filter is on 0calday

When I select first dimension filter on 0calmonth then automatically values in second dimension filter (i.e. 0calweek values) get filtered out, but values in third dimensio filter (i.e. 0calday values did not get filtered out).

Please let me know is it possibe to filter out 0calday values based on selected values in (0calmonth dimension filter through css script ?

Regards

Rajiv Garg

[nikhil_joy2]

Hi Rajiv,

If you are open to use FILTER components other then Dimensional filter, you can achieve it by probably 3 dropdowns and SetFilter() code.

Regards,

Nikhil Joy

[former_member602155]

Hello Nikhil,

In my case only dimension filters will fulfill the requirement.

Thanks for yours reply.

[reiner_hille-doering]

Cascading filters require for all dimensions to set the "Read Mode" to "Posted Values".

You can do this e.g. in Initial View Editor - putting all three dimensions into "Background Filter".

[former_member602155]

Hello Reiner,

I tried what you have mentioned (kept all dimensions in backgroundd filter and read mode to "only posted values")

but still its not working.

anyother workaround.

Regards

Rajiv Garg

[former_member602155]

Hello Tammy,

No, it is not a issue of limit outlined.As I mentioned earlier there is issue of cascading filter (i.e. when we filter the first dimension filter values - 0calmonth then based on that filtered 0calmonth values, values of 0calday (second dimension filter) are not getting filtered out.May be there is some techinical bug or limitation of cascading filteration in case of 0calday in a dimension filter.

Is there any way to achieve solution through CSS script? that is my question mainly.

Regards

Rajiv Garg

[TammyPowlas]

Hi Rajiv - I don't think CSS will do it.

I am guessing without seeing your code; could you share more details, and I wonder if you are facing the limit outlined here: https://launchpad.support.sap.com/#/notes/2674032