Error: key figure cannot be defined without aggregation In Calculation View

[former_member221711]

Hi Experts,

I am getting an error "key figure cannot be defined without aggregation" in calculation view during activation.

DETAILS:

var_out =  SELECT

                                VEHICLE_REG   AS REG_NUMB,

                                AF_TIMESTAMP   AS TOE1,

                                (6.286*AF_ENGINE_SPEED*AF_WHEEL_BVSPD)   AS GEAR_RATIO

                FROM "_SYS_BIC"."Analytic_View_DEMO1"

                GROUP BY VEHICLE_REG, AF_TIMESTAMP, AF_ENGINE_SPEED, AF_WHEEL_BVSPD;

Data Type:

               VEHICLE_REG             VARCHAR(30)

               AF_TIMESTAMP           TIMESTAMP

               GEAR_RATIO               DECIMAL 25, 20

               AF_ENGINE_SPEED    DECIMAL 25, 20    (Declared as Measure in Analytic View)

               AF_WHEEL_BVSPD     DECIMAL 25, 20    (Declared as Measure in Analytic View)

Thanks..

Regards

Madhusudan Pareek

[sergey_sheremet]

Hi,

you should use a sum function in expression. For examle: SUM(6.286*AF_ENGINE_SPEED*AF_WHEEL_BVSPD)

Good luck!

--

WBR, Sergey