BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Posted by Andy Brown on 16 May 2011
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Summary of Jargon
Unfortunately, Analysis Services is absolutely full of jargon. This page summarises some terms to start us off.
Dimensions, Measures and Facts
The main terms used for a cube are as follows:
|Term||What it means|
|Dimension||A cube has one or more dimensions: here there are two, since we are showing the number of Oscars by studio and director.|
|Measure||A measure is any statistic being reported (here the number of films for each combination of dimension).|
|Measure group||Where there are two or more statistics, these form a measure group. For example, if we were reporting the total number of Oscar nominations and the total number of Oscars won for each film, these two measures would form a measure group.|
|Fact table||A fact table is a table which isnâ€™t being used as a dimension: here the tblFilm table containing the Oscars data is a fact table.|
Here is an illustration of dimensions and measures:
If you want to read on, the next tutorial in this series is on Visual Studio and Business Intelligence Development Studio.