Oracle Analytics Publisher

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

Categories

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

BI Publisher - Suppress Repeating Values in RTF template?

Received Response
7
Views
4
Comments
jmore92
jmore92 Rank 4 - Community Specialist
in Oracle Analytics Publisher

In BI Publisher, I have a table inserted and would like to suppress repeating value for a column. How would I go about doing this?

Tagged:

Answers

  • Kevin M-Oracle
    Kevin M-Oracle Rank 6 - Analytics & AI Lead

    You can use a for-each-group to suppress repeating values.

    Rgds,

    Kevin

  • jmore92
    jmore92 Rank 4 - Community Specialist

    I am currently using for-each-group on the data set and grouping by the column I would like the values to be suppressed.

  • Kevin M-Oracle
    Kevin M-Oracle Rank 6 - Analytics & AI Lead

    If you do this in the layout, it will return only unique values for the grouping element.

    Rgds,

    Kevin

  • Rajasekhar Bandaru-Oracle
    Rajasekhar Bandaru-Oracle Rank 6 - Analytics & AI Lead

    Hi

    Refer to the given help center link about for-each-group

    https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-design/use-advanced-report-layouts.html#GUID-A6B56687-BCE4-4D4A-AD75-C80CA372B8E4