Oracle Transactional Business Intelligence Idea Lab

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

Allow Multiple Values for Event Trigger Parameter

11
Views
2
Comments

As of Oracle Analytics Publisher 12.2.6.1.12, event triggers accept only one value in a parameter. If you pass multiple values to a schedule event trigger parameter, the status of the scheduled job is set to Skipped. We would like to request that trigger parameters accept multiple values to fulfill a requirement we have to pass multiple parameters for a trigger parameter for a scheduled job.

1
1 votes

Submitted · Last Updated

Comments

  • Rank 8 - Analytics Strategist

    Hi @C. Joseph ,

    Thanks for the idea. Can you please provide an example or a use case?

    Thanks.

  • Rank 3 - Community Apprentice

    Allowing selection of multiple buyers would allow managers to schedule daily metrics related reports to run for the buyers in their organization. Hardcoding of buyers is not feasible. Similarly, allowing selection of multiple PO document styles (e.g., Subcontract, PO, etc.) specific to a buyer would be another use case. We have other columns that have been requested for multiple selection. In these cases, a false fail condition is generated if the scheduled report returns no data if a trigger is not used, so a schedule event trigger was considered. However, the report is skipped if a parameter is configured as multi-parameter even if data is returned by the trigger. Per Oracle documentation, this appears to be a limitation of event triggers.

Welcome!

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