MDX Designer Control | Ranet OLAP

MDX DESIGNER

Ranet OLAP MDX Designer control helps to create interactive reports based on Microsoft Analysis Services OLAP cube data. The reports can be simple or complex, depending on the user’s skills.

MDX Designer allows viewing cube metadata and creating an MDX query by dragging and dropping cube metadata description elements to the filter areas, columns, rows, and data. One can use cube dimensions, levels, hierarchies, and cube measures when creating an MDX query. The cube metadata used for the query is shown in bold.

It is possible to copy settings across areas and group settings in certain order, thus forming CrossJoins for rows and columns and embedded cubes.

The MDX Designer has the following areas:

  • Toolbar
  • Report Designer Area
  • MDX Query Area
  • Pivot Grid Area, summary table showing the result of the query

MDX Designer areas.

Report Designer Area

Report designer area helps the user to build an interactive report by dragging and dropping cube metadata description elements to the filter areas, rows, and columns of the summary table.

Any dimensions, dimension hierarchies, hierarchy levels, and cube measures can be used in the report. In this case, they are highlighted with bold font in the metadata description. The user can setup a filter for a group of measures for metadata descriptions, in order to limit the cube area used for designing the report.

The dimension hierarchies included in the rows and columns area form a cross product of their members. The Crossjoin function of the MDX language is used for this. In so doing, it is possible to limit the list of hierarchy dimension elements by setting up filters. The sequence of corteges in the resulting set will determine the order of dimension hierarchies.

The commands shown in the table below are user for detailed setup of reports and MDX queries.

CommandDescription
Move upMoves the dimension to a higher level in the cortege
Move downMoves the dimension to a lover level in the cortege
Remove FieldRemoves the dimension from the report configuration and the MDX query configuration
Change FilterCalls a filters setup dialog allowing to modify the filter where a list of elements included in the report is determined

Toolbar

The toolbar is MDX Designer area that is used to control the dynamic summary table. The toolbar includes commands that control the report generation rules and MDX query generation rules.

CommandDescription
Show/Hide query designerShows or hides MDX query designer area
Show/Hide MDX queryShows or hides MDX query area
Edit MDX queryAllows manual editing of the query
Generate MDXGenerates an MDX query based on the current settings determined in the designer. A manually edited query will be lost
Customer Calculation EditorInvokes a customer calculation editor dialog
Run MDX query automaticAutomatically runs the MDX query after each user’s change in the designer
Execute MDX queryRuns the current MDX query and shows the result
Import query layout settingImports query settings from an XML file
Export query layout settingExports the query settings to an XML file

By default, a change of the settings in the designer would automatically change the MDX query and generate a report based on the query.

MDX Query Area

MDX query area is designed for viewing and editing the MDX query. The query is generated automatically after changing the settings in the designer. If the user has sufficient skills, they can modify the MDX manually and use all capabilities of the MDX query language in order to achieve the most efficient solution. It is possible to save the edited query in order to invoke it later.

Pivot Grid Area

Description of the Pivot Grid Area is given in the Pivot Grid section.