I need to provide a List of values type optional filter where a user should be able to select some or all of the company codes in Analysis for Office running off of an Cube type ABAP CDS. Now I realize:
1. Optional filters aren't a thing in ABAP CDS.
2. WHERE.. IN <parameter> doesn't work in ABAP CDS view .
I might be wrong about any or both of the statements above but that's what some digging around online tells me.
Point 1 apparently has no workaround but Point 2 can be done in a table function.
I am honestly thinking of building a BEx on top of it- Should solve problem 1 & 2.
What are your thoughts?