Home » Fusion Middleware & Colab Suite » Business Intelligence » How to use Procedure and function in OBIEE
How to use Procedure and function in OBIEE [message #329112] Tue, 24 June 2008 03:11 Go to next message
sunilgond
Messages: 35
Registered: January 2008
Location: INDIA
Member

Hi Experts

Can We use procedure and functions in OBIEE.



Regards
Sunil Kumar Gond
Re: How to use Procedure and function in OBIEE [message #329507 is a reply to message #329112] Wed, 25 June 2008 11:01 Go to previous messageGo to next message
dwarak.k
Messages: 61
Registered: June 2008
Location: Hyderabad
Member
Are you using the default package?
If you are using,you can define your procedures and functions in it.You may call the functions in the select statement in the data template using DefaultPackageName.yourFunctonName(,,)

Thanks,
Dwarak
Re: How to use Procedure and function in OBIEE [message #329684 is a reply to message #329507] Thu, 26 June 2008 04:05 Go to previous messageGo to next message
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
Dwarak, cOuld you perhaps provide us with a link to documentation or something clarifying this? I work with OBIEE for a while now, but packages (default or not) doesn't ring a bell, so I'm curious what you mean.
Re: How to use Procedure and function in OBIEE [message #329734 is a reply to message #329684] Thu, 26 June 2008 06:45 Go to previous messageGo to next message
dwarak.k
Messages: 61
Registered: June 2008
Location: Hyderabad
Member
We can generate XML data through "Data templetes" in OBIEE
Data templates is something like data model in the oracle reprots where we define queries and the grouping logic(what should be the parent and what should be the child)

Here in the data template,you can mention your default package where you will have the functions- (the formula functions what you call in oracle reports)procedures etc..)
It is a plain PL/SQL package which has the package global variables in the same name of your report parameters.(this is to ensure that what ever you pass as parameter to the report will be sent to this package global variables)
These variables can be used in your functions/procedures to build the business logic


more about building reports with data templates @
http://download.oracle.com/docs/cd/E12096_01/books/PubUser/T421739T434255.htm

Pls feel free ask incase you need any clarification

Thanks,
Dwarak
Re: How to use Procedure and function in OBIEE [message #329735 is a reply to message #329684] Thu, 26 June 2008 06:45 Go to previous messageGo to next message
dwarak.k
Messages: 61
Registered: June 2008
Location: Hyderabad
Member
We can generate XML data through "Data templates" in OBIEE
Data templates is something like data model in the oracle reports where we define queries and the grouping logic(what should be the parent and what should be the child)

Here in the data template,you can mention your default package where you will have the functions- (the formula functions what you call in oracle reports)procedures etc..)
It is a plain PL/SQL package which has the package global variables in the same name of your report parameters.(this is to ensure that what ever you pass as parameter to the report will be sent to this package global variables)
These variables can be used in your functions/procedures to build the business logic


more about building reports with data templates @
http://download.oracle.com/docs/cd/E12096_01/books/PubUser/T421739T434255.htm

Pls feel free ask incase you need any clarification

Thanks,
Dwarak
Re: How to use Procedure and function in OBIEE [message #329736 is a reply to message #329684] Thu, 26 June 2008 06:48 Go to previous messageGo to next message
dwarak.k
Messages: 61
Registered: June 2008
Location: Hyderabad
Member
Chk out http://blogs.oracle.com/xmlpublisher/2008/01/29

Default package is defined
<dataTemplate name="EMPLOYEES" defaultPackage="" dataSourceRef="demo-hr">
Re: How to use Procedure and function in OBIEE [message #329773 is a reply to message #329736] Thu, 26 June 2008 08:22 Go to previous messageGo to next message
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
Aha, I see. So, this answers the original question for BI Publisher, not for dashboards/answers, right?

OP, if you say OBIEE, which part of it do you refer to?
Re: How to use Procedure and function in OBIEE [message #330503 is a reply to message #329112] Mon, 30 June 2008 05:42 Go to previous messageGo to next message
sunilgond
Messages: 35
Registered: January 2008
Location: INDIA
Member

Hi

I have writen one Procedure in SQL and want to use my procedure in OBIEE Answers.How to use it.



Thanks in advance

Regards
Sunil Kumar Gond
Re: How to use Procedure and function in OBIEE [message #330596 is a reply to message #330503] Mon, 30 June 2008 09:46 Go to previous messageGo to next message
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
Would this answer your question perhaps?
http://oraclebizint.wordpress.com/2008/02/20/oracle-bi-ee-101332-executing-stored-proceduresfunctions-before-reports-before-report-tr iggers-and-global-temporary-tables/
icon7.gif  Re: How to use Procedure and function in OBIEE [message #361293 is a reply to message #329112] Tue, 25 November 2008 14:54 Go to previous message
monica365
Messages: 6
Registered: November 2008
Location: Argentina
Junior Member

Using the evaluate function you can call procedures.

evaluate('procedure_name(%param1)','param_value')

Hope this help,
Monica

Previous Topic: How to add New blank Column in OBIEE
Next Topic: 'All' not showing in Page Items of Pivot table
Goto Forum:
  


Current Time: Thu Mar 28 10:29:05 CDT 2024