Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Ability for getting the current process ID via a function
Description
I have a BIP report with the bustling feature, I built an ESS job and bind this BIP report.
When I run this ESS job in Scheduled Processes, the system will have a process ID, Please help provide the ability to get the process ID and apply it to the BIP data model.
Use Case and Business Need
Now I have a BIP report with the bustling feature, I built an ESS job and bind this BIP report.
When I run this ESS job in Scheduled Processes, the system will have a process ID and will send an output file to the client's FTP. If we have a function that can get the current process ID, then the output file can include the process ID in the output file name sent. so that users can find the corresponding output file from their SFTP folder.
Original Idea Number: 58c2187b8b
Comments
-
Moved from Financials Idea Lab.
0 -
Michelle,
You've mentioned ESS, is it really Enterprise (Workflow) Scheduler Service (that what ESS is) or you meant BI Publisher Scheduler (which is BIP Scheduler, not ESS)? Because bursting, actually, works in BIP Scheduler.
How would the customer know the "Process ID" to "find the corresponding output file from their SFTP folder" if the file name is including ID? You send them the ID separately (say by email) to identify the file needed? If yes, you can add any number generated (in Data Model SQL) to the bursting file name and provide it to the customer for identification. No Process ID is required, any unique string is good enough.
0 -
Got it, Thanks Valeriy.
0