How to use custom functions in BO?

system · September 28, 2007, 7:10am

I need to use an oracle function in a select statement.

Can anybody help me to use it?

Thanks,

Ranjan

ranjan.sahoo (BOB member since 2007-06-11)

system · September 28, 2007, 7:13am

which function you want to use.Please specify…

Deepz (BOB member since 2007-06-04)

system · September 28, 2007, 7:55am

Hi,
Although you have posted the question in designer , I still want to ask, is the report a universe based or free hand SQL report.

If you want to have one oracle function in the select statement then use put the oracle function syntax in the select part of the object definition.
It will put in the select statement when the query is formed from the selected objects for a report.

Hope this clears your doubt. Else do revert back.

Omkar Paranjpe (BOB member since 2006-02-13)

system · September 28, 2007, 8:21am

Hi Omkar,

The report is based on universe.

Is this that we need to create an object and put the function inside it?

any constraints for this or no isuues if we put that function inside an object.

Thanks,

Ranjan

ranjan.sahoo (BOB member since 2007-06-11)

system · September 28, 2007, 9:02am

Hi,
You juat have to put the function code which will be a object code when dragged in the report.

Omkar Paranjpe (BOB member since 2006-02-13)

system · September 28, 2007, 9:29am

Ok thanks omakr.

i am looking into it.

Thanks,

Ranjan

ranjan.sahoo (BOB member since 2007-06-11)

system · September 28, 2007, 10:14am

Hi,
Please spell my name correct raanjan , It is Omkar and not omakr

Omkar Paranjpe (BOB member since 2006-02-13)

system · September 28, 2007, 10:37am

HI Omkar,

I am really sorry for that. It was just a mistake.

Thanks,

Ranjan

ranjan.sahoo (BOB member since 2007-06-11)

system · September 28, 2007, 10:47am

Hi Ranjan,
Even I was kidding, It’s OK

Omkar Paranjpe (BOB member since 2006-02-13)

system · October 1, 2007, 10:13am

Hi

Business Objects Universe/ Report support all the functioalities of oracle except a few like instring function.

Regards

Siva.M

looksmee (BOB member since 2006-02-08)

system · October 4, 2007, 6:42am

I think even we can use instring function.

Thanks,

Ranjan

ranjan.sahoo (BOB member since 2007-06-11)

system · October 4, 2007, 7:28am

Hi

I was missed out something. …its available in BO and thanks for your information.

Regards

Siva.M

looksmee (BOB member since 2006-02-08)

system · October 4, 2007, 7:32am

Ok. u r most Welcome…

Thanks,

Ranjan

ranjan.sahoo (BOB member since 2007-06-11)

system · October 4, 2007, 7:40am

HI

Click Formulas in the Business Objects Reporter Module] to get a guide for creating function.

Regards

Siva.M

looksmee (BOB member since 2006-02-08)

system · October 11, 2007, 6:16am

Ok. Thanks Siva…i got the guide.

Thanks,

Ranjan

ranjan.sahoo (BOB member since 2007-06-11)

system · December 12, 2007, 2:19pm

That link takes you to a report function guide, totally different to what was being discussed here - database functions…

Mak 1 (BOB member since 2005-01-06)