SAS/Warehouse Administrator Metadata Types

WHDW

Metadata type for data warehouses

Category:

Object Types--Explorer

Parent
Overview
Properties
Using WHDW

Parent

WHOBJECT

Overview

WHDW models the metadata for data warehouses in SAS/Warehouse Administrator. A warehouse is a grouping element for subjects and data groups. It is the object that is used to implement a data warehouse or a data mart. In the SAS/Warehouse Administrator Explorer, to add a data warehouse to an environment:

Select the environment with the right mouse button.
Select Add Item Data Warehouse
Select the data warehouse with the right mouse button.
Enter the warehouse information.

Properties

The following table lists all of the properties for WHDW 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	Yes	No
Cvalue	C	No	Yes	No
Desc	C	No	Yes	No
Extended Attributes	L	No	Yes	Yes
Group	L	No	Yes	No
Icon	C	No	Yes	No
Id	C	No	* Req	No
Job Info Library	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	* Default	No
Note	L	No	Yes	Yes
NValue	N	No	Yes	No
Owner	L	No	Yes	No
Process Groups	L	No	No	No
Process Members	L	No	No	No

New properties for WHDW are as follows:

JOB INFO LIBRARY: specifies an SCL list of general identifying information about the job information library that is associated with this repository. The job information library is the location where job status information is stored for scheduled jobs.
LIBRARY: specifies an SCL list of general identifying information about the SAS library that contains the metadata for this data warehouse. See the metadata type WHLIBRY for the format of this list.
PROCESS GROUPS: specifies an SCL list of general identifying information about the process groups to which this object belongs.
PROCESS MEMBERS: specifies an SCL list of general identifying information about the process members that belong to this object. The list must be of type WHGRPJOB, WHJOB, WHEVENT.

Using WHDW

Add	Update	Delete
No	Yes	No

WHDW is used with the _SET_SECONDARY_REPOSITORY_ method to access the metadata for a particular data warehouse. To set a secondary repository, you must pass one of these two properties in the l_meta list for the _SET_SECONDARY_REPOSITORY_ method:

ID: represents the metadata identifier of the secondary repository.
LIBRARY: allows the stored metadata information to be overridden with the optional information that is specified here.

For details, see _SET_SECONDARY_REPOSITORY_.

WHDW is an independent type, like all subtypes of 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