OTN Discussion Forums : Need help in SQL code in BI publisher ...

This question is answered. Helpful answers available: 4. Correct answers available: 1.

Reply to this Thread

Search Forum

Back to Thread List

Replies: 1 - Pages: 1 - Last Post: Sep 1, 2008 3:47 AM Last Post By: rwillems

Sid_001

Posts: 37
Registered: 08/22/08

Need help in SQL code in BI publisher
Posted: Sep 1, 2008 3:34 AM

Let me explain you my question with one example:-

Below is the query which is created in one of the data sets of BI publisher. ----
select ENAME, DEPTNO from SCOTT.EMP where empno=:p_empno;

I need to use value of DEPTNO from above query in one of the sql of another dataset. How should I proceed? I am using BIP 10.3.3 version.

rwillems

Posts: 1,053
Registered: 01/10/01

Re: Need help in SQL code in BI publisher
Posted: Sep 1, 2008 3:47 AM

in response to: Sid_001

Helpful

Hi,

instead of using SQL as Data Source I would use a Data Template, where you can have multiple SQL-Statements which you can link together like you want. For an example have a look in the docs: http://download.oracle.com/docs/cd/E10383_01/doc/bip.1013/b40017/T421739T434255.htm

Regards
Rainer

Pages: 1

Back to Thread List

Legend
	Guru : 2500 - 1000000 pts
	Expert : 1000 - 2499 pts
	Pro : 500 - 999 pts
	Journeyman : 200 - 499 pts
	Newbie : 0 - 199 pts
	Oracle ACE Director
	Oracle ACE Member
	Oracle Employee ACE
	Helpful Answer (5 pts)
	Correct Answer (10 pts)