Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Data Model Parameters — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Data Model Parameters

edited Nov 1, 2019 4:30PM in General Transactional Reporting (OTBI) 4 comments


Data Model Parameters


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

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!