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.

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.