MB_FILTER | Contains information about filters in the OLAP model. This information includes the hierarchy filter and system-generated ID numbers for parts of the OLAP model. |
MB_TX_RULE | Contains information about hierarchies in the OLAP model. This information includes transformations to perform on the hierarchy and system-generated ID numbers for parts of the OLAP model. |
OA_INFO | Contains information about columns in a dimension table or a fact table. This information includes the column name, the column data type, the OLAP model it belongs to, the dimension or fact table it belongs to, the source table and column on which it is based, whether it is hidden in OLAP models and metaoutlines, whether it is used for Drill-Through, whether it is enabled for attributes, and how to create it if it is a user-defined column. |
OD_DETAILS | Contains information about dimensions in the OLAP model. This information includes system-generated ID numbers for parts of the OLAP model. |
OD_INFO | Contains information about dimensions in the OLAP model. This information includes the dimension name, the OLAP model the dimension belongs to, and whether the dimension is a measures dimension. |
OM_INFO | Contains high-level information about an OLAP model: the name of the OLAP model, the description, the name of the data source on which the OLAP model is based, the owner, and access privileges. |
OM_PROPERTIES | Contains property information for the OLAP model. |
OMB_DETAILS | Contains information about hierarchies in the OLAP model. This information includes the position of each column in the hierarchy, the order in which to build the hierarchy, and system-generated ID numbers for parts of the OLAP model. |
OMB_INFO | Contains information about hierarchies in the OLAP model. This information includes the hierarchy name, the OLAP model that it belongs to, and the dimension to which it belongs. |
OV_INFO | Contains information about the dimension tables and the fact table in an OLAP model. This information includes the dimension or fact table name, the OLAP model it belongs to, its position in the right frame of the OLAP Model main window, and whether it is a dimension table or a fact table. |
OVL_REL_DETAILS | Contains information about logical joins between dimension tables and fact tables. This information includes the name of the first column and the name of the column to which the first column is joined. |
OVL_REL_INFO | Contains information about logical joins between dimension tables and fact tables. This information includes the name of the first dimension or fact table and the name of the dimension or fact table to which the first dimension is joined. |
OVP_REL_DETAILS | Contains information about physical joins in the source tables. This information includes the name of the first source column and the name of the source column to which the first source column is joined. |
OVP_REL_INFO | Contains information about physical joins in the source tables. This information includes the name of the first source table and the name of the source table to which the first source table is joined. |
OM_DESCRIPTIONS | Contains descriptions for a model, its dimensions, its members, and its hierarchies. This information includes the system-generated ID number for each model, dimension, member, or hierarchy that is described. |
JOIN_HINTS | Contains information about the database hints defined for a join. This information includes the type of join, the physical table to join, and the text of the join hint. |