| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
WarehouseArchitect - User's Guide |
![[-]](/dwicons/i_colpse.gif)
| Part 3 WarehouseArchitect Model |
|
| Chapter 11: WarehouseArchitect Model Basics |
| What is a WAM? |
| Objects in a WAM |
![[+]](/dwicons/i_expand.gif)
| Defining a WAM |
| Opening an existing PDM |
|
| Chapter 12: Building a WarehouseArchitect Model |
|
| Defining tables |
|
| Defining domains |
| Specifying an abstract data type |
|
| Defining columns |
|
| Defining references |
|
| Defining keys |
|
| Defining indexes |
|
| Defining views |
|
| Defining extended attributes |
| Defining default physical options |
|
| Chapter 13: Creating Links to Operational Systems |
|
| Defining external databases |
|
| Importing objects from an external database |
|
| Defining external tables |
|
| Defining external columns |
|
| Defining links to external sources |
|
| Editing extraction expressions |
| Generating an extraction script |
|
| Chapter 14: Defining Multidimensional Objects |
|
| Defining facts and dimensions |
|
| Defining fact tables and dimension tables |
|
| Defining metrics and attributes |
|
| Defining fact hierarchies and dimension hierarchies |
| Adding a SQL Cube expression to a fact or metric |
| Adding a formula to a metric |
| Retrieving multidimensional objects |
|
| Chapter 15: Creating a Multidimensional Model |
| What is a multidimensional model? |
|
| What is the Multidimensional Hierarchy? |
|
| Managing objects |
|
| Defining facts and dimensions in the Multidimensional Hierarchy |
|
| Defining fact hierarchies and dimension hierarchies in the Multidimensional Hierarchy |
|
| Defining metrics and attributes in the Multidimensional Hierarchy |
| Defining an attribute hierarchy |
| Rebuilding the Multidimensional Hierarchy |
|
| Chapter 16: Aggregation and Partitioning |
|
| Aggregating a fact |
|
| Partitioning a fact |
|
| Chapter 17: Generation for OLAP Systems |
| What is an OLAP system? |
| Choosing a target OLAP engine |
|
| Rebuilding and generating cubes |
| Generating for PowerDimensions |
| Generating for Oracle Express |
| Generating for Essbase |
|
| Generating for DSS Agent |
| Generating for Cognos Impromptu |
|
| OLAP extended attributes |
|
| Chapter 18: Creating a WAM for Sybase Adaptive Server IQ |
| Sybase Adaptive Server IQ |
| Migrating from Sybase IQ to Sybase AS IQ |
| Selecting the target database |
| Rebuilding indexes |
|
| Defining join indexes |
|
| Customizing scripts for join indexes |
|
| Generating a Sybase AS IQ database |
|
| Chapter 19: Managing WarehouseArchitect Models |
|
| Managing users and owners |
|
| Checking a WAM |
| Merging two WAM |
| Importing an ERwin model into a WAM |
|
| Chapter 20: Reverse Engineering |
|
| Generating a WAM from an existing database |
| Generating a WAM from a database creation script |
|
| Chapter 21: Triggers and Procedures |
| What is a trigger? |
|
| Using trigger templates |
|
| Using template items |
|
| Using triggers |
|
| Defining stored procedures and functions |
|
| Using variables in triggers |
|
| Using macros |
|
| Generating triggers and procedures |
|
| Chapter 22: Database Creation and Modification |
|
| Using the ODBC interface |
|
| Accessing a database |
|
| Computing database size |
|
| Configuring tablespace and storage |
|
| Customizing scripts |
|
| Generating a database |
|
| Using test data |
|
|