Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to use xmlquery in OBIEE column formula

Received Response
1
Views
1
Comments
3212463
3212463 Rank 3 - Community Apprentice
edited Aug 13, 2024 6:02PM in Oracle Analytics Cloud and Server

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.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    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 ...