Oracle Analytics Publisher Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

ESS job fails if no data is returned by BI Publisher report's data model

28
Views
0
Comments
Rank 4 - Community Specialist

Description

Prevent ESS job from failing in case no data is returned by underlying BI Publisher report's Data Model

Use Case and Business Need

ESS job created for BI Publisher report fails in case no data is returned by report's Data Model.

Even creating a Scheduled Trigger to stop report from running in case no data is returned doesn't help. ESS job still runs, finds no data available, and fails.

The only possible solution is to use a workaround of appending a blank record to the report in case no data is returned. This solution though prevents ESS job from failing by creating a blank report, but is not elegant by nature.

Original Idea Number: 0c363694cf

1
1 votes

Submitted · Last Updated

Welcome!

It looks like you're new here. Sign in or register to get started.