Rolling measure type is used to show an average or total value of some measure in a certain time period. For example, you can create a measure that will show an average profit for the last three month. To do that, create a new calculated measure of “Rolling” type: In the next window fill in […]

“Period to Date” calculated measure type is used to show a total or average value of some existing measure from the beginning of some period to the current date. For example, if you need to draw a chart representing the growth of total sales amount during a year, you can create a calculated measure, showing […]

When users create their own measures, all of them are automatically placed to “My Calculations” folder: Users can create their own trees of folders, but all of them will be under “My Calculations”. Let us look at the example with measures that we’ve just created. In order to manage folders, click on any place in […]

You have the possibility to create your own dimension members, based on the existing ones. To add calculated members to some hierarchy you have to click with the right mouse button on that hierarchy in the hierarchies list. In the context menu select “Calculated Members…”: After that a window will appear for managing the calculated […]

You can create numerical parameters that allow the user to affect calculated measures, sets and members dynamically: To create a numeric parameter, right-click anywhere in the parameter list. A pop-up menu appears allowing you to add a parameter: By clicking on the “New Parameter …” menu item a wizard to create a numeric parameter appears: […]

Similarly to numeric parameters, it is possible to specify a description for the calculated measures and sets (of an arbitrary MDX type): After that, when pointing at a measure, you will see the following message:

Creating Gauges Export of Gauges

In order to create a gauge, it is necessary to click on the desired measure and select the visualization type as a gauge: There are the following types of gauges: The field “Goal” defines the measure which will be used as a target in data analysis. By default it is empty. If we don’t select […]

The gauges can be exported to NRP, PDF and Excel. While exporting to Excel the gauges are not exported: the cells of Excel table will contain the numbers instead of the gauges.

Apart from the pages of the table/chart form, you have the possibility to add to your report four more types of pages: Treemap Scatter-diagram, Map and Dashboard. Those three types of pages allow you to perform advanced visual data analysis. Let’s review those three types of pages in more details.