admin管理员组

文章数量:1345284

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?

本文标签： sqlHow do I generate a report using Bursting in BI publisherStack Overflow

版权声明：本文标题：sql - How do I generate a report using Bursting in BI publisher? - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1743810064a2542901.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。