SAS Enterprise
Guide provides a dedicated, intuitive and advanced interface is provided
for analyzing business information stored in OLAP data cubes. SAS
Enterprise Guide is an ODBO-compliant OLAP Viewer. When accessing
OLAP cubes via ODBO, the SAS OLAP Server acts as an Open OLAP Provider,
and SAS Enterprise Guide is an Open OLAP Consumer. SAS Enterprise
Guide features drillable, interactive graphics and enables users to
generate ad hoc queries for analytics based on cube data.
The OLAP Analyzer supports
all of the functionality required to navigate through multidimensional
data, add topic-specific business calculations, and extract information
from multidimensional sources for further analysis with advanced statistical
procedures or data mining. With the OLAP Analyzer and SAS Enterprise
Guide, you can do the following:
-
access SAS OLAP cubes directly
from the metadata definition. You can preview each cube's dimensions,
measure its contents, and override the default view before accessing
the cube.
-
slice and dice data as needed to
explore the information, as well as drill-through to underlying detailed
data.
SAS Enterprise Guide
provides the following features for OLAP cube access, visualization
and manipulation:
-
support for drilling, slicing and
pivoting in a cube to explore the cube data. You can also drill-through
to the underlying detailed data for a cube. With drill-through capability,
you can navigate in your data from the most summarized levels to
the most detailed levels. You can drill down on all members of a level
or drill down on a specific member of the level. You can also drill
in the graph view.
-
calculation (calculated member
or measure) support, including simple calculations, count analysis,
relative contribution analysis and custom calculations (such as time
series analysis).
-
support for filtering that is based
on a ranking function or on a range of values. You can now filter
by member caption and member property. You can also create filters
that can be used by multiple queries.
-
support for totals, subtotals,
and percent of totals calculations.
-
multiple, independent views of
a cube. Specific views on multidimensional information can be saved
as bookmarks for easy reuse.
-
surfacing of multidimensional information
slices to other analytical SAS procedures for advanced analysis,
including use in data mining procedures.
-
surfacing of SAS OLAP data sources
from the SAS OLAP Server or other third-party vendors supporting OLE
DB for OLAP (for example, SAP BW and Microsoft Analysis Services).
For further information
about SAS Enterprise Guide, see the Help for SAS Enterprise Guide.