Building Cubes and Administering Cubes |
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
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.