I am using BO XI R2 on Teradata for reporting purposes.
I need to automatically trigger the report as an email only if the report is breaching some preset conditions as thresholds. The thresholds are being calculated on the report using some formulae and simple case statements and these reports are required to be scheduled in the Prod environment. Without manual checking or human intervention, can the result of the report be checked and depending on if the result has breached the threshold or not, can the email be triggered?
Email needs to be triggered only if the threshold is breached.
Please help me as this is very critical and the project requires this functionality. Let me know the if any specific software is required?
If you are on R3 then take a look at Publications. If you are on R2 I do not know how this can be done as Publications do not support Webi documents in R2.
Hi Dwayne,
Is it people are confused where to continue the discussion or they are not having any solutions for my issue? Do you have any? It would be really great if you can provide some help.
Given the constraints of using WebI and XIR2, and the assumption that you can create the required data needed for the trigger in the query, then the method I would use is to create a trigger report.
The trigger report query would be coded so that if the data doesn’t match that required then the report fails (e.g. creates a cartensian). If the trigger report succeeds then a BOXI event is trigger. The main report is then set to run, and email out, if the trigger is fired.
If you solved this another way I’d be interested to see what you did.
(BOB member since 2009-01-15)
(BOB member since 2006-07-28)
(BOB member since 2002-09-19)
(BOB member since 2005-11-28)