Skip to Content
author's profile photo Former Member
Former Member

Error while executing the the SQL on top of Analytical view

Hi all,

below is the generic pattern of the query I am using on my Analytic view,

Select a. col1, a.col2, a. sum(col3)

from _SYS_BIC.SIMPLE_AN_VW a

where a. col3_date_field > a. col4_date_field and

a. col5<=15

group by a.col1,a.col2;

I am getting the following error

Could not execute '

Select a. col1, a.col2, a. sum(col3) from _SYS_BIC.SIMPLE_AN_VW a where ...' in 43 ms 446 µs .

SAP DBTech JDBC: [7]: feature not supported: not allowed over OLAP VIEW : search without aggregation or grouping by expression other than view column

when I removed the where clause 'a. col3_date_field > a. col4_date_field' it is working fine.

I know that this error occurs when there is no group by clause but I have the group by clause but I am still getting the error.

Does any one have any idea on why this is happening??

Please advice!! thank you!!

-Gayathri

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jun 05, 2014 at 05:33 AM

    Hi Gayathri,

    You may use HAVING clause instead of applying where clause on aggregated fields.

    SELECT column_name, aggregate_function(column_name)

    FROM table_name

    WHERE

    column_name operator value

    GROUP BY column_name

    HAVING

    aggregate_function(column_name) operator value;

    Sreehari

    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.