Step by Step Design Cube Using Analysis Service (SSAS)
A cube is defined by its measures and dimensions. The measures and dimensions in a cube are derived from the tables and views in the data source view on which the cube is based, or which is generated from the measure and dimension definitions:
Details on :
https://gallery.technet.microsoft.com/Design-Cube-in-SQL-Server-49ee6e1c
