OBIEE 11G - S_NQ_SUMMARY_ADVISOR table

Obi Edition

About

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

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





Discover More
Obiee Summary Advisor
OBIEE 11g - Exalytics Summary Advisor

The Summary Advisor is a tool that evaluate the collected statistics (Cache hits are ignored) recommend aggregates and creates an aggregate persistence script After the Summary Advisor Statistics...



Share this page:
Follow us:
Task Runner