Home > @activeviam/activeui-sdk > MdxOrderApi
MdxOrderApi interface
Contains the methods to read or change the ordering in a statement.
Signature:
export interface MdxOrderApi
Properties
| Property | Type | Description |
|---|---|---|
| getAxisOrder | (parsedSelectStatement: SelectStatementNode, axisName: AxisName) => undefined | { expression: ExpressionNode; mode: OrderModeLiteralNode; } | |
| getOrderingLevelFromFormula | (orderingFormula: FormulaNode, cubeDiscovery: CubeDiscovery) => LevelName | undefined | |
| getOrderNode | (node: MdxNode) => OrderFunctionNode | null | |
| order | (node: ExpressionNode, orderingExpression: ExpressionNode, orderMode: OrderModeLiteralNode) => ExpressionNode | |
| orderAxis | (parsedSelectStatement: SelectNode, axisName: AxisName, orderingExpression: string, orderMode: OrderMode) => SelectNode | |
| removeOrder | (parsedSelectStatement: SelectNode, axisName: AxisName) => SelectNode |
Remarks
Ordering in MDX is controlled using the [Order function](https://docs.microsoft.com/en-us/sql/mdx/order-mdx).