OLAP Data Cube Wizard

Once you have added an OLAP Data Cube object to your form, you can double-click on the object to open the OLAP wizard. Here are the steps you will follow to create the OLAP Data Cube:

  1. Configure the main properties of the cube.
  2. Build the SQL statements.
  3. Configure Measures.
  4. Configure Dimensions.
  5. Apply a Style.

Once you have completed the wizard you will be taken back to the Form Designer screen. Visit Scheduling OLAP Data Cubes for specific instructions on creating scheduled cubes.

Also refer to Example 6 (Creating a Filtered OLAP Data Cube) in the Argos DataBlock Designers Guide. This example contains a step-by-step tutorial demonstrating how to build a filtered OLAP Data Cube.


Configure the main properties of the cube

The Build OLAP Data Cube dialog which contains the General, Totals, and Sub Totals options


Format Total Columns

The available options when selecting Totals.  Options include fields for specifying  the placement of  Row and Column Totals.  Options include fixed, at the beginning, or at the end.

Select the location of both the row and column totals. Selecting None will hide the totals. Fixed places the totals at the end and fixes them in place so they always appear along the bottom, instead of requiring you to scroll all the way down.


Format Sub Total Columns

The available options for display and positioning of Sub Totals.  You have the option of showing or hiding Sub Totals.  You also have the option of placing the Sub Totals before or after the group being summed.

If you choose to show the subtotals you can then select the positioning for them.


Need More Help?

If you need additional help creating OLAP Cubes, refer to the Getting Started with OLAP Cubes page.

Also refer to Example 6 (Creating a Filtered OLAP Data Cube) in the Argos DataBlock Designers Guide. This example contains a step-by-step tutorial demonstrating how to build a filtered OLAP Data Cube.