LOV based user parameter for AO based on ABAP CDS

Hi All,

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?

Regards,

Shyam