Update Filter view in OBIEE report

Question

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?

Chris Arnold · Answer

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.

Joel Acha · Answer

Some screenshots    of what you're trying to do would be helpful in trying to understand your issue.

Gianni Ceresa · Answer

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.