Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Parameter in inline view

H.OAug 29 2007 — edited Sep 3 2007

Hi All,
There is a requirement to change oracle report (rdf) to discoverer. The report query has parameters in inline views which are used as tables (a and b below).
For example:

SELECT a.1,a.2,b.1,b.2
FROM
( select 1,2... from c where c.sth=:Parameter1) a
,( select 1,2... from d where d.sth between :Parameter2 and :parameter3) b

Now that, c.sth or d.sth are not available in select clause, How do i apply the parameters from discoverer desktop.
Also, is there any approach i can follow to solve the same.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 1 2007

Added on Aug 29 2007

#business-intelligence-applications, #business-intelligence-foundation, #discoverer

10 comments

1,012 views