416.467.9100 | Dundas Data Visualization | Login
Welcome Guest
Dashboard v5.0

This site makes extensive use of JavaScript.

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

Creating a Virtual Cube

Hide navigation
RSS
Modified on Sun, 15 Jul 2012 04:30 PM Categorized as Data Preparation, OLAP, Virtual Cubes
Click to return to: Documentation | Defining Virtual Cubes


Overview

This article shows how to create a virtual cube in Dundas Dashboard.

Creating a virtual cube from the Home Screen

From the Dundas Dashboard Home Screen, you can create a virtual cube by clicking Create a Virtual Data Structure and choosing the Virtual Cube option. In this case, the name of the virtual cube will be determined automatically. You can rename the virtual cube from the Design Explorer at a later time.

The Home Screen.

The Home Screen.


Tip: You can also create a virtual cube by selecting the Analytical Dashboard type and choosing the Create a Virtual Cube option.

Creating a virtual cube from the Design Explorer

When you create a virtual cube from the Design Explorer, you have the option of choosing a name for your virtual cube and also choosing its destination. For example, if you have a sub-folder in the Design Explorer called My Virtual Cubes, you can choose to create a new virtual cube in that location instead of the top-level Virtual Cubes folder.

To create a virtual cube from the Design Explorer:

  1. Click Design Explorer in the Sidebar.
    Accessing the Design Explorer from the Sidebar.
  2. Select the Virtual Cubes folder, then click its menu button.
    The Virtual Cube menu.
  3. From the Virtual Cubes menu, choose New Virtual Cube.
  4. In the text box below the Virtual Cubes folder, type a name for the virtual cube, then press ENTER.
    Virtual cube name.
    The new virtual cube appears as an item in the Design Explorer and the Set up a Virtual Cube wizard is displayed.
  5. In the first step of the wizard, select an OLAP (⪚ Microsoft SQL Server Analysis Services) data connector from the grid, then click Next.
    The first step of the Virtual Cube Setup Wizard.
  6. In the second step of the wizard, select a source cube from the grid.
    The second step of the Set up a Virtual Cube wizard.
  7. Click Finish. The Virtual Cube Designer is displayed in the content area of &dw;.
    The Virtual Cube Designer.
  8. Configure General settings for your virtual cube.
  9. Use the Definition tab to define the subset of the source cube that you are interested in.
  10. Create calculated measures from the Calculations tab.
  11. Define date mappings using the Date Mapping tab. Date mappings are needed if you want use dashboard parameter calendar controls on performance dashboards.
  12. Create analytical reports.
  13. Click Save from the Toolbar to save your changes.
    The Save button.
  14. To share your newly created virtual cube with other &dw; users, click Check In from the Toolbar.
    The Check In button.
    Optionally enter a comment in the Check In dialog, then click Check in.

You have created a virtual cube, which can now be used to create OLAP-based KPIs/datasets, or analytical dashboards.

Configuring general settings

Use the General tab of the Virtual Cube Designer to configure general settings for your virtual cube, all of which are optional.

To configure general settings for your virtual cube:

  1. Click the General tab in the Virtual Cube Designer.
  2. Enter a description for your virtual cube in the Description box. You can enter text up to 2000 characters in length.
  3. Enter a URL in the Additional info URL box. Use this option to link to a website that provides more information about your virtual cube. You will be able to access this link from the Additional Information dialog.

Creating a virtual cube from a data connector

From the Design Explorer, there is a quick way of creating a virtual cube based on a discovered cube from your data connector. This option bypasses the Virtual Cube Setup Wizard and is ideal in situations where you simply want to have a virtual cube that mirrors your physical cube and where all cube elements (⪚ measures and dimensions) are included by default.

To create a virtual cube from a data connector:

  1. Expand your data connector item in the Design Explorer.
  2. Expand the Cubes folder, then select a cube.
  3. Click the cube's menu button, then choose Create Virtual Cube from the resulting menu.
    Creating a virtual cube from a data connector.
  4. A Success dialog indicates that a new virtual cube has been created.
    The Success dialog.
  5. The new virtual cube appears under the Virtual Cubes folder in the Design Explorer.
    The new virtual cube.
  6. Click the menu button of the newly created virtual cube. From the resulting menu, choose Edit. The Virtual Cube Designer is displayed.
  7. Use the Virtual Cube Designer to configure the virtual cube as described in the section, Creating a virtual cube from the Design Explorer.
  8. Click Save from the Toolbar to save your changes.
    The Save button.
  9. To share your newly created virtual cube with other &dw; users, click Check In from the Toolbar.
    The Check In button.
    Optionally enter a comment in the Check In dialog, then click Check in.

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.