Designing a Cube

Introduction
Getting Started
  Sample Database
  New Project
  Data Source View
Designing a Cube
  Dimensions
  Hierarchies
  Cube Wizard
Deploying a Cube
  Deployment Errors
  Processing a Cube
More Options
  Calculated Measure
  Named Sets
Browsing with Excel
  Pivot Table Report
Glossary
Get Free SQL Tips

By: Siddharth Mehta

Overview

Using BIDS, after the DSV is developed, the next step is to create dimensions. Dimensions are of two types: Database Dimensions and Cube Dimensions. Database dimensions can be perceived as a master template, and Cube dimensions can be perceived as instances / children of this master template.

We will start our development with the creation of database dimensions. If you consider a dimension as a table, all the fields in this table can be perceived as attributes. Hierarchy in a dimension is a group of attributes logically related to each other with a defined cardinality. Finally we will create a cube using the dimensions we just developed, and fact tables to create dimensions (cube dimensions) and measure groups (from fact tables).

<< Previous

Next >>

Comments For This Article

Tuesday, August 30, 2016 - 6:43:30 PM - Davidw

"Finally we will create a cube using the dimensions we just developed, and fact tables to create dimensions (cube dimensions) and measure groups (from fact tables). "

You say "If you consider a dimension as a table", and then say that you will use fact table to create dimensions. How can a fact table create a dimension if a dimension is a table?

I have no idea what you are talking about. I suspect that people have adopted this jargain to convince themselves they are doing something really different, but I don't think they are. Being new to this, I am uncertain.