Hi
I need to make a CDS view for consumption via Analysis for Office
However there are certain parameters which user will enter as mandatory(easily solved by parameters) but certain are optional (parameters )
How to solve this optional parameters in CDS, because while comparing in where condition it can be that for some parameters users might not enter anything and we have to get all the data corresponding to that value.
HOW TO USE OPTIONAL PARAMETERS IN CDS, OR A WORKAROUND if optional parameters aren't possible
Please suggest