Error executing view: Function count is not executable in denodo

Question

I have a table with few columns as shown below. I would like to get a count of all the records per week level but I am unable to count it. I could also use group by but I do not want to do that because it gives me too many records. I use denodo and oracle 18g.

s_id          sub_id    week    year    st_id
24hifew       njfhwf    50     2020    ew1eer
939hjefbw   newfkhwfe   34     2019    e3eef3
hewfhwe23   67832ghef   44     2018    ewfwf1

Code:

select
xx.s_id,
xx.sub_id,
xx.st_id,
yy.week,
yy.year,
count(*) OVER ( PARTITION BY yy.year, yy.week,xx.s_id,xx.sub_id xx.st_id) as week_l

from xx as xx left join yy as yy

Basically, I am looking for an equivalent query to partition by which will run fine.

Error:

finished with error: Error executing view: Function count is not executable