SAS/Warehouse Administrator Metadata API- P60: 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. | 292 Glossary ODD group specifies a simple grouping element for ODDs. It might also contain InfoMarts. In the SAS Warehouse Administrator Explorer you can add an ODD group only to a warehouse environment. OLAP group online analytical processing group organizes related summary data which is stored in OLAP tables or OLAP MDDBs. The OLAP group properties specify the logical structure of the summarized data and how they relate to the detail data in a data warehouse. OLAP groups have a type attribute which you specify as ROLAP MOLAP HOLAP or MIXED. In the SAS Warehouse Administrator Explorer you can add an OLAP group only to a subject. OLAP MDDB indicates a metadata record that specifies a SAS MDDB. A SAS MDDB is not a SAS table. It is a specialized storage format that stores derived summary data in a multidimensional form which is a highly indexed and compressed format. To load an OLAP MDDB SAS Warehouse Administrator generates code for the MDDB procedure which summarizes data similar to the SUMMARY procedure. OLAP MDDBs are the only kind of data stores in an OLAP group of type MOLAP. You can include OLAP MDDBs in an OLAP group of type HOLAP or MIXED. Each MDDB in an OLAP group of type MOLAP must have an NWAY crossing that represents all of the data summarized to the lowest level and it must be named AWAY. The MDDB can also contain additional crossings. In the SAS Warehouse Administrator Explorer you can add an OLAP MDDB only to an OLAP group. OLAP table indicates a metadata record that specifies a file to store derived summary data. This file can be a SAS table or view or a DBMS table or view. An OLAP table can have multiple crossings. To load an OLAP table SAS Warehouse Administrator generates code for the SUMMARY procedure which summarizes data by computing descriptive statistics for columns across rows or within groups of rows. OLAP tables are the only kind of tables in an OLAP group of type ROLAP. You can include OLAP tables in an OLAP group of type HOLAP or MIXED.
