How to create ess job that will directly use the parameter of the data model?

Kristelle

Hello,

We have an analysis that we wanted to be available in the Scheduled Process. Since we cannot link the Analysis itself to the ESS job report job ID, we tried to recreate the analysis on a data model by taking the SQL from the Advanced tab. In the data model, we made the Data Source as Oracle BI EE.

The problem is, we cannot create the parameter LOV using the query that is dependent on Oracle BI EE data source.

Sample parameter query:

SELECT "Receivables - Transactions Real Time"."Time"."Calendar Year"

FROM "Receivables - Transactions Real Time"

WHERE 

"Receivables - Transactions Real Time"."Time"."Calendar Year" > 1999

So instead, we are thinking if it's possible to create ESS job that can take the parameter of the Data model as is? Or, is there a way to create the LOV wih a query for Oracle BI EE data source?

Dimple-Nagesh-Support-Oracle

Hi Kristelle,

Can you review this Sample : Creating an Oracle Enterprise Scheduler (ESS) Job

https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/diepm/integrations_erp_async_ess.html#GUID-8B5EA4C7-3E5B-4A03-BB25-56ECC6D7D792

Kristelle

Hello @Dimple-Nagesh-Support-Oracle ,

Thank you for your response. I checked the link you have shared. However, we are already aware of the standard step by step of creating the ess job.

What we wanted to create if possible is something like the InvoiceAgingAsOfDate report. For that report there are no parameters defined on the ESS job itself. But when we run it with the proper access, we see the parameters.

Regards,

Kristelle