Create a input parameter that equals to a measure
Hi i have 2 Dimension code, name and 3 Measures ..Sales ,gross margin, gross margin % where gross margin % is the CALCULATED COLUMN (GROSS MARGIN/SALES). The requirement is i have to create an input parameter on gross margin % so that i can retrieve values greater or equal to it.. Is this requirement feasable in HANA?
Florian Pfeffer replied
Why you create an additional calculated column instead of applying a filter expression on your existing calculated column (Filter Output of Aggregation or Projection View Nodes - SAP HANA Developer Guide for SAP HANA Studio - SAP Library)?