|
|
| Re: How to use Procedure and function in OBIEE [message #329507 is a reply to message #329112] |
Wed, 25 June 2008 11:01   |
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 #329734 is a reply to message #329684] |
Thu, 26 June 2008 06:45 |
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 |
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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
