Dropdown Filter in New Views

Hi ​@bunyod.sap - If I understood your question correctly, you can utilize a CASE WHEN statement to add logic for the filter dropdown. Additionally, you can apply a component filter with the same logic to eliminate NULLs from the dropdown.

Hi ​@kailash.potha12 thanks for your reply. I really appreciate it.

I want to create in one View four different OLAP tables. The OLAP Tables are not just simple tables. They already contain formula within the KPIs. Just imagine, I have 2023 vs. 2024 comparison data in each of them. Now, I want to create dropdown filters with ROUND_MONTH. Since date logic, parameters and application purpose are different for each OLAP, I want to have different types of dropdown filters with ROUND_MONTH. Your proposal is the classical approach, and it will be applied for the whole view, meaning all four OLAPs. The output will be correct only for one and for the others applied dropdown filter will be incorrect. I need basically four different dropdown filters. In Analysis, it was possible by creating variables. Cheers, Bunyod

Hi ​@bunyod.sap - Interesting requirement, did you already tried Input Dropdown in new views which behaves almost similar to Button dropdown in analysis. Which will update a variable and we can use that variable in component filter.

Hi ​@kailash.potha12 Yes, in that OLAP I I have Input Dropdown with selection options for defining some categories as well, on top I need there Dropdown Filter for the month selection. Thanks. Bunyod