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
Need to use column name as filter name
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
Answers
-
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
0 -
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.
0 -
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.
0 -
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.
0 -
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
0 -
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.
0 -
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:
0 -
Sure. And what about other tools accessing the metadata layer and not the presentation server?
SmartView, ODBC, web service,....
0 -
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.
0 -
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
0
