SAS/Warehouse Administrator Metadata Types

WHOLPSTC

Base metadata type for OLAP tables, groups, and MDDBs

Category:

Object Types--Explorer

Parent
Overview
Properties
Using WHOLPSTC

Parent

WHTABLE

Overview

WHOLPSTC is the base metadata type for OLAP tables, groups, and MDDBs.

Properties

The following table lists all of the properties for WHOLPSTC 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.
Access Same As Physical	N	No	No	No
Administrator	L	No	No	No
Columns	L	No	No	Yes
Creating Job	L	No	No	No
Crossings	L	No	No	Yes
Cube	L	No	No	Yes
Cvalue	C	No	No	No
Desc	C	No	No	No
Extended Attributes	L	No	No	Yes
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
OLAP Type	C	No	No	No
Output Objects	L	No	No	No
Output Targets	L	No	No	No
Owner	L	No	No	No
Physical Storage	L	No	No	Yes
Process	L	No	No	Yes
Table Name	C	No	No	No
Using Jobs	L	No	No	No

New properties for WHOLPSTC 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.
CUBE: specifies an SCL list of general identifying information about the cube that is associated with an OLAP table, group, or MDDB.
OLAP Type: specifies the character string that contains the type of OLAP configuration that is being created. The valid value for OLAP table is DATA. The valid value for OLAP MDDB is MDDB. The valid values for OLAP group are HOLAP, ROLAP, MOLAP, and MIXED.

Using WHOLPSTC

Add	Update	Delete
No	No	No

WHOLPSTC and its children are independent types.

Top of Page