SAS OLAP Cube
Studio is used to build, edit, and tune OLAP cubes. To build a cube,
the application generates metadata and a SAS program. It then submits
the program for execution on a SAS Workspace Server. The SAS Workspace
Server builds the cube and stores the result in a physical location
that can be accessed by a SAS OLAP Server.
When a cube becomes
available on a SAS OLAP Server, it is queried by users working with
OLAP clients. These clients can include SAS Web Report Studio, SAS
Web OLAP Viewer, and SAS Enterprise Guide. The cube viewers submit
queries to the SAS OLAP Server in the industry-standard MDX query
language. The SAS OLAP Server responds to queries by delivering result
sets to the cube viewers for display.
To configure your enterprise
for SAS OLAP Cube Studio, perform the following tasks:
-
Install and register SAS OLAP Servers
and SAS Workspace Servers.
-
Create libraries for cubes and
cube data.
-
Set up users, groups, and roles
for OLAP cube builds, updates, and queries.
-
Use the OLAP Server Monitor and
Server Manager plug-ins in SAS Management Console to monitor, control,
and tune SAS OLAP Servers.