Skip to Content
avatar image
Former Member

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 03, 2015 at 11:55 AM

    Hello Tanush,

    yes, you can apply a filter on a calculated column using an input parameter.

    You just have to consider the possible performance issues, in case of a big amount of data records, because before the filter can be evaluated the calculation has to be done for each record.

    Best Regards,

    Florian

    Add comment
    10|10000 characters needed characters exceeded