Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
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

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

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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