How to invoke User defined function from Universe intoReport

building reports desktopintelligence
1

Hi All,

We have user defined functions in Oracle 9i called Conversion Rate(From Currency, To Currency, Currency rate, Currency Date). Now user want to pass different parameters to his user defined functions at report level at time of running the report.

So, Procedure I followed as follows as:

  • Used External Strategies to bring user defined function Conversion Rate into Universe.

Problem: How exactly we invoke same function at report level to pass values through Report?

Any Suggestions on this would be helpful.

Thanks in Advance.

Ravi

ravikulkarni (BOB member since 2004-08-04)

2

You define an object based upon this function as

ConversionRate(FromCurrency, ToCurrency, Currencyrate, CurrencyDate)

The parameters will be supplied by other fields in the query or you can make them prompts.

When you create your query, you will include this object and it will work as intended

Paul Shovlar :uk: (BOB member since 2002-09-05)

3

Paul has got it in a nut shell! One caveat, as database functions can sometimes be quite resource-consuming, we tend to put a note in the help text of the object explaining a little about the way it functions.

Nick Daniels :uk: (BOB member since 2002-08-15)

4

Thanks for the information.

I will try with suggestion, will come back if any details required…

Cheers

Ravi

ravikulkarni (BOB member since 2004-08-04)

5

Hi Paul,

Problem, I facing is user defined function will return Conversion Rate as value.

Is it possible send unv and object, if you have will be really appreciated.

Thanks

Ravi

ravikulkarni (BOB member since 2004-08-04)

6

Hi Ravi

I am not sure what you are asking, sorry :confused:

Have you put the udf in an object and it is not doing what you expect?

What is it that you want if you don’t want the “conversion rate as value” If you want the conversion rate multiplied by the “From Currency” simply modify the object to include this step e.g.

function(p1,p2,p3,p4)*FromCurrency

Paul Shovlar :uk: (BOB member since 2002-09-05)

7

You can attach those file here, provided they are small enough. Just use the Add Attachment button below your next reply.

Nick Daniels :uk: (BOB member since 2002-08-15)