nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Need to use column name as filter name

user1636556

Hi,

I have a column in a BI Answers report whose Edit Formula is 'CASE when ...' etc.

It has the custom heading of Location.

When I try and make it into a prompted Filter, the filter name is displayed as 'CASE when ...' etc, instead of Location.

How can I make sure the custom heading is displayed on the filter name ?

Many thanks,

- Jenny

Find more posts tagged with

Accepted answers

All comments

Joel Acha

I'm not sure you can do this unless you create the column in your repository with the CASE statement and name the column accordingly.

Sent from my iPhone

[Deleted User]

NO. You're filtering the expression. Not an actual column. Fitlers have nothing to do with any of the front-end playing options. They're data- and logic-oriented.

Chris Arnold

I think there is a way to do this -- but to do it, you must:

(1) Populate a presentation variable with your prompt

(2) Use a Narrative view instead of the Filters view

So, make your Location prompt into a variable prompt that populates a presentation variable named something like vLoc.

Then in the Narrative section of the Narrative view, put something like this:

Location: @{vLoc}{%}

(be sure to set the 'Rows to display' to 1)

I think that will give you what you want.

[Deleted User]

Well....yes....but... you're not actually showing what you're filtering. You're basically lying because you are not filtering on something called "Location" but a formula.

That's the whole reason why all this front-end cheating is just that: front-end cheating rather than proper development.

user1636556

Hi to All you People that replied ....

Thanks so much for taking the time to reply to my question. I really appreciate it.

It looks as if I can't do it easily. It seems a strange omission of Answers.

So to Chris Arnold - would your suggestion allow the user to enter a value at run time in the Filter prompt

and then the report would use that as search criteria ? Christian Berg seems to suggest that wouldn't work,

or did I misunderstand Christian's reply to your suggestion ?

Kind regards,

- Jenny

[Deleted User]

Jenny,

It will works but it's not really leveraging the standard functionalities of the tool and it can be misleading. If you really HAVE to have that logic then I would put it into an RPD column so that each and every usage is always the same and you don't have to repeat the logic (code!) multiple times.

Joel Acha

Hi @user1636556

I just remembered some new functionality introduced in OBIEE 12c, you could use the Column Save As functionality:

Which you can then access in other Analyses from here:

[Deleted User]

Sure. And what about other tools accessing the metadata layer and not the presentation server?

SmartView, ODBC, web service,....

Joel Acha

That's a valid point @Christian Berg In Jenny's case, this will work but I totally agree with you and mentioned earlier that a more robust solution would be to create this as a logical column in rpd.

[Deleted User]

It's good that this functionalit is finally there but it is in no way a substitution for proper RPD modelling.

Taken the above pointa you can immediately add multilingualism as a probl factor. That translation is by the BI server.

Long story short. RPD column