Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI 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
