How do I execute the "SQL Issued" in BI Answers using a query tool?
612389Oct 4 2009 — edited Oct 5 2009How 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.