Step | Task | More Information |
|---|---|---|
1. | Create an aggregate storage application and database manually or by using the Aggregate Storage Outline Conversion Wizard to convert a block storage outline. | |
2. | Create an aggregate storage outline by using the Aggregate Storage Outline Conversion Wizard to convert a block storage outline, by populating the outline that is created when a database is created, or by using data sources and rules files to build dimensions and members (dimension build). | |
3. | Optional: Use the Create Date-Time Dimension wizard to create a date-time dimension and the associated attribute dimensions. |
|
4. | Use tablespaces to optimize data storage and retrieval for data files and work files. | |
5. | Specify the maximum size of the aggregate storage cache. | |
6. | Load data into the database (may be combined with a dimension build). At this point, aggregations exist for all level 0 combinations, and retrievals can be executed against the database. | |
7. | Calculate selected aggregations on the database. | |
8. | View database statistics. | |
9. | Optional: Use the Aggregate Storage Partition Wizard to enable write-back functionality. | |
10. | View data with Spreadsheet Add-in, Data Preview Grid, other Oracle tools, or third-party tools. | Appropriate product documentation. |