OLAP Query Details 
You can use the OLAP Query Details screen in the SAP Manufacturing Integration and Intelligence (SAP MII) Workbench to create a multidimensional expression (MDX) query through namespace browsing.
Prerequisites
You are familiar with MDX syntax.
Features
The following table lists parameters specific to OLAP queries:
Name on UI | Parameter | Data Type | Description |
Cubes | Cube | String | Specially designed database that is optimized for reporting |
Dimensions | Dimension | String | Variables by which measures are summarized (for example, hospitals, physicians, or dates of service) Organizing data in this way allows you to formulate data requests based on real-life situations. Many possible queries to the data are preaggregated in the database; the answers are precalculated and can be reported quickly. |
Measures | Measure | String | Represents items that are counted, summarized, or aggregated, such as costs or units of service |
SAP Variables | SAP Variable | String | Used when connecting to SAP NetWeaver Business Intelligence. For more information, see SAP Variables in the SAP NetWeaver Library. |
Show Null Values as Zero | NullAsZero | Boolean | Indicator for replacing null numeric values with zero. If you do not select this indicator, the system replaces nulls with the minimum value for the data type in the Java language. For example, the minimum value for a Double is 4.9e-324. |
Query | Query | String | MDX expression to be run; required for data retrieval. |
ColumnAlias.1 - ColumnAlias.128 | String | Parameters used as returned column names. |
See also: