SAS/Warehouse Administrator 2.3 Metadata API- P52

SAS/Warehouse Administrator Metadata API- P52: The operating system and SAS version that are associated with a given host are now available through the WHHOST property. For example, you can write a SAS/Warehouse Administrator add-in that reads the host metadata that is associated with a given data store and then uses these values to generate code that is appropriate for the operating system and SAS version. | 252 WHSUMTBL A Chapter 3 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 1 Select a summary group with the right mouse button. 2 Select Add Item summary table 3 Select the table with the right mouse button. 4 Select Properties. 5 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 SAS Warehouse Administrator Metadata Types A WHSUMTBL 253 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 .