MDX Query Builder
MDX Document Object Model (MDX DOM), MDX Parser, MDX Generator
Ranet OLAP includes a query builder. We able to parse any MDX expression, including for dimensions hierarchy, formulas, crossjoin etc. MDX parser and generator build Document Object Model (DOM) for MDX expression, similar to Abstract Syntax Tree (AST). A Document Object Model (MDX DOM) is a model of how the various elements MDX expression are related to each other. A MDX query is built by constructing nodes of a tree. This MDX DOM approach for building a query is very effective.
MDX Query Builder can do the following in Analysis Services:
- Parse and validate an MDX expression/query and present it in an object hierarchy
- Conversely, create an MDX query / expression from object hierarchy
Software control generation of MDX queries allows to hide all the complexity of MDX from the users. This analysis also allows to find syntax errors in the MDX statement. The user can write MDX expression, on it will be formed the expression tree.
Further MDX query will be generated automatically using the navigation functions (Drill Down/Drill Up, Expand/Collapse ) in the summary table.