SAS/MDDB Server Administrator's Guide

Using the Multidimensional Data Provider

Using MDP in SAS/EIS Software

The Distributed Multidimensional Metadata utility enables you to create an EIS metabase registration from each Data Group. Use this facility to make your Data Groups known to SAS/EIS software. Add drill-path information to the metabase registration by adding the SAS/EIS HIERARCH table attribute. After this setup, you can use the registration just like any other SAS/EIS metabase registrations to build any of the following multidimensional EIS applications:

Application Screen Builder
3D Business Charts
Bubble Charts
Maps
Multidimensional Business Trends
Multidimensional Charts
Multidimensional Pie Charts
Multidimensional Reports
Organizational Charts.

Another way to use MDP with SAS/EIS software is to access a single remote MDDB from a SAS/EIS application by taking advantage of the MDP Remote Computing capabilities. MDP Remote Computing can have better performance than standard Remote Library Services processing for users with slow server connections or where the remote MDDB is not highly aggregated. Also, especially with large subtables, the MDP caching facility speeds up repeated access to data and reduces network traffic.

There is no need to define a Data Group and Server to use the MDP Remote Computing capabilities: simply add the COMPSRV attribute to the SAS/EIS metabase registration. Also, ensure that your remote connection is set up prior to running the SAS/EIS application, and define a libname on the remote session using the same name and path used in the metabase registration.

Using MDP with SAS/AF Software

You can retrieve data through MDP in an application developed with SAS/AF software and SAS Component Language (SCL). Remember that you must provide a model that tracks the dimensional and navigational information. Use SASHELP.MDDB.HOLAP_DP.CLASS for data retrieval through MDP.

Chapter Contents
Previous
Next
Top of Page