List of Examples

3-1 SQL Script for Defining the GLOBAL_AW User

3-2 Startup Parameters for Building Sales History

3-3 SQL Script for Defining Tablespaces for the Sales History Analytic Workspace

3-4 Script for Creating the SH_AW User

3-5 PL/SQL Program for Using the Sparsity Advisor on Sales History

3-6 Recommendations for Sales History in OLAP DML

3-7 Recommendations for Sales History in the Advice Table

4-1 Template for a Forecast

4-2 Forecasting Program for Global Sales

6-1 SQL Statements for Creating the GLOBAL_AW User

6-2 Granting Access Rights to the GLOBAL Analytic Workspace

B-1 Template for Sorting the Time Dimension

B-2 OLAP DML Program for Populating TIME Attributes