G Report Query Table Reference

When creating reports, you can use a base SQL query and a parameter SQL query to enhance the data shown in the report. The base SQL query can be used to pull data from various tables and display the data as report output. For example, using one query definition, you can show different columns or groupings. In one report, you can list amounts by account and group by entity, and in another list amount by entity and group by account.

The parameter SQL query enables you to run a query against the parameters in the report definition. For example, the query can be used to select the Location, Period, Category, or Account groupings. In one report, you can list amounts by account and group by entity, and in another list amount by entity and group by account.

The Oracle Hyperion Financial Data Quality Management, Enterprise Edition tables that are used in the base and parameter SQL query are:

• TDATASEG

• TLOGPROCESS