How to use xmlquery in OBIEE column formula

Question

Hello All,

I am using DB2 database and OBIEE 10g version for reporting.

I have below query giving be desired o/p.

select id,

xmlquery ('distinct-values($x//row)' passing xmlgroup (name) as "x")

from test

group by id

now I want to implement  'xmlquery ('distinct-values($x//row)' passing xmlgroup (name) as "x")'  in  OBIEE column formula.

Can someone provide i/ps how we can implement xmlquery in obiee column formula?

Any template or example of use of xmlquery in column formula will also help.

Gianni Ceresa · Answer

Hi,

XMLQUERY is a database function, OBIEE isn't aware of that function and will never do anything with it.

So you can use a direct database request (I guess it already existed in 10g, but as you use a 10+ years old tool ... difficult to be sure) or EVALUATE (assuming this one also existed at that time).

PS: not sure of the reasons to still use 10g as there is not any support anymore for it ...