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
-
-
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