SAS/Warehouse Administrator Metadata Types

WHSUMDDB

Metadata type for SAS Summary MDDBs

Category:

Object Types--Explorer

Parent
Overview
Properties
Using WHSUMDDB

Parent

WHOBJECT

Overview

WHSUMDDB models the metadata for a SAS Multidimensional Database summary in SAS/Warehouse Administrator. A SAS MDDB is a SAS table that stores data in presummarized format and in more than two dimensions; that is, it stores more than the usual down and across columns in a standard table. For example, where a summary table might show sales in dollars for a given company by month, an MDDB could show sales in dollars for a given company by month, region, and product.

To add an MDDB with the SAS/Warehouse Administrator Explorer:

Select a summary group with the right mouse button.
Select Add Item Summary MDDB
Select the MDDB with the right mouse button.
Select Properties.
Enter the MDDB information.

Properties

The following table lists all of the properties for WHSUMDDB and indicates how you can use each property with metadata API methods.

In the table, you can pass properties with a Yes in the Add column to the _ADD_METADATA_ method. Use this method to add a new object.

You can pass properties with a Yes in the Update column to the _UPDATE_METADATA_ method. Use this method to update properties of an existing object.

* Req indicates that the property is required; you must provide a value for this property when you use a given method. * Default indicates that the system will provide a default value for that property if you do not provide one.

Properties with a Yes in the Read Method Expand Parm column are valid with the expand parameter of the _GET_METADATA_ method. This method enables you to get detailed metadata about a property and its associated objects through a single method call.

Properties	Type	Add Method	Update Method	Read Method Expand Parm.
Administrator	L	No	No	No
Columns	L	No	No	Yes
Cvalue	C	No	No	No
Creating Job	L	No	No	Yes
Desc	C	No	No	No
Extended Attributes	L	No	No	Yes
Fiscal Day of Month	N	No	No	No
Fiscal Day of Week	C	No	No	No
Fiscal Month of Year	C	No	No	No
Fiscal Time of Day	N	No	No	No
Group	L	No	No	No
Host	L	No	No	No
Icon	C	No	No	No
Id	C	No	No	No
Input Objects	L	No	No	No
Input Sources	L	No	No	No
Library	L	No	No	No
Members	L	No	No	No
Metadata Created	C	No	No	No
Metadata Updated	C	No	No	No
Name	C	No	No	No
Note	L	No	No	Yes
NValue	N	No	No	No
Output Objects	L	No	No	No
Output Targets	L	No	No	No
Owner	L	No	No	No
Process	L	No	No	Yes
Table Name	C	No	No	No
Using Processes	L	No	No	No

New properties for WHSUMDDB are as follows:

COLUMNS: specifies an SCL list of general identifying information about the columns in this MDDB.
CREATING JOB: specifies a list of general identifying information about the job that creates this summary MDDB.
FISCAL DAY OF MONTH: specifies the number that indicates the start day of the month of the fiscal year. Valid numbers are between 1 and 31.
FISCAL DAY OF WEEK: indicates the character string that contains the start day of the week of the fiscal year. Valid strings range from SUNDAY through SATURDAY.
FISCAL MONTH OF YEAR: specifies the number that indicates the start month of the year in which the fiscal year begins. Valid numbers range between 1 and 12.
FISCAL TIME OF DAY: indicates the character string for the start time of day of the fiscal year.
HOST: specifies an SCL list of general identifying information about the host on which this MDDB is accessed.
INPUT OBJECTS: specifies an SCL list of general identifying information about the objects that are input to this MDDB. For more information about input objects, see INPUT and OUTPUT Properties.
INPUT SOURCES: specifies an SCL list of general identifying information about the sources that are input to this MDDB. For more information about input sources, see INPUT and OUTPUT Properties.
LIBRARY: specifies an SCL list of general identifying information about the SAS Library (WHLIBRY type) that contains this MDDB.
OUTPUT OBJECTS: specifies an SCL list of general identifying information about the objects that are output from this MDDB. For more information about output objects, see INPUT and OUTPUT Properties.
OUTPUT TARGETS: specifies an SCL list of general identifying information about the targets that are output to this MDDB. For more information about output targets, see INPUT and OUTPUT Properties.
PROCESS: specifies an SCL list of general identifying information about the process that created this MDDB.
TABLE NAME: indicates the character string that contains the table name that is associated with this MDDB.

Using WHSUMDDB

Add	Update	Delete
No	No	No

WHSUMDDB is an independent type, like its parent, WHOBJECT. To understand how all subtypes of WHOBJECT relate to other types, see the general information model in Relationships Among Metadata Types.

Top of Page