SAS/Warehouse Administrator Metadata Types

WHCOLOLP

Metadata type for OLAP columns

Category:

Column Types

Parent
Overview
Properties
Using WHCOLOLP

Parent

WHCOLUMN

Overview

WHCOLOLP replaces the WHCOLSUM metadata type from Release 1.3. WHCOLOLP models the metadata for OLAP tables, Groups, and MDDBs in the SAS/Warehouse Administrator.

Properties

The following table lists all of the properties for WHCOLOLP 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.
Crossings	L	No	No	Yes
Cvalue	C	No	Yes	No
Desc	C	No	Yes	No
Extended Attributes	L	No	Yes	Yes
Hierarchies	L	No	No	No
Format	C	No	Yes	No
Id	C	No	* Req	No
Indexes	L	No	No	No
Informat	C	No	Yes	No
Input Objects	L	No	No	No
Input Sources	L	No	No	No
Length	N	No	Yes	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
Output Objects	L	No	No	No
Output Targets	L	No	No	No
Statistic	C	No	Yes	No
Sort Order	C	No	Yes	No
Summary Role	C	No	Yes	No
Table	L	No	No	No
Type	C	No	Yes	No

New properties for WHCOLOLP are as follows:

CROSSINGS: specifies an SCL list of general identifying information about the crossings that are associated with an OLAP group, Table, or MDDB.
HIERARCHIES: specifies an SCL list of general information about the hierarchies that are associated with an OLAP group, Table, or MDDB.
SORT ORDER: specifies a character string that contains the sort order of the column. Valid values are ASCENDING, DESCENDING, ASCFORMATTED, DESFORMATTED, and DSORDER.
STATISTIC: specifies a character string that contains the name of the statistic used to compute this statistic column.
SUMMARY ROLE: specifies a character string that contains the role of the column in the summary data. Valid values are CLASS, STATISTIC, ID, and _TYPE_.

Using WHCOLOLP

Add	Update	Delete
No	Yes	Yes

WHCOLOLP is a dependent type, like its parent, WHCOLUMN. To understand how all the subtypes of WHCOLOLP relate to other types, see the OLAP Metadata Type Model in Relationships Among Metadata Types.

Top of Page