Main Tasks for Users - SAS Data Integration Studio 3.3 User's Guide - page 117

walks you through the process of specifying an OLAP schema, source data, and any
other cube definitions such as calculated measures, drill-through tables, and
aggregations.
Another method of creating and updating cubes is to write SAS programs in the
Source Editor. The cubes are defined in OLAP procedures. When the programs are
ready to run, you can submit them for execution from the Source Editor or you can
include them in stored processes and run them at a later date.
In both the Cube Designer and in the OLAP procedure (PROC OLAP), you can
choose to define cube metadata only and create the physical cube at a later date.
Cubes can be defined as targets in jobs, though the data that is written to those
cubes is not available to cube viewers until the cube is updated.
Cubes that appear in the inventory of SAS Data Integration Studio are included in
impact analyses that involve cube data or cube source data.
Prerequisites for Cubes
Follow these general steps to begin building and querying cubes with the Cube
Designer:
1 Install a SAS OLAP Server.
2 Add metadata for the SAS OLAP Server. (You can specify the SAS OLAP Server
as one component of the default SAS application server for SAS Data Integration
Studio.)
3 Define an OLAP schema and assign the SAS OLAP Server to the schema.
4 Define cube source tables using the Source Designer.
5 Start the SAS OLAP Server.
For details about these tasks, see the SAS OLAP Server: Administrator's Guide and
the SAS Intelligence Platform: Administration Guide .
Additional Information About Cubes
Extensive information on building and maintain cubes is available in the Help for
SAS Data Integration Studio. To display a list of links to all cube-related Help topics,
including examples, open the Help browser and search for “Maintaining Cubes”.
The documentation for the SAS OLAP Server software provides complete coverage of
SAS OLAP Cube Studio, the OLAP procedure, and the SAS OLAP Server Monitor in
SAS Management Console. See the SAS OLAP Server: User's Guide and the SAS OLAP
Server: Administrator's Guide .
For information about the configuration of SAS OLAP Servers on SAS Workspace
Servers, see the SAS Intelligence Platform: Administration Guide .
Additional Information About User Tasks
The Help for SAS Data Integration Studio provides additional information about user
tasks. To display Help topics about the main user tasks, follow these steps:
1 From the SAS Data Integration Studio menu bar, select Help ￿ Contents . The
Help window displays.
2 In the left pane of the Help window, select Task Overviews ￿ SAS Data
Integration Studio Task Reference .
3 See the section for user tasks.