SAS/Warehouse Administrator Metadata API- P40: 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. | 192 WHOLPCUB Chapter 3 You can pass properties with a Yes in the Update column to the _UPDATE_METADATA_ method as described in the documentation for this method. Use this method to update properties of an existing object. For details see Using _UPDATE_METADATA_ on page 46. 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. Auto supplied means that the property is automatically supplied any value that you specify for such a property is ignored. 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 Indirect Add Update Method Read Method Expand Parm. Cvalue C Yes Yes No Desc C Yes Yes No Extended Attributes L Yes Yes Yes Id C Req No No Metadata Created C Auto supplied No No Metadata Updated C Auto supplied No No Name C Req Yes No Note L Yes No Yes NValue N Yes Yes No OLAP Groups L No No No OLAP Members L Yes Yes Yes OLAP Structure L Auto supplied No No WHOLPCUB has the following new property OLAP STRUCTURE specifies an SCL list of general identifying information about an OLAP group table or MDDB. Using WHOLPCUB Add Update Delete No Yes Yes WHOLPCUB is a dependent type like its parent WHOLAP. SAS Warehouse Administrator Metadata Types A WHOLPDIM 193 WHOLPDIM Metadata type for OLAP dimension Category Object Types OLAP Parent WHOLAP on page 188 Overview WHOLPDIM models the metadata for OLAP dimensions in OLAP tables groups and MDDBs. A dimension organizes related columns which are in hierarchies. For example you could organize sales data into three dimensions Geography Time and Product. The Time dimension could include these hierarchies which provide different paths in order to drill down to .
