Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Sachin Mistry
    Fill group by data in Group by columns and sub totals in a...
    Topic posted April 7, 2017 by Sachin MistryGold Medal: 3,500+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Reports, Sample Reports 
    336 Views, 2 Comments
    Title:
    Fill group by data in Group by columns and sub totals in a BI Publisher report
    Summary:
    Fill group by data in Group by columns and sub totals in a BI Publisher report
    Content:

    Current Output

    1. Group by column data is merged

    2. Group by column data is not carried over to subtotal column

    Desired output

    1. Unmerge data in Group by columns such as PO Number, Buyer, Supplier Name and repeat cell values

    2. Carry data group by columns data to sub total lines

    See the attached pdf

    How can I go about achieving the desired output?

    Comment

     

    • Arun Raj

      Have you resolved this? This looks like "Group Left" report.

      If you want to repeat the column values then you cannot use "Group Left" / "Group Above" options.

      Depending on the data model, you may be able to use RTF Template / Excel template to create the report. You can use Repeating Groups to accomplish this in RTF Template / Excel Template.

      Here is a link to how to create BI Publisher reports using Excel Templates

      Thanks,

      Arun

      • Sachin Mistry

        It has not been resolved yet. I will try creating a repeating group using excel rtf template. Really appreciate your suggestion.