Categories
- All Categories
- 147 Oracle Analytics News
- 27 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
OAC - Concatenated Code and Description in Prompt, Filter by Code Only
Hi everyone,
Is it possible to create a prompt in an analysis that displays a concatenated value of code and description, but allows filtering only on the code? If so, could you please provide some guidance or examples on how to achieve this?
Thank you in advance!
Best Answer
-
Hi,
Because you talk about an analysis, I assume you are using "classic" and your source is the RPD (semantic model).
You could create your concatenated column in there and then assign the "Descriptor ID" to that column being your code. The Description ID on a logical column is meant to handle the case when you have a technical column or a numeric ID (like your code), and a longer more business friendly text description. You want your users to select the readable version while being able to use the ID to filter for your queries to be faster.
1
Answers
-
As @Gianni Ceresa said, you can use the double column descriptor id feature in your rpd/semantic model. If your underlying data source isn't from an rpd/semantic model, you won't be able to use the double column descriptor id column feature. Double Column feature.
0 -
If you don't have double columns enabled, you can create a variable prompt based on your concatenation.
Say your prompt produces a presentation variable "varConcat", with a value like CityCode||' - '||CityName, say "13 - Rome".The analysis can be filtered like:
CityCode=Left('@{varConcat}{xxx}',2)0 -
Hi,
Thank you @Gianni Ceresa for the clarification. Your suggestion will help us ensure the users can select the readable version but while still utilizing the ID for faster queries.
We'll proceed with this approach.
Thanks again for your help!
Best regards
0 -
Thank you too for your replies @Joel and @Jerry Casey
0
