Reviewing a cube

It is usually worthwhile to take a few minutes after you have created an Alphablox cube to ensure that the measures, dimensions, and levels are defined correctly. If you find any errors, you can easily correct them. To do a review on an Alphablox cube, perform the following steps:

1. Log into the Alphablox home page as the admin user or as a user who is a member of the administrators group.
2. Click the Administration tab.
3. Click the Cubes link.
4. Select the Alphablox cube from the list of cubes and click the Edit button. A page showing the Edit Alphablox Cube General tab appears.
5. Verify that the data source specified in the Relational Data Source text box references the desired relational database. You might need to check the settings for the data source on the Data Sources administration page.
6. Before attempting to start the Alphablox cube, verify that Enabled is selected next to the Alphablox Cube Name text box. If it is not enabled, you will see an error message when attempting to start the cube.
7. Verify that your measures are properly created:
   1. Click the Measures node to verify that the table specified in the Measures Fact Table text box is the correct table in the relational schema, the name is spelled correctly, and the name is a fully-qualified name.
   2. For each defined measure, check that the desired aggregation is specified in the Expression text box.
8. Verify that all the desired dimensions have been correctly defined, and that the names are correct. For each dimension, check the following:
   1. Verify that you had added any required fact table join and dimension joins, and that the expressions are correct.
   2. Verify that the levels are correctly specified and appear in the correct order. The first level should be the most summarized level, and each successive level should be the next level down in the hierarchy. For example, if the hierarchy for the Time dimension is Year, Month, Day, then Year should be the first level, followed by Month , followed by Day .
   3. Verify that any attributes that you have defined are correct, including the expected names and expressions.
9. Click the Schedule tab and verify that all the settings are the way you want them.
10. Click the Tuning tab and verify that all the settings are the way you want them.