Column value suppression in the middle columns in report — Oracle Analytics

Oracle Analytics Cloud and Server

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

Column value suppression in the middle columns in report

Received Response
32
Views
4
Comments
Saro
Saro Rank 5 - Community Champion

Hi friends,

Im in obiee 11g. I have a report where im getting the column value suppression issue. Find the below screenshot

Column Supression.PNG

In the above report on the 3rd row, you can see that the customer name and invoice date column values are suppressed and then u can see line number 1 and 2 which is different and that is fine. After this line number column you can see the organization and the currency column which has the same value has to suppress since in the column properties i specified it as suppress but it is not happening and it is repeating. And also the measure columns total invoice amount and remaining invoice amount column also needs to suppress. How can i achieve this in the report. Is there a possible way.

Thanks in advance.

Regards,

Saro

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Suppression works on dimensional attribute columns, not on aggregate-able fact/measure columns.

  • Saro
    Saro Rank 5 - Community Champion

    Dear Thomas,

    Thanks for the reply. If that so, then my attribute column organization and invoice currency is repeating, even though i marked it as a suppress under column properties.

    Is it possible to suppress them.

    If i move my attribute column organization and invoice currency before my line number columns means, then the values of organization and invoice currency column is suppressing. But i need these columns organization and invoice currency to be placed after my line number column only as per the layout of my report.

    What could be the possible solution for this?

    Regards,

    Saro

  • Suppression is a left to right thing, it suppress as much as configured from left to right, but when your "Line number" column is reached it can't suppress and merge the cells of "Organisation" as they are related to different "Line number". So "Line number" stop the suppression of other columns and any other column on the right can only be suppressed by "Line number" (so if many rows with same "line number" and same "Organisation" it will suppress it again).

  • Saro
    Saro Rank 5 - Community Champion

    Thanks Gianni, for the right explanation;-)

    Regards,

    Saro