Oracle Communities

Oracle Analytics and AI

Child Item

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!

Find more posts tagged with

Prompt

Accepted answers

Gianni Ceresa

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.

All comments

Gianni Ceresa

Hi,

Because you talk about an analysis, I assume you are using "classic" and your source is the RPD (semantic model).

Joel Acha

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.

Jerry Casey

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)

AM HRE

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

AM HRE

Thank you too for your replies @Joel and @Jerry Casey