The SAS OLAP Cube Studio
GIS Map function enables you to store ESRI Geographic Information
System (GIS) spatial map information in the SAS metadata. This GIS
information can then be read by the SAS OLAP Server and returned during
a cube query.
When building or editing
a cube, the GIS Map function enables you to identify a geography-based
dimension and then assign ESRI spatial map information to that dimension.
To define GIS information for a SAS OLAP cube, you identify a dimension
as a geographic-type dimension (GEO) in the
Dimension
Designer – General window. You can have only one
GEO dimension per cube. After a dimension has been marked as a GEO-type
dimension, the
GIS Map button becomes active
on the Cube Designer – Dimensions page.
The
GIS
Map dialog box enables you to assign ESRI spatial map
information to levels of the GEO-type dimension. You can add map information
to an existing cube, modify map information for a cube, or delete
the map information from a cube. When ESRI map information is added
to a cube, the property objects for the mapped cube levels are listed
in the Cube Designer's
Member Property window.
From here you can modify the format, caption, and description for
the member property. These member properties are named SAS_SPATIAL_ID
by default.
You can set up the ESRI
ArcGIS server information in the metadata by using the Map Service
Manager plug-in in SAS Management Console. Users can access the functionality
through the SAS Web OLAP Viewer.
Note: If a dimension is changed
from type GEO to STANDARD or TIME, all the map information is removed.
For further information
about the
GIS Map window, see the SAS OLAP
Cube Studio Help topic “GIS Maps.” For information about
the ESRI Map Component, see the “Configuring the ESRI Map Component”
chapter in the
SAS Intelligence Platform: Web Application
Administration Guide.