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