Skip to Content

SAP Hana Web IDE Calculation View filter expressions: SELECT MAX("COLUMN") FROM

Hi,

need some help with the syntax by using the filter expressions within calc views.

I try to use aggregate expressions, but I don't get any data. (But I know this Select statement works by SQL Console)

match("FALNR", 'SELECT MAX("FALNR") FROM "synNFAL" WHERE "PATNR" = 41715436')

And the target is to use the Import Parameter '$$IP_PATID$$'. Something like that:

match("FALNR", 'SELECT MAX("FALNR") FROM "synNFAL" WHERE "PATNR" = '$$IP_PATID$$'')

Any ideas?

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 26, 2017 at 10:10 AM

    This does not work in the way you wanna do this, cause the query you passed to the match function cannot be interpreted and evaluated by the match function.

    What is the issue, why that does not work with "standard" modeling mechanisms (first filter the data and then do an aggregation with the max aggregation function on the required column; of course FALNR has to be a numeric type to be able to apply the max aggregation function)?

    Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded

    • May be one more confussion came up while I was switching the CV from dimension to aggregation and there is no aggregation column as I would expect (If I create a aggregation view than its there)