Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Suppress column value in facts table
Note that my version ( 11.1.1.7) is no longer current.
An analysis produces a report of about 25 columns detailing payment transactions to each vendor for a billing period.
The requirement is to suppress the "care days" column so that it only appears once for all of the payment transactions for each vendor for the billing period.
By populating that column only once, the aggregate value would avoid inflating the value of that data element.
Online search indicates that the suppression option will not work for a facts table.
I do not know whether a union of two reports would work in this situation since the output from the analysis consists of 25 columns.
Any suggestions are appreciated.
Answers
-
by suppressing, do you mean remove the column from the analysis?
Have you tried moving the field over to sections or table prompts?
0 -
Each vendor will have multiple payment transactions for a given billing period that are visible in the report, but I only want to display the column in question( care days ) once for one of the transactions for that vendor/billing period.
The other transactions for that vendor should show a null value for that column.Note that the user has the option of populating a dashboard prompt for this column.
I am not clear on the suggestion of moving the column to a section.
0 -
The solution is to reorder the columns so that the column to be suppressed is among the leftmost columns in the output.
This was mentioned in another submission on this forum.
0
