Found 617 results.
Run every mile at Kovai MarathON to support the cause of promising young students’ education through our Kovaion Kalvi!
By using the event triggers, we can schedule the reports only when required, in other words only when the report has some data. Explore the steps below
By using the event triggers, we can schedule the reports only when required, in other words only when the report has some data.
Detail steps on how to enable it for any BI report is explained below.
Step1: Go to Navigator->Tools->Reports and Analytics
Step2: Then will be land upon Reports and Analytics page, Click on Browse Catalog as shown below
Step3: Next go to New->Data Model as shown below.
Step4: Then will be land upon Data Model task pane, next click on + icon and choose the source to create a new data model as shown below.
Step5: write SQL query as per requirement.
For example:
To fetch the list of employees whose ‘Last Working Day’ is current day in an organization.
1.For achieving above case, we need to fill the following details as shown below.
2. Next click on ok, go to data and view the result as shown below
3. Then Save the Data Model as shown below
Step6: Next in the Data Model task pane, we need to click on Event Triggers under Properties as shown below.
Step7: Next, we need to click on the (+) icon and fill in the following details as shown below.
| Attribute Name | Attribute Value |
| *Name | Schedule Trigger (Could be any name) |
| Type | Schedule |
| Language | SQL Query (Gets Auto-Populated when Type is Schedule) |
Step8: Also, for each trigger we do have other fields too which are on the lower UI Pane as shown below.
| Attribute Name | Attribute Value |
| Options | Checked (caches the result of Trigger Query) |
| Data Source | ApplicationDB_HCM |
| SQL Query | Could be based on requirement
E.g.: Select Sysdata as Date from dual |
Here we are using SQL query (written below) to fetch the list of employees who’s Last working day is Current day in an organization.
Select distinct ppnf. display_name, ppos.ACTUAL_TERMINATION_DATE
from
per_person_names_f ppnf,
per_periods_of_service ppos,
where
ppnf. person_id = ppos. person_id /* Using key field to be mapping both tables */
and trunc (ppos. ACTUAL_TERMINATION_DATE) = trunc(sysdate) /* Condition to check last working
day of employee is current day or not if yes then data returns else returns no data */
Step9: Now we already have a Schedule Trigger Defined and we will proceed to the next step where we will try to use this schedule. For this we will take an already existing BIP Report as shown below.
Step10: Try to schedule the same, for that We need to fill the populate details on the Schedule Tab and click on submit as shown below.
Step11: Next will see the status of the report which earlier scheduled as shown below
Note: If data is returned from the trigger SQL query, then the report job status is ‘Success’. If data is not returned from the trigger SQL query, the report job is ‘Skipped’.
Author
Kishore Kolluru
We're here to offer business solutions! Explore our services & solutions now.
Read MoreThis website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.
