bi-publisher

How do I check my bursting report output in BI Publisher?

In BI Publisher, I have a data model called Products that contains 3 fields:

  1. RPT_ITEM_NUMBER,
  2. RPT_ITEM_NAME,
  3. SHIP_DATE.

The data model is in the directory /My Folders/Drafts/. I also created a template to practice using bursting.

Then I wrote a bursting query to split the data by RPT_ITEM_NUMBER and I tried to send the report into another folder in BI Publisher.

Here was the SQL query I used:

SELECT 
       DISTINCT RPT_ITEM_NUMBER            AS    "KEY",
       'Products'                          AS    TEMPLATE,
       'en-US'                             AS    LOCALE,
       'PDF'                               AS    OUTPUT_FORMAT,
       'true'                              AS    SAVE_OUTPUT,
       'FILE'                              AS    DEL_CHANNEL,
       'Products_report'                   AS    OUTPUT_NAME,
       '/My Folders/Drafts/'                AS    PARAMETER1,
       'Products_report'                   AS    PARAMETER2
FROM Products

I made sure that bursting on the report properties is enabled. Then I scheduled the bursting and the job was marked as "success".

Issue

However, I can not find the report that I need to send anywhere.

Question

Why was the job a "success" when no report was send? And how do I send a report to a folder in BI Publisher or a folder on my laptop?

Solution

  • After playing around with bursting for a while, I realize that I can download the bursting report by clicking on Report Job History --> click on the bursting job name that ran successfully --> click on the output name under the tag Output & Delivery.

    Then the output will be downloaded and I can check it out. And the path needs to start with C:/ for it to actually run and send the report.