SAS/Warehouse Administrator Metadata Types

WHSUMTBL

Metadata type for summary tables

Category:

Object Types--Explorer

Parent
Overview
Properties
	Property Dependencies
Using WHSUMTBL

Parent

WHTABLE

Overview

WHSUMTBL models the metadata for summary tables in SAS/Warehouse Administrator. A summary table can be a SAS table or view or a DBMS table or view. Each summary table corresponds to one of these time dimensions: day, week, half-month, month, quarter, or year. To add a summary table with the SAS/Warehouse Administrator Explorer:

Select a summary group with the right mouse button.
Select Add Item summary table
Select the table with the right mouse button.
Select Properties.
Enter the summary table information.

Properties

The following table lists all of the properties for WHSUMTBL 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
Aggregation Level	C	No	No	No
Columns	L	No	No	Yes
Creating Job	L	No	No	No
Cvalue	C	No	No	No
Desc	C	No	No	No
Extended Attributes	L	No	No	Yes
Fiscal Day of Month	N	No	No	No
Fiscal Day of Week	C	No	No	No
Fiscal Month of Year	C	No	No	No
Fiscal Time of Day	N	No	No	No
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
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 WHSUMTBL are as follows:

AGGREGATION LEVEL: specifies the character string that indicates the aggregation level of this table: DAY, WEEK, MONTH, and so on.
FISCAL DAY OF MONTH: specifies the number that indicates the start day of the month of the fiscal year. Valid numbers are between 1 and 31.
FISCAL DAY OF WEEK: specifies the character string that contains the start day of the week of the fiscal year. Valid strings range from SUNDAY through SATURDAY.
FISCAL MONTH OF YEAR: specifies the number that indicates the start month of the year in which the fiscal year starts. Valid numbers range between 1 and 12.
FISCAL TIME OF DAY: specifies the SAS datetime character string for the start time of day of the fiscal year. (A character value that is formatted with a SAS DATETIME. format.)

Property Dependencies

You must define a CREATING JOB property in order to add any INPUT SOURCES to a table. If a table does not have a CREATING JOB property, then you must specify one when you add an input source to the table.

Using WHSUMTBL

Add	Update	Delete
No	No	No

WHSUMTBL is an independent type, like its parent, WHTABLE. To understand how all subtypes of WHTABLE relate to other types, see the models in Relationships Among Metadata Types.

Top of Page