Accessing Oracle functions in Universe Designer (UDT/IDT)

[Former Member]

Hi Experts,

I would like to access Oracle functions in my Universe Designer (UDT/IDT).

It would be helpful if you let me know if any way exists.

[sateesh_kumar1]

Hi Uttam,

all the aggregation functions are supported with UDT/IDT.

do you have any specific function which is causing issues?

[Former Member]

Hi Sathish,

My Scenario is:

I need a custom Function which accepts date as a Prompt and return measure values.

I need this to be consumed in Universe IDT (XI 4.1 SP3).

[sateesh_kumar1]

Is it a daybetween() funciton ? if yes , it'll work.

[Former Member]

Suppose, if we have a function called get_bal(), which accepts date and gives all the details such as Account holder name, Account type, Balance amount,.....etc...as a function output.

And how to consume this function get_bal i Universe IDT, can you please give me a sample pseudo code.

[sateesh_kumar1]

Hi Uttam,

It seems it is a user defined function in database.

afaik it is not supported .To get those details you need to have all the columns as separate objects in the DB in select statement.

[Former Member]

Yes it is possible..

You have to create on procedure on database it self and then import that into universe by creating universe with procedure option while creating new universe.

All the functions and procedures you can add in single universe and at the run time you can pass values from webi reports using @prompt and in return yu can get your desired output by calling that function or procedure.