Skip to main content

Dear all, I have in one view two OLAP tables(with complex calculations and predefined conditions) for which I want to create independent dropdown filters. The reason for that is that one should be filtered based on date type “received entries” and the other one based on date type “processed entries”. I was wondering if you maybe came across such an issue or if you have maybe some tips & tricks or solution for me? In advance thanks for your help. Best, Bunyod

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


Reply