416.467.9100 | Dundas Data Visualization | Login
Welcome Guest
This is the support page for the legacy Dundas Dashboard application. For assistance with the current Dundas BI application please click here.
Dashboard v5.0

This site makes extensive use of JavaScript.

Please enable JavaScript in your web browser and reload the page before proceeding.

Virtual Cube Designer - Calculations

Hide navigation
RSS
Modified on Thu, 09 May 2013 05:23 PM Categorized as OLAP, Virtual Cubes
Click to return to: Documentation | Defining Virtual Cubes


Overview

Use the Calculations tab of the Virtual Cube Designer to define one or more calculated members, which are based on measures from your source cube and/or existing calculated members.

Once defined, a calculated member appears in the cube tree (&ie; treeview) when you go to build a report, and can be used just like existing measures from the source cube.

The Calculations tab of the Virtual Cube Designer.

The Calculations tab of the Virtual Cube Designer.


Note: In order to define calculated members for a virtual cube, your SSAS instance must support and have enabled default properties for calculated members. This includes properties such as Caption and Associated Measure Group.

Adding a calculated member

The following example shows how to create a calculated member that computes the sum of the Internet Sales Amount and Reseller Sales Amount measures from the AdventureWorks (DW Standard Edition) cube:

  1. In the Calculations tab, click the New Calculated Member button. The Editing Calculated Measure dialog is displayed.
    Click New Calculated Member button.
  2. In the Editing Calculated Measure dialog, enter a name for your calculated member in the Name box. Enclose the name in square brackets if it contains spaces.
  3. Enter the MDX expression that computes the calculated member. For example:
    [Measures].[Internet Sales Amount] + [Measures].[Reseller Sales Amount]
  4. Choose a Format string for formatting the display of the calculated member values. For example, if your calculated member involves sales figures, use Currency as a format string.
  5. In the Non-empty behavior list, you can check one or more listed measures in order to resolve non-empty queries in MDX. Specifically, the calculated member will be treated as being empty if all of the checked measures are empty.
  6. (Optional) Enter the name of a display folder which will be used to parent the calculated member in the cube tree.
  7. Set the Solve order, which is an index that determines the order of the calculations when you have more than one calculated member.
    Editing Calculated Measure dialog.
  8. Click OK. The Editing Calculated Measure dialog closes and the new calculated member appears in the grid in the Calculations tab.
    A calculated member is added to the grid.
  9. Click Save in the toolbar to save your virtual cube definition.

Edit a report from this virtual cube to see your new calculated member in the cube tree.

A new calculated member.

A new calculated member.


Related topics


Click to return to: Documentation | Defining Virtual Cubes

About Dundas | Contact Us Follow us on Twitter! | Privacy Statement | Report Site Issues

Copyright © 2009-2014 Dundas Data Visualization, Inc.