List of Examples

1-1 Creating the CHANNEL Dimension in an Analytic Workspace

1-2 Creating the ANALYTIC_CUBE Cube in an Analytic Workspace

1-3 Defining a Cube's Dimensionality in an Analytic Workspace

1-4 Preaggregating Costs and Quota in an Analytic Workspace

1-5 Create, Refresh, and Enable a Cube

2-1 Create an OLAP Dimension for the Products Table

2-2 Create an OLAP TIme Dimension

2-3 Create an OLAP Cube for the COSTS Fact Table

2-4 Generate a Validation Report for the PRODUCT Dimension

3-1 Query the Active Catalog for Information about a Workspace Cube

4-1 Query Load Parameters and Enablement View Names for CHANNEL and TIME

13-1 Metadata Command Script for GLOBAL.PRODUCT

13-2 Export Parameter File for GLOBAL.PRODUCT

17-1 Direct a Validation Report to a File

24-1 Sparsity Advisor Script for GLOBAL

24-2 ADVISE_REL: Suggested Preaggregation of the Customer Dimension

25-1 Oracle OLAP XML Document

29-1 View of PRICE_CUBE in GLOBAL Analytic Workspace

29-2 Queries of UNIT_COST_PRICE_VIEW Using OLAP_CONDITION

30-1 OLAP_EXPRESSION: Time Series Function in a WHERE Clause

30-2 OLAP_EXPRESSION: Numeric Calculation in an ORDER BY CLause

31-1 OLAP_EXPRESSION_BOOL Function in a SELECT List

34-1 Template for Creating a View Using Predefined ADTs

34-2 Sample View of the TIME Dimension Using Predefined ADTs

34-3 Template for Creating a View Using Automatic ADTs

34-4 View of the TIME Dimension Using Automatic ADTs

34-5 Script for an Embedded Total Dimension View Using OLAP_TABLE

34-6 Script for a Measure View Using OLAP_TABLE

34-7 Script for a Rollup View of Products Using OLAP_TABLE

34-8 Script Using QDRs in the FAMILYREL Clause of OLAP_TABLE

34-9 Script Using FETCH with OLAP_TABLE

34-10 Syntax of an OLAP_TABLE Limit Map

34-11 WITH Subclause of Limit Map DIMENSION Clause