Skip to Main Content
Forums

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!

How do I execute the "SQL Issued" in BI Answers using a query tool?

612389Oct 4 2009 — edited Oct 5 2009
How do I take the 'SQL Issued' from the 'Advanced' tab in a request in BI Answers and run its equivalent against the database tables, using a tool like in SQL Developer?

For instance BI Answers shows 'SQL Issued' of:

SELECT Team2."Team2 Dtl" saw_0, Year2."Year" saw_1, Cube2.Hr saw_2
FROM "AW_BALL2 Cube2"
WHERE Year2.Decade = '2000s'
ORDER BY saw_0, saw_1, saw_2

How do I translate this into something that will run in SQL Developer and show me the same data that the request is pulling? Thanks.
This post has been answered by rmoff on Oct 5 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 2 2009
Added on Oct 4 2009
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
5 comments
1,002 views