syntax error in ce_projection

[#1]

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_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