Preparing Data for Your Ready-Made Applications

Registering an MDDB

If you use the SAS/EIS MDDB object to create an MDDB, your MDDB is automatically registered in the repository when you click Create or when you execute the MDDB object. Any computed columns that were assigned to the base table registration that was used in creating the MDDB are automatically assigned to the MDDB registration.

If you use the MDDB procedure to create the MDDB, then you must register it in the repository. In the Metabase window, click Add under the Tables list box. Select the new MDDB and then click OK to close the window. The MDDB will be registered along with its displayed hierarchies, category columns, and analysis columns.

The MDDB registration takes the default column attribute values from the registration of the SAS table that was used to create the MDDB (the base table). The following table provides detailed information about how the MDDB registration affects specific column attributes.

Column attribute		Details
ANALYSIS		is updated with the statistics that were selected when the MDDB object was registered; used as the default for the MDDB viewers (such as the Multidimensional Report)
COLOR		is assigned to the MDDB registration, if it was specified in the base table registration.
COMPUTED		is assigned to the MDDB registration, if it was specified in the base table registration.
FONT		is assigned to the MDDB registration, if it was specified in the base table registration.
MDDBFMT		identifies the format with which the MDDB was created.
RANGE		is assigned to the MDDB registration if it was specified in the base table registration.
SORT		is not added to the registration if you select a sort order for the MDDB; SAS/EIS lets the viewer use any sorting that was applied to the MDDB when it was created.

The following table provides detailed information about how the MDDB registration affects specific table attributes.

Table attribute		Details
BASETABL		contains the base table that was used as input to the MDDB. If a subset was applied, the BASETABL attribute contains the name of the view that was created. If the BASETABL attribute is deleted, the "Show Detail" capability in the viewers will be disabled.
HIERARCH		contains all the hierarchies that were selected when the MDDB object was created and executed. This attribute is for external MDDBs that contain hierarchies that are specified with HIERARCH='Y' .
MAPINFO		is assigned to the MDDB registration, if this attribute exists in the base table, assuming that hierarchies used by the MAPINFO attribute exist in the HIERARCH table attribute.
MDDB		is assigned a value of INTERNAL, if the MDDB was registered via the MDDB object; the value of EXTERNAL indicates that the MDDB was created with PROC MDDB and was then registered in the repository. If you edit the MDDB table attribute within the metabase facility, information about the hierarchies and about the category/analysis columns is displayed.

Note: When you create an MDDB with the SAS/EIS MDDB object and specify a subset, a permanent view of the data is created with the subset applied. The view uses the same name as the MDDB. If you move the MDDB (to another library or host, for example), you must also move the view to the same location. If you do not move the view, you can still use the MDDB, but the "Show Detail" capability in the viewers will be disabled. [cautionend]

Top of Page