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
Update Filter view in OBIEE report
Hi, i have one report. it has multiple filters.one of the filter is like COUNT(Column Name) = Prompt value. when i pull filter view into compound view it's showing as Count(Column name) filter in that report outpt... is there anyway i can update COUNT(Column Name) to what ever name i want?
Answers
-
Not really, the filter view show you the column name or formula, so if you used a formula instead of a column from the RPD you see the formula.
0 -
Some screenshots of what you're trying to do would be helpful in trying to understand your issue.
0 -
I believe there are 2 ways you can achieve this:
(1) Just as Gianni Ceresa said -- you can create the count column in your RPD. That way it will show up in your filter view with whatever name you gave the column in the RPD
or
(2) Instead of using the Filter view, you use a Narrative view. For example...
If I have a prompt that populates a variable called vPrompt and I wanted it labeled 'Prompt Value', then I would creat a Narrative view in the report with the following syntax in the Narrative section of the Narrative view:
Prompt Value: @{vPrompt}
Lastly, set 'Rows to display' to 1 in your Narrative view.
I hope this helps.
0
