Question Re: syntax error in ce_projection in Technology Q&A

syntax error in ce_projection

former_member312625 — Mon, 27 Apr 2015 02:50:54 GMT

I am writing an sql script CV to join two fact tables and display the data based on row filter.Please see the script below.

When trying to validate the view,it triggers the below error. I couldn't figure out the sytax error in above script. can anyone help me.

Re: syntax error in ce_projection

former_member182302 — Mon, 27 Apr 2015 05:03:23 GMT

You need to add ''B1'''

Regards,

Krishna Tangudu

Re: syntax error in ce_projection

former_member226419 — Mon, 27 Apr 2015 05:03:30 GMT

Can you please message full error in black? I cant see properly.Just as a thought why are you writing in script view . You can directly create attribute view and put the filter in the same.

Sumeet

Re: syntax error in ce_projection

former_member312625 — Mon, 27 Apr 2015 13:47:31 GMT

I already added B1 as a row filter in the above function. Please click on the image to see the full image of the calculation view created. But still it is showing error.

Re: syntax error in ce_projection

former_member312625 — Mon, 27 Apr 2015 13:51:07 GMT

Below is the error message sumeet.

"Internal deployment of object failed;Repository: Encountered an error in repository runtime extension;Internal Error:Deploy Calculation View: SQL: sql syntax error: incorrect syntax near "B1": line 11 col 84 (at pos 557)nSet Schema DDL statement: set schema"

I was trying to understand CE_PROJECTION function by using it on the join result. But couldn't do it due to the error.

Re: syntax error in ce_projection

Former Member — Mon, 27 Apr 2015 14:22:08 GMT

Hi Venkat,

In your PROJECTION , please correct your filter statement by including double quote for EMPID.

var_out = CE_PROJECTION ( :FACT, ["EMPID","EMPDATE"],' "EMPID" = ' ' 31 ' ' ' )

Thanks

Siva

Re: syntax error in ce_projection

former_member182302 — Mon, 27 Apr 2015 14:47:06 GMT

No Venkat.. Am referring you to use the quotes properly replace the existing with ''B1'''

Re: syntax error in ce_projection

former_member312625 — Mon, 27 Apr 2015 15:43:14 GMT

Thanks Krishna. Sorry for wrong reply.

When provided the value for empid as ' "EMPID"="B1" ', the error triggered during validation.(double quotes for value B1)

When the value is provided in the format, ' "EMPID"=' 'B1' ' ', the validation passed.(single quote is provided twice)

Re: syntax error in ce_projection

former_member182302 — Tue, 28 Apr 2015 07:03:55 GMT

cool