OraFAQ Forum: Business Intelligence » table function as physical table in Oracle BI EE

Home » Fusion Middleware & Colab Suite » Business Intelligence » table function as physical table in Oracle BI EE (OBIEE)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

table function as physical table in Oracle BI EE [message #572267]

Sun, 09 December 2012 11:35

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)?

Report message to a moderator

Re: table function as physical table in Oracle BI EE [message #572988 is a reply to message #572267]

Wed, 19 December 2012 04:19

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 00:59:59 CST 2025