最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

sql - How do I generate a report using Bursting in BI publisher? - Stack Overflow

programmeradmin2浏览0评论

In BI Publisher, I have a data model called Products that contains 3 fields: RPT_ITEM_NUMBER, RPT_ITEM_NAME, 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 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 Folder/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". However, I can not find the report that I need to send anywhere. So 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?

发布评论

评论列表(0)

  1. 暂无评论