MakeQuery()
Use MakeQuery() to build a query expression string for use in MDX.
If you want to use queries in your MDX, you can use MakeAxis() to build a query expression that can be used in MDX. MakeQuery() takes an input of strings and assembles the output as an axis expression.
Syntax
MakeQuery(<defines>, <axis 1>, <axis 2>, <cube>, <slicers>, <cell properties>)|
Argument |
Description |
Required/Optional |
|---|---|---|
|
Defines |
Required | |
| Axis 1 |
The first axis expression string that you want to use to build a query expression string. |
Optional |
| Axis 2 |
The second axis expression string that you want to use to build a query expression string. |
Optional |
| Cube |
The cube that you want to want to use to build a query expression string. |
Required |
| Slicers |
The slicers that you want to want to use to build a query expression string. |
Optional |
| Cell properties |
The cell properties that you want to want to use to build a query expression string. |
Optional |