This tutorial guides you through the stages to create a simple cube using the minimal number of steps possible.
Further explanation of the various screens can be found in the Reference Pages.
Creating A Simple Cube
1. Run CUBE-it Zero
2. The Settings Wizard is displayed the first time the application is run.
If you would like to find out more detail on a particular screen click the "More info..." link and a more vobose emplanation will appear
For most people the clicking next will be fine
3. Enter the server to create the cube on.
4. The logon credentials for the database server.
5. Select the working database from the dropdown list
6. The last settings
7. The main CUBE-it Zero screen is displayed.
8. The Setting Wizard is not displayed when the application is run in the future, the first screen will always be the main CUBE-it Zero screen using the last settings that were stored. To change these settings use the Tools - Configuration menu. By default the Data Source connection will be valid as it is the selection where the cube will be built. To use a different data source click the 'Connect to the source of the data' button.
9. Click the 'Design a data source query' button to open the CUBE Source Query screen. Create your query by using the GUI interface or by typing or copying/pasting SQL into the query textbox.
10. Check your query produces the desired results in the Output Sample tab.
11. Click back to the Query Source tab and click the OK button to return to the main CUBE-it Zero screen. The data source is now valid.
12. Click the 'Design the cube structure' button to open the Cube Design screen.
13. Enter a cube name and database, then select which fields in your query are Dimensions, which are Measures, and also a Time Dimension if you have one. Optionally, Cube hierarchies enable grouping of data for related Dimensions. Measures must have an aggregation function, the default is Sum. Both hierarchies and aggregation functions can be select using the More button.
14. Click the OK button to return to the main CUBE-it ZERO screen. You have now completed the Definition of your cube. The cube structure is now valid and a final 'Process the cube' button is now available.
15. Click the 'Process the cube' button, a splash screen will show you the progress, and then finally the main screen will show the cube is complete.
You have name completed the Generation of the Cube Data.
Browsing The Cube
So there it is, a dozen steps to create a cube. But where is it? In SQL Server Analysis Services in the Database you created, with the name you chose.
Then browsing the cube will give you a fast way to analyse your multi-dimensional data.
