Oracle Analytics Publisher Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Publisher Forum

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
27
Views
5
Comments
jmore92
jmore92 Rank 4 - Community Specialist
in Oracle Analytics Publisher Forum

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

  • RVohra
    RVohra Mod

    You can try following …

    • for-each-group for group header
    • current-group() for details