Logical Data Warehouse Design - Data Warehouse Systems: Design and Implementation - page 149

Analysis Services allows the user to specify friendly names for tables
and columns. In order to facilitate visibility and navigation for large data
warehouses, it also offers the possibility to define customizable views within
a DSV, called diagrams , that show only certain tables.
Fig. 5.21 The data source view for the Northwind cube
The DSV, based on the Northwind data warehouse of Fig. 5.4 , is given in
Fig. 5.21 .Wecanseethe Sales fact table and the associated dimension tables
(recall that the ragged geography hierarchy was transformed into a regular
one). The figure also shows several named calculations, which are identified
by a special icon at the left of the attribute name. As we will see later, these
named calculations are used for defining and browsing the dimensions. The
calculations are:
￿ In the Employee dimension table, the named calculation FullName combines
the first and last name with the expression
FirstName + '' + LastName