syntax error in ce_projection

[former_member312625]

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.

[former_member226419 · Accepted solution]

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.

BR

Sumeet

[former_member312625 · Accepted solution]

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.

[Former Member · Accepted solution]

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

[former_member182302]

You need to add ''B1'''

Regards,

Krishna Tangudu

[former_member312625]

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.

[former_member182302]

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

[former_member312625]

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)

[former_member182302]

cool