Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Column value suppression in the middle columns in report

Hi friends,
Im in obiee 11g. I have a report where im getting the column value suppression issue. Find the below screenshot
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
-
Suppression works on dimensional attribute columns, not on aggregate-able fact/measure columns.
0 -
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
0 -
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).
0 -
Thanks Gianni, for the right explanation;-)
Regards,
Saro
0