OBIEE 11G - S_NQ_SUMMARY_ADVISOR table

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics)

1 - About

Description of the SQL log table for the summary advisor. This table is in the metadata repository schema (BIPLATFORM).

3 - Description

Column Name Content
Version Version number of the BI Server
LogicalFactTableId Upgrade ID of the logical fact table
LogicalTableSourceIdVector Upgrade ID(s) of the logical table source(s)
ProcessingTimeInMillisec Time spent on this processing path in milliseconds
QueryLevelIdVector Upgrade ID(s) of the query’s logical level(s)
SourceCellLevelIdVector Upgrade ID(s) of the LTS’s logical level(s)
Logical_Query_Id Foreign key that references the ID column in S_NQ_ACCT
QueryStatus For internal use
Advertising