SAS Institute. The Power to Know

SAS(R) 9.2 OLAP Server: User's Guide

Previous Page | Next Page

Building Cubes and Administering Cubes

Cube Designer Wizard

Within SAS OLAP Cube Studio, the Cube Designer wizard guides you through the process of building a cube. You can create cube definitions as well as build complete cubes. The following are some tasks that you can perform:

  • define the data sources used to load a cube

  • specify any drill-through tables used by the cube

  • define the cube dimensions, levels, and hierarchies

  • select measures and measure details for the cube

  • specify unique member count measures (NUNIQUE)

  • specify member properties

  • configure aggregations

  • select language translation tables for a star schema's dimension tables

  • define user-written formats to create the cube

  • define how to handle missing values for ragged hierarchies

Previous Page | Next Page | Top of Page