BI Publisher Pivot table grouping issue to resolve column supress — 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 Pivot table grouping issue to resolve column supress

Received Response
92
Views
1
Comments
Chandra O
Chandra O Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

Summary

BI Publisher Pivot table grouping issue to resolve column supress

Content

Hi Team,

I am trying to built a pivot table in RTF template, Unfortunately columns are merging. I tried to group them in the column but still it's merging.

I have attached XML, RTF and sample output also. Issue has been highlighted in yellow.

Answers

  • Ravi Chamarty
    Ravi Chamarty Rank 4 - Community Specialist

    If you are using group left, make it group right while using the BI Publisher Desktop tool from the RTF template. Then, the merging will not happen. check blogs from Tim Dexter and with Oracle Support also these solutions are mentioned