DataLayer.MDX - Using MDX Query Elements
When working with an OLAP Table or OLAP Grid element, you can have the Logi Engine create the MDX query for you by using DataLayer.MDX and the MDX Query element.
The example above shows the datalayer with its MDX Query child element. The name of the target data cube must be provided, as shown.
Beneath the MDX Query element, you add child elements to define the dimensions, measures, and filters needed, as shown above. When the application runs, the Logi Engine will use these elements to create the appropriate query.
The available child elements, and their child elements, include:
| Element | Description |
|---|---|
| MDX Axis Dimension | Specifies adimension that will be shown in the OLAP Gridor OLAP Table, across the top or left side. You may have any number of MDX Axis Dimension elements for either axis. Generally, the OLAP Table requires these elements, becausethe user has no way to add them at runtime. However, since the OLAP Grid allows user selection of dimensions, MDX Axis Dimensions need only be specified for "default" dimensions. There must be at least one dimension defined for the left axis to see any results. You may specify a hierarchy in the Dimension Name attribute, e.g. [MyDimension].[MyHierarchy]. |
| Child: MDX Drill-Down | Specifies a single member of the dimension to be drilled/expanded.
You may add any number of MDX Drill-Down elements. Their Value attribute must be a member of the
parent element's dimension. Separate each level with the period
character, and when a member has spaces in the name, it must be enclosed in
brackets. Begin the Value with the dimension name, e.g.
[Customers].[All
Customers]. When there are multiple dimensions on a single axis, the members of each axis must be separated by the asterisk character. For example: [Customers].[All Customers].[USA].[CA]*[Education Level].[All Education Level].[Graduate Degree]*[Gender].[All Gender].[M] Specify a Value of AllMembers to expand all members of the dimension. |
| Child: MDX Drill-Up | Used tocollapse a dimension member that has been drilled-down. This may be used to undo drill-downs caused by settingMDX Drill-Down to AllMembers. |
| Child: MDX Find | When present, automatically drills down and filters to show all members that contain the specified Value. Available only when using the OLAP Grid element. |
| Child: MDX Member Property | Specifies a single member property that will be displayed with the appropriate member values. Each member property is listed in its own column to the right of the Dimension Members. The column only appears when there is at least one member that has the property. Add an MDX Member Property element for each property to be listed. At runtime, users can change the properties when the OLAP Grid element's Pick Member Properties attribute is True. Available only when using the OLAP Grid element. |
| MDX Calculated Measure | Adds an additional measure based on an MDX formula. MDX formulae basically
follow intrinsic functionsyntax and typically references other measures. For
example: VAL((Measures.[Store Sales] - Measures.[Store Cost]) / Measures.[Store Sales]) Add an MDX Measure element to display the calculated measure. |
| MDX Filter Dimension | Filters or slices values out of the OLAP cell set. Each dimension to be filtered should have an MDX Filter Dimension element. Dimensions cannot be used in both this elementand MDX Axis Dimension elements at the same time. |
| Child: MDX Filter Value | Specifies a single member to be included in, or excluded from, the cell calculations. You may have any number of MDX Filter Values for each dimension. The Value attribute must be a member of the MDX Filter Dimension element's dimension. Separate each level with the period character. When a member has spaces in the name, it must be enclosed in brackets. Example: [USA].[CA] |
| MDX Measure | Specifies a measure that will be shown in the OLAP Grid or OLAP Table cells. You may have any number of MDX Measure elements. If none of these elements are included, the cube's default measures will be shown. Cells are formatted according to the format specified in the cube definition. Localization is applied to these formats according to the browsers language setting. |
The data retrieved into the datalayer can be viewed by turning on the Debugging Link in the _Settings definition (General element) and using the resulting link at the bottom of the report page to view the Application Trace page. A link on the Trace page will display the retrieved data.