Application tutorial

Follow the steps detailed below to see the product functionality.

  •  Go into the Windows control panel clicking in the Windows start menu, choose one of the following options: Configuration -> Control Panel -> Data Sources (ODBC) or Configuration -> Control Panel -> Administrative Tools -> Data Sources (ODBC). Press the Add button to create a new ODBC data source for this tutorial. Choose from the list option Microsoft Access Driver (*.mdb) and click the Finish button. In the text Data Source Name type Tutorial. Press the Select button and choose the application installation directory from the directory tree. Choose file gs.mdb and press OK to select the tutorial file. Press OK again to finish creating this data source and press OK once again to leave the ODBC Administrator.
  • Choose Assistant cube creator from the Start Menu of your PC.
  • If you are evaluating your product, press the Start evaluation or Continue evaluation  button to enter the application.
  • Type the name of the cube in Name's cube that you'll create: Tutorial.
  • Select from the list the newly created Turorial data source.
  • Press the Next button to go to section Source database table or file selection.
  • Press the Add button twice, one to add the customer table, and then the orders table.
  • Press the Next button to proceed to section Select fields from database.
  • All fields from all tables selected are shown in the screen.
  • Press the Next button to go to section Identify relations between the tables in the query.
  • Choose the customer table in the left side of the screen and table orders on the right side. There will appear the fields from each of the tables in the middle part.
  • In the middle part of the dialog, choose the field  CUSTOMERNU on both sides and press the Add button to create the relation.
  • Press the Next button to process to section User´s prompt creation.
  • There won't be any prompts created, so press the Next button and proceed to section Seach criteria creation.
  • We will use for the cube all orders whose total amount is above 5,000US for this tutorial. Press the Add button to create a new search criteria. The Add condition dialog appears.
  • Choose from the list the field orders.ORDERTOTAL, and the comparision operator Greater than (>) and 5000 in Value 1 text.
  • Press the OK button to exit this dialog and press the Next  button to go to section Field selection to sort the query.
  • It's not important to order the query's fields, so press the Next button and proceed to section Optional modification of generated SQL.
  • Press the button See data to see you query data. There should appear 172 records in the query. Press the OK button to exit this screen and press the Next button to go to section Creation of the cube Measures dimension .
  • Using the Remove button, take off from the list the measures customer.DISCOUNT and  customer.CREDITLIMI. You must be careful when mixing values from tables that have master-detail relationship, because the numeric data of the master table can be repeated several times.
  • Press the Next button and proceed to section Dimension and level creation.
  • Press the Add Dim to add a dimension to the cube. The Add dimension dialogo will appear.
  • Write  Customers as the dimension name. Press OK to exit this dialog.
  • Press the Add Level to add a level to this dimension. The Add level dialog will appear.
  • Type  Region as the level name.
  • Press the Choose button, double click on field  customer.REGION and press OK to define this level.
  • Press the Add Level to add a level to this dimension. The Add level dialog will appear.  
  • Type Country as the level name.
  • Press the Choose button, double click on field  customer.COUNTRY and press OK to define this level.
  • Press the Add Level to add a level to this dimension. The Add level dialog will appear.
  • Type Customer as the level name.
  • Press the Choose button, double click on field  customer.COMPANYNAM and press OK to define this level.
  • Press the Add Dim to add a dimension to the cube. The Add dimension  dialogo will appear.
  • Type  Date as the dimension name.
  • Press the check box  Is this a time dimension?
  • Press the Choose button and select the field  orders.ORDERDATE .
  • Press OK to exit this dialog.
  • Press the Add Dim to add a dimension to the cube. The Add dimension  dialogo will appear.
  • Type Salesman as the dimension name.
  • Press OK to exit this dialog.
  • Press the Add Level to add a level to this dimension. The Add level dialog will appear.
  • Type  Key as the level name.
  • Press the  Choose button to select the customer.SALESPERSO database field.
  • Press OK to exit this dialog.
  • Press the Nextbutton to proceed to section File or cube output selection.
  • Press the Choose button and selct the cube Tutorial. Press the Save button to save your cube.
  • Press the Next button to proceed to section Cube creation.
  • Press the Create cube to create the cube.
  • Click the OK button once the cube created succesfully appears.
  • Press the Save button to save this cube definition.
  • Press the Exit button to exit this assistant.
  • Your local cube is ready to be used.

Here ends this tutorial.