BI Publisher keep Running Totals where row details are hidden? — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BI Publisher keep Running Totals where row details are hidden?

Received Response
192
Views
10
Comments
John Bruso1
John Bruso1 Rank 6 - Analytics Lead
in Oracle Analytics Cloud and Server

Summary

BI Publisher keep Running Totals where row details are hidden?

Content

Hi All,

I need to use Running Totals to figure out my sub totals and totals. However, I do not want to show these detail rows on my final report, just the subtotals and totals. But, if I hide the detail rows, my running totals go to 0.

In Crystal Reports you can just hide rows and still get your running totals. How can I do this inside of BIP??


Instead of seeing Running Total Details:

Capture-Details.PNG

I just want to see the summary:

Capture-summary.PNG

Thank you,

John

Answers

  • Carlos Carvalho
    Carlos Carvalho Rank 6 - Analytics Lead

    Ok, understood.

    So solution is by editing source query as replied by ​

    Besides, why are you having to process the data in BIP when you can do it in the SQL wich will not impact (has much) in performance.

    BR

    Carlos

  • Carlos Carvalho
    Carlos Carvalho Rank 6 - Analytics Lead

    Hello,

    For what i see you just need to use the tag: <?xdoxslt:sum(//FIELD_NAME)?> in last row of the rtf template

    e.g.:  <?xdoxslt:sum(//Project_Miles)?>

    Regards,

    Carlos

    P.S.- Ah, after post i saw the other response and realize one thing i missed (the group), so include that suggestion also.

  • Carlos Carvalho
    Carlos Carvalho Rank 6 - Analytics Lead

    Hello,

    Can you pls provide a screen shot of what you intend as output layout result (i do not use crystal-therefore i do not know what you are referring to)?

    Thanks

    Carlos

  • Kavitha_CP-Oracle
    Kavitha_CP-Oracle Rank 3 - Community Apprentice

    Hi John,

    What is your BIP version?

  • John Bruso1
    John Bruso1 Rank 6 - Analytics Lead

    Bean,

    Ya, I was just trying to avoid having to rework the whole thing just because I can't hide some rows... I may just do that... go back and build in the logic into the SQL.

    Thanks!

    John

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics Coach

    Please upload RTF Layout and xml , will send you Updated Layout. Thanks

  • John Bruso1
    John Bruso1 Rank 6 - Analytics Lead

    Bean, I can get the totals.. that's not the problem... I want to hide the details... all of the rows... so I just see the subtotals...

    j

  • John Bruso1
    John Bruso1 Rank 6 - Analytics Lead

    Venkat, is there no solution inside of BIP besides editing the source query?

  • John Bruso1
    John Bruso1 Rank 6 - Analytics Lead

    Hi Kavitha and Bean,

    I've attached images to the top. I'm using Word BIP Plugin 11.119.

    john

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics Coach

    Please handle at source level by using group by clause or apply group by in template on functional classification column. Thanks