on 06-24-2015 1:00 PM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Regards,
Priyanka
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.