Skip to Content
avatar image
Former Member

triggering a BO report based on a database table update

Hi,

I have a table having columns like Country, Start Date, End Date etc. And I have a webi report having same fields set as prompts. The table has one more column called "Status".

So the requirement is whenever the table has a new row inserted, it takes the values of prompts from the table and triggers the webi report.

Once the report is generated, the status column of the table is updated with "generated" for that record.

Is it possible and how?

Thanks in advance,

Richa

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 10, 2014 at 12:47 PM

    Hi Richa,

    You can schedule the report based on file Event. For this you need to drop a file on one location whenever a new row is inserted in table.

    If the stored procedure has been used to insert the table row, then you can write the script to drop the file in SP.

    Now create a file event in CMC. Schedule the report and choose event name in scheduling option.Schdule it after the file event occurs e.g. if you;re dropping the file at 2:00 PM then schedule the report post this time only. This is event to wait for operation.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Yes you can also do that!

      Create  a new dataprovider and take all the obejcts that you require from table. And in second data provider you can use subquery which will take all the values from first dataprovider. Use inList operator to have all the values.