SAS/Warehouse Administrator Metadata Types

WHOLAP

Base metadata type for OLAP dimension, hierarchy, and crossing

Category:

Object Types--OLAP

Parent
Overview
Properties
Using WHOLAP

Parent

WHROOT

Overview

WHOLAP is the base metadata type for OLAP dimensions, hierarchies, and crossings.

Properties

The following table lists all of the properties for WHOLAP 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.
Cvalue	C	No	No	No
Desc	C	No	No	No
Extended Attributes	L	No	No	Yes
Id	C	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 Groups	L	No	No	No
OLAP Members	L	No	No	Yes

New properties for WHOLAP are as follows:

OLAP GROUPS: specifies an SCL list of general identifying information about the OLAP groups to which this object belongs.
OLAP MEMBERS: specifies an SCL list of general identifying information about the members of an OLAP object.

Using WHOLAP

Add	Update	Delete
No	No	No

WHOLAP and its children are independent types.

Top of Page