Exploiting Warehouse Metadata

Example: Exporting Metadata to SAS/EIS Software

This example illustrates how to export SAS/Warehouse Administrator metadata to SAS/EIS software. The example exports metadata for an OLAP MDDB, which automatically registers the file in the SAS/EIS repository.

You can export metadata for SAS/Warehouse Administrator groups and data stores. For example, you can export the metadata for a Data Table used as a lookup table, you can export an OLAP data store to use in an OLAP application, and you can export an OLAP Group of type HOLAP.

Note: The following explanations assume that the OLAP Group and OLAP MDDB exist. For instructions about creating the OLAP objects, see Example: Creating Summary Data for a MOLAP Application. The example also assumes that SAS/EIS has been previously invoked so that the default repository is available. That is, the first time you invoke SAS/EIS, a default repository is automatically created under the SASUSER library. (A repository is a library managed by the Common Metadata Repository (CMR) that contains information about data tables and columns. A repository does not contain the actual tables; instead, it contains data about the tables.) [cautionend]

Exporting Metadata from SAS/Warehouse Administrator

In the SAS/Warehouse Administrator Explorer, position the cursor on the data store for which you want to export metadata. This example exports an OLAP MDDB that is grouped in an OLAP Group of type MOLAP. Even though you cannot export an OLAP Group of type MOLAP or ROLAP, exporting from the group lets you export multiple objects if appropriate. Therefore, for this example, select the OLAP Group MOLAP Group.

[untitled graphic]

Click the right mouse button, and select Export Metadata. The Export Format Selection window displays:

[untitled graphic]

In the Export Format Selection window, select SAS/EIS Metabase as the export format, and then click OK. The Export Metadata to SAS/EIS window displays:

[untitled graphic]

Under Available Tables, select the OLAP MDDB Sum 12 OLAP MDDB, and select the right arrow to move it to Selected Tables.

[untitled graphic]

Click OK.

The metadata for the OLAP MDDB is exported from SAS/Warehouse Administrator and automatically registered in the default repository for SAS/EIS. When the export is complete, you will receive a confirmation message to which you click OK.

Note: When you export metadata for an OLAP Group of type HOLAP to SAS/EIS, in addition to automatically registering the metadata in a repository, distributed multidimensional metadata is also automatically registered. That is, you do not need to issue the MDMDDB command in SAS/EIS to register the definition. [cautionend]

Accessing Metadata in SAS/EIS Software

To access the exported and registered metadata, first invoke SAS/EIS software, which displays the EIS Main Menu:

[untitled graphic]

Double-click the Metabase icon, which opens the Metabase window. The window displays the active repository, which for this example is the default repository SASUSER, and then lists the registered files.

[untitled graphic]

You can view the OLAP MDDB by selecting the table, then clicking View:

[untitled graphic]

Top of Page