Data Model Parameters

Summary

Data Model Parameters

Content

I am building a data model for an RTF letter using ‘Oracle BI EE’ as the Data Source. The data model requires
parameters but when I try to add the SQL code, I get no results. Are there any
examples of how to write the SQL for parameters when using Oracle BI EE as the data source?

I have attached a simplified version of the report with the SQL that I have tried for the parameters. I do not get any error messages but no data is returned.

 

Code Snippet

select	 "Worker"."Employee Name" as "Employee Name",
	 "Worker"."Employee Email Address" as "Employee Email Address",
	 "Worker"."Person Number" as "Person Number",
	 "Worker"."Assignment ID" as "Assignment ID",
	 "Worker"."Assignment Name" as "Assignment Name",
	 "Worker"."Assignment Number" as "Assignment Number",
	 "Worker"."Assignment End Date" as "Assignment End Date",
	 "Worker"."Assignment Start Date" as "Assignment Start Date",
	 "Worker"."Assignment Status" as "Assignment Status",
	 "Worker"."Bargaining Unit" as "Bargaining Unit" 
 from	"Workforce Management - Worker Assignment Real Time"."Worker" "Worker"
where "Worker"."Bargaining Unit" = :p_union