Designing a Cube



By:

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).


Last Update: 5/3/2011






Comments For This Article




Tuesday, August 30, 2016 - 6:43:30 PM - Davidw Back To Top (43229)

 "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.

 

 

 

 

 

 

 



download








get free sql tips
agree to terms


Learn more about SQL Server tools