First of all create new Data
Model and report , I am considering that you are well aware about the Data
model and Report creation in BIP
Create an trigger into it , named as event trigger , same
name you have to select at the time of scheduling the report
Create report
After creating report we can go to schedule the report
Click on use trigger
We can see event trigger name is present in trigger
Use of schedule trigger :
A schedule trigger allows you to conditionally execute an
occurrence of a job. When the schedule time occurs, the schedule trigger is
checked. If the schedule trigger returns data, the job will proceed. If no data
is returned the occurrence of that job is skipped.
You will get a mail if successfully data returned
Change the trigger
name which you have defined in Data model , let say ORA_TRIGGER and also in
data model change the query also (which will return no data so we can apply
simply 1=2 in where clause )
Here it is ORA_TRIGGER
Now go to schedule the report again
This is the output of report
When there is no output then SKIPPED and if output is there
then SUCCESS
If we are removing query from trigger and putting the query
only in data model then scheduling will fail
Error : failed to execute event trigger
In this way we can use schedule trigger in oracle BI report fusion
cheers
No comments:
Post a Comment