Skip to Content

Filters on aggregated measured column in xsodata exposed a calculation view

Hi Experts,

I have a calculation view which is exposed in XSODATA.
I need to filter the Aggregated column in xsodata filters.
when I try to filter Its showing error : " Feature not supported".

In SQl Console we use to filter the aggregated column in having clause like wise how can we filter the aggregated column in xsodata filters.

Thanks in Advance

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Nov 08, 2019 at 09:24 AM

    Please check the SAP HANA Developer Guide

    - OData Service-Definition Features

    ? Aggregation The results of aggregations on columns change dynamically, depending on the grouping conditions. As a result, aggregation cannot be done in SQL views; it needs to be specified in the OData service definition itself. Depending on the type of object you want to expose with OData, the columns to aggregate and the function used must be specified explicitly (explicit aggregation) or derived from metadata in the database (derived aggregation). Note that aggregated columns cannot be used in combination with the $filter query parameter, and aggregation is only possible with generated keys

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.