SQL Info
SQL is the language through which relational databases express themselves when operating on data. SAP BusinessObjects tools store SQL in their report/component files. MetaMiner extracts this information and stores it in its SQL container tables for Webi, Deski and Crystal reports.
Universe Class |
Object Name |
Description / Purpose |
|---|---|---|
|
Dataprovider ID |
Internal ID of the data provider |
Query ID |
Internal ID of the Query ID |
|
SQL Container ID |
Internal ID of the SQL Container ID |
|
SQL Text |
The most recently generated SQL for this dataprovider, but not necessarily the same SQL that will be generated by Web Intelligence. What we mean by this is: If the report has prompts, it may generated a modified where clause that you can only capture via the Audit DB. |
|
SQL Container Operator |
The operator used to join multiple queries within a dataprovider (based on SET union/intersect notation) |
|
Webi 1200 Document ID |
Foreign key to the main Webi XI3 document's unique ID, or WEBI1200_DOCUMENTS.ID |
|
SQL Text Filter (Webi) |
A predefined condition that, when dragged into a report, prompts a user for a free-text search for any dataprovider SQL. |
See also