Skip to Content
0
Former Member
Apr 22, 2014 at 10:33 AM

No Measure defined in a reporting enabled analytic or calculation View

11909 Views

Hello,

I'm trying to activate a simple calculation view but getting this error: No Measure defined in a reporting enabled analytic or calculation View

The SQL is working on the SQL COnsole but not as View.

hier is the code. Hopefully, someone can help me.

BEGIN

var_out =

Select * from "SYSTEM"."BKPF"

select a."cnt", a.BELNR, a.BLDAT, a.budat

from (

select count(*) "cnt", BELNR, BLDAT, budat

from "SYSTEM"."BKPF"

group by BELNR, BLDAT, budat) a

where a."cnt" > 1;

END

Kind Regards