How to pass the string values from the dashboard prompt to analysis

Summary

passing string values to the analysis which is created from direct database request from the dashboard prompt

Content

I am creating a analysis using direct database request.i need to gives filters in the query so i followed the syntax like 

  goal_name              IN (@{Goal_plan}{goal_name})
 AND Department_name     IN (@{Department}{Department_name})
 AND  location_name      IN (@{Location}{location_name})
  AND Business_Unit_name IN (@{Sub_business_unit}{Business_Unit_name})

 

But I am getting Errors like 

1)message: ORA-00904: "GAS": invalid identifier at OCI call OCIStmtExecute. (HY000)

2)ORA-00907: missing right parenthesis at OCI call OCIStmtExecute. (HY000)

Is there anything wrong in the syntax .please check once i am attaching query.