All -
Due to a poor database design on the backend (I did not design it nor can I change anything), we would like to get the SQL from a user created query in Webi so we can parse the code (straight ad-hoc, not custom SQL). I would like to pass the SQL as a variable to an Oracle pipelined function implemented as a derived table in the universe. None of the universe variables seem to provide this, but obviously it is available via the Edit SQL button and is saved in the Audit tables.
Does anyone have a solution for this?
Thanks in advance...
Shawn Jones
TEOCO