How to get the SQL of a report made through Subject Areas
Summary:
We need to extract the source SQL code of a report made through subject areas
Content (required):
How can we get the source SQL code of a report made by subject area. We see that the "Advanced" tab exists within the report where a "SQL Issued" is shown, but we understand that this SQL is somehow a "View". Is there a way to extract the source SQL?, that is, where the real tables with the real field names actually appear?, for example:
SELECT NAME,
STATUS_CD,
CURRENCY_CODE,
FROM MOO_OPTY
This is because we need to complement a report in a data model to combine it with a table of attachments.
0