MO_FILTERS | Contains information about metaoutline filters. This information includes the filter name and the actions the filter will perform. |
MO_INFO | Contains high-level information about a metaoutline: the name of the metaoutline, its description, the date it was last changed, the OLAP model on which the metaoutline is based, its owner, its access privileges, and whether the spreadsheet user of Drill-Through reports must enter the Integration Server name and a user name and password for the external data source. |
MO_PROPERTIES | Contains information about metaoutline properties. This information includes the name and value of metaoutline properties, the name of the source table and column that Integration Services uses to assign the properties, the numeric range that represents a range specified by the user, Global Settings properties, and sort order. Sort order is based on a column in the data source, including columns not present in the OLAP model or metaoutline. Sort order can be ascending or descending. Also contains information on association of attributes (by level or by name) to base dimensions. |
MOD_ATTRIBUTES | Contains information about attribute dimensions, such as attribute dimension type, alias names, and transformation rules. |
MOD_INFO | Contains information about dimensions in a metaoutline. This information includes the dimension name, the OLAP dimension with which it is associated (unless it is a user-defined dimension), the type of dimension (a user-defined dimension, a measures dimension, a standard dimension, or an attribute dimension), and how members are positioned within the dimension. |
MS_INFO | Contains information about members in a metaoutline. This information includes the name of the member, the dimension to which it belongs, whether it is a user-defined member or a standard member, the OLAP table with which it is associated, the OLAP model column with which it is associated, the name of its parent, how it is positioned with its siblings, and the database measure with which it is associated (if it is a user-defined member). |
MS_PREDICATES | Contains information about members in a metaoutline. This information includes member filters. |
MS_TX_RULE | Contains information about members in a metaoutline. This information includes member transformation rules. |
MSR_INFO | Contains information about database measures in a metaoutline. This information includes the name of the measure, the OLAP model table with which it is associated, the OLAP model column with which it is associated, and how it is positioned with its siblings. |
MSR_PREDICATES | Contains information about database measures in a metaoutline. This information includes measure filters. |
MSR_TX_RULE | Contains information about database measures in a metaoutline. This information includes the name and definition of measure transformation rules. |
MO_DESCRIPTIONS | Contains descriptions for a metaoutline, its filters, its dimensions, and its members. This information includes the system-generated ID number for each metaoutline, filter, dimension, or member that is described. |