cancel
Showing results for 
Search instead for 
Did you mean: 

CE FUNCTIONS

Former Member
0 Kudos

Validation failed, no measure defined in a reporting enabled analytic or calculation view

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

i want some examples in ce function can you plz send me using ce_join _view and ce_olap_view and ce_calc_view based on this give me some examples

lbreddemann
Active Contributor
0 Kudos

Please read the documentation first.

After that: stop using CE functions and use SQL instead.

- Lars

Former Member
0 Kudos

Hi Anjali

You can refer the below Guide ofr CE function syntax(page number 100)

http://help.sap.com/hana/sap_hana_sql_script_reference_en.pdf

Bus as Lars Righly mentioned, use SQL instead of CE function

http://scn.sap.com/community/hana-in-memory/blog/2014/12/11/calculation-engine-ce-functions--rest-in...

Regards,

Priyanka

Former Member
0 Kudos

Hi Anjali,

You need to have atleast one column defined as measure.

Go to semantic tab and make one column as measure and activate it again.

Regards,

Priyanka

patrickbachmann
Active Contributor
0 Kudos

Also just as an alternative to Priyanka's suggestion (it's requiring a measure because CUBE option is the default);  if you do not want to have a measure then, depending what version of HANA you have you can turn this off by going to Data Category in semantics and turning off the CUBE option.

-Patrick