MDX Designer. Customer Calculation Editor
A built-in Customer Calculations Editor permits the user to create calculated elements and calculated sets on his own. When creating customer calculations elements, the user can use all capabilities offered by the MDX query language (for example, MDX language functions). Creating customer calculation sets can simplify the report design significantly, as customer calculation sets can take into account special features of the report (it can be complex filters or data selection algorithms). It is possible to save the settings and use them later when designing the report.
One can use the following formats for the calculated indicators: formats of the shown indicator values, background colors, text colors, etc. There are special selection forms that make the selection of values easy.
The query script describing the calculated indicator is generated automatically (the Script View tab).
The created customer calculation elements are immediately accessible in the cube metadata tree. They are stored in the [Calculations] folder. One can use them as well as ordinary cube metadata when designing the report.
Customer calculation designer
If a property value is set manually, then it must not be determined using a selection form. Otherwise it would be duplicated, resulting in an incorrect query script. In the example shown in the figure, property value BACK_COLOR is set manually for the calculation element, that is why the form property [Background Color] has value <None>.
A table with a customer calculation element
Figure: A table with a customer calculation element
The MDX query changes automatically after a change of the settings.
The generated MDX query can be edited manually, if necessary.
MDX Query with Calculation Members
After the changes have been made in the designer areas, it is possible to save the MDX query design results as a named pattern for loading later.
The results of the MDX query design can be shown using the PivotGrid control.