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