Home » Fusion Middleware & Colab Suite » Business Intelligence » table function as physical table in Oracle BI EE (OBIEE)
icon5.gif  table function as physical table in Oracle BI EE [message #572267] Sun, 09 December 2012 11:35 Go to next message
ecivgamer
Messages: 147
Registered: May 2011
Location: Ukraine
Senior Member
Hi all,

how do I import oracle table function as physical table in Oracle BI EE ? Let's say it is

select * from scheme.table_function1(adate)

What is correct syntaxis for setting it as BI physical table? How do I specify input parameter (adate)?
Re: table function as physical table in Oracle BI EE [message #572988 is a reply to message #572267] Wed, 19 December 2012 04:19 Go to previous message
ecivgamer
Messages: 147
Registered: May 2011
Location: Ukraine
Senior Member
Hi all,

My pipelined function works well as physical table with hardcoded input parameters, now I'm trying to pass parameters.

1. I've created non-system session variable:
http://s10.postimage.org/mwf3r7bqd/variable_191212_0001a.jpg

2. I use initialization block:
http://s11.postimage.org/5qxo4bucv/variable_191212_0002a.jpg

3. I've set my variable in pipelined function:
http://s8.postimage.org/n6zoz8az5/variable_191212_0003a.jpg

4. Got error during run "View data" in Physical section of Oracle BI Administration Tool:
http://s7.postimage.org/i3db9nrhz/variable_191212_0004a.jpg

What is wrong?

[Updated on: Wed, 19 December 2012 05:06]

Report message to a moderator

Previous Topic: OBIEE Reports or Answers MultiLANGAUGE or UTF8 Issue
Next Topic: How to Change Password
Goto Forum:
  


Current Time: Thu Mar 28 03:07:07 CDT 2024