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.

Overview - Virtual Cubes

Hide navigation
RSS
Modified on Tue, 21 May 2013 03:57 PM Categorized as Data Preparation, OLAP, Overview, Virtual Cubes
Click to return to: Documentation | Defining Virtual Cubes


Virtual cubes

A virtual cube represents a subset of a physical cube from an OLAP data source, such as Microsoft SQL Server Analysis Services (SSAS). You define a virtual cube by selecting the elements from a source cube that you are interested in, and building analytical reports based on those elements. Once you have a virtual cube, you can create OLAP-based KPIs/datasets for use in performance dashboards, or go straight to designing analytical dashboards.

Workflow

The following figure illustrates how virtual cubes fit into the overall &dw; workflow.

Workflow for virtual cubes.

Workflow for virtual cubes.


OLAP data connector

Before creating a virtual cube, you need to set up a data connector to an OLAP source such as Microsoft SQL Server Analysis Services (SSAS). Using the data connector, you can access the Cube Viewer and perform basic analysis on a source cube.

For more details, see Creating a Data Connector.

Viewing a source cube (Sales) from a SSAS data connector.

Viewing a source cube (Sales) from a SSAS data connector.


Defining your virtual cube

Once your data connector has been created, you can begin defining your virtual cube. This involves selecting the cube elements (⪚ measures, KPIs, dimensions, named sets) and defining reports to be included in your virtual cube definition. You can even use a custom MDX query to restrict the cube to just the data you are interested in.

For more details, see Creating a Virtual Cube.

The Virtual Cube Designer.

The Virtual Cube Designer.


Designing an analytical dashboard

While designing an analytical dashboard, simply drag a virtual cube from the Toolbox onto the Canvas, and it will automatically appear as an Analytical Combo (&ie; OLAP Chart/Grid) control.

The Analytical Dashboard Designer.

The Analytical Dashboard Designer.


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.