List of Examples

• 3-1 Sparsity Advisor Script for GLOBAL
• 3-2 ADVISE_REL: Suggested Preaggregation of the Customer Dimension
• 4-1 Oracle OLAP XML Document
• 6-1 View of PRICE_CUBE in GLOBAL Analytic Workspace
• 6-2 Queries of UNIT_COST_PRICE_VIEW Using OLAP_CONDITION
• 7-1 OLAP_EXPRESSION: Time Series Function in a WHERE Clause
• 7-2 OLAP_EXPRESSION: Numeric Calculation in an ORDER BY CLause
• 8-1 OLAP_EXPRESSION_BOOL Function in a SELECT List
• 11-1 Template for Creating a View Using Predefined ADTs
• 11-2 Sample View of the TIME Dimension Using Predefined ADTs
• 11-3 Template for Creating a View Using Automatic ADTs
• 11-4 View of the TIME Dimension Using Automatic ADTs
• 11-5 Script for an Embedded Total Dimension View Using OLAP_TABLE
• 11-6 Script for a Measure View Using OLAP_TABLE
• 11-7 Script for a Rollup View of Products Using OLAP_TABLE
• 11-8 Script Using QDRs in the FAMILYREL Clause of OLAP_TABLE
• 11-9 Script Using FETCH with OLAP_TABLE
• 11-10 Syntax of an OLAP_TABLE Limit Map
• 11-11 WITH Subclause of Limit Map DIMENSION Clause