Advanced Modeling - Microsoft SQL Server 2008 Analysis Services - page 96

employee works in. Therefore, the Employees dimension serves as the intermediate dimen-
sion through which information about the salaries of the employees is bound to informa-
tion about the stores in which they work. We can now see how much employee salaries
cost the company per store.

NOTE
We excluded from our example the parts of the definition that aren't related to the
point we're making in this section. For example, we omitted the definitions of the
dimensions.

LISTING 8.2

Defining a Referenced Dimension

<Cube>
<ID>HR</ID>
<Name>HR</Name>
<Dimensions />
<MeasureGroups>
<MeasureGroup>
<ID>Salary By Day</ID>
<Name>Salary</Name>
<Measures>
<Measure>
<ID>Salary Paid - Salary By Day</ID>
<Name>Salary Paid</Name>
<Source>
<DataType>Double</DataType>
<Source xsi:type=”ColumnBinding”>
<TableID>salary_by_day</TableID>
<ColumnID>salary_paid</ColumnID>
</Source>
</Source>
</Measure>
</Measures>
<StorageMode>Molap</StorageMode>
<ProcessingMode>Regular</ProcessingMode>
<Dimensions>
<Dimension xsi:type=”RegularMeasureGroupDimension”>
<CubeDimensionID>Employees</CubeDimensionID>
<Attributes>
<Attribute>
<AttributeID>Employee</AttributeID>
<KeyColumns>
<KeyColumn>