How to create links with multiple values in a column?

[Deleted User] · Jun 10, 2020 6:50AM

SonPat99 wrote:Does your source really store "a, b, c" , "f, g", "10; 20", "40; 50; 10" as values?No, this is a UI and the UI is showing multiple values for a specific field; which again stores the data in column format (and not row-wise).We are using PIVOT to convert the data in ROW Wise format and in the same process, using LISTAGG to club all the values for a column (like Department).

So your source DOES store the distinct values and you transform the data into the form you show in the image. You HAVE the raw data.

The answer to Gianni's question is "Yes", and not "No". The problem you face is custom-made by yourself.

Gianni Ceresa · Jun 10, 2020 6:55AM

If instead of concatenating 'a, b, c' you concatenate '<a href="...">a</a>, <a href="...">b</a>, <a href="...">c</a>' you still get a string as value.

The difference is that this string is an HTML string and you can kindly ask OBIEE to shows it as HTML instead of just a string. The HTML contained in your string will turn the 3 values into links.

SonPat99 · Jun 10, 2020 8:48AM

Hello Gianni,

Please allow me sometime to check on this, maybe a day or so.

Will update with my findings.

[Deleted User] · Jun 10, 2020 9:17AM

You understand what we're saying here, correct?

a) Either show everything row-wise and use vanilla functionality (links) or

b) first href everything and then do all the LISTAGG/PIVOT that you need to put the values into columns

SonPat99 · Jun 11, 2020 2:16AM

Yes, I have understood the details. Thanks for checking again.

Oracle Analytics Forum

Categories

How to create links with multiple values in a column?

Answers