SAS/Warehouse Administrator Metadata Types

WHGRPSUM

Metadata type for summary groups

Category:

Object Types--Explorer

Parent
Overview
Properties
Using WHGRPSUM

Parent

WHOBJECT

Overview

WHGRPSUM models the metadata for summary groups in SAS/Warehouse Administrator. A summary group is a grouping element for summary tables or MDDBs. Each table or MDDB in the group uses the summary group's assignments for input data source, column roles, and fiscal time. A summary group also defines the default class variables and analysis variables that are used when you build the dimensions for each summary level within the group. To add a summary group with the SAS/Warehouse Administrator Explorer:

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

Properties

The following table lists all of the properties for WHGRPSUM 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
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
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
Owner	L	No	No	No

Using WHGRPSUM

Add	Update	Delete
No	No	No

WHGRPSUM 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