The fastest way to create a metaoutline is to use the Metaoutline Assistant.

Click Show me to see how you create a metaoutline.

To create an Accounts dimension, copy some or all of the tables from the Accounts dimension in the star schema.

 

Click Show me to see how to create an Accounts dimension.

Continue copying tables until you have the dimensions you want in your metaoutline.

Click Show me.

You can change the properties of your dimensions to focus on specific business problems.

Click Show me.

You can even change the properties of the dimension members.

Click Show me.

To further simplify your analysis, you can use filters to limit the amount of information in your results.

Click Show me.

After you finish the metaoutline, you can create the OLAP application and start your analysis.

Click Show me.

1 of 7

2 of 7

3 of 7

4 of 7

5 of 7

6 of 7

7 of 7

When you create a warehouse, you prepare data for your business users to analyze. DB2 Universal Database provides powerful tools for that analysis, including online analytical processing (OLAP) tools. DB2 Universal Database offers the DB2 OLAP Starter Kit, a version of DB2 OLAP Server® that lets you apply OLAP techniques to your DB2 data at no extra cost. Both the DB2 OLAP Starter Kit and DB2 OLAP Server are based on Essbase, the market-leading OLAP technology from Hyperion Solutions.