Report Builder - Professional SQL Server 2005 Reporting Services - page 377

Figure 9-7
The second piece of information you want to display in this report is the Year (based on order date)
across your columns. The Order Date field you need is located in the Reseller Sales entity. As the report
is now, you cannot see the Reseller Sales entity. This is because Product Category has no direct relation-
ship with Reseller Sales. Product Category is related to Reseller sales through the Product and Product
Subcategory entity. So, to navigate to Order Date, you will need to select Dim Product Subcategories
from the Explorer window, then Dim Products, next Fact Reseller Sales, and finally Order Date. Figure
9-9 illustrates the movement through this hierarchy.