Building Cubes and Administering Cubes

Specifying GIS Map Information for a Dimension

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. [cautionend]

For further information on the GIS Map window, see the SAS OLAP Cube Studio Help topic "GIS Maps". For information on the ESRI Map Component, see the "Configuring the ESRI Map Component" chapter in the SAS Intelligence Platform: Web Application Administration Guide

Specifying a GEO Type Dimension in PROC OLAP

If you create a cube with the OLAP proceedure, you can define a cube dimension as a GEO type. The TYPE= option, on the DIMENSION statement, enables you to identify a dimension as a GEO type dimension. This can only be used when you initially create a cube with the OLAP proceedure. In order to add geographic information to an existing cube, you must use SAS OLAP Cube Studio. For more details, see the TYPE= option.

Top of Page