Database Reference
In-Depth Information
The cube designer also needs to know exactly which dimensional attributes link the tables together. In
this instance, that would be the Categories attribute, whose underlying column is the Category key in the data
warehouse. Figure 12-37 shows how the “Reference dimension attribute” and the “Intermediate dimension
attribute” settings are both configured to the Category attribute.
Figure 12-37. Configuring the reference dimension's relationship
Once we have added DimCategories to the cube, we can access category information within our
DimProducts dimension or through the DimCategories dimension (Figure 12-38 ).
And in fact, if all we needed in a cube was the category data, we could exclude the products data from it
altogether. You could simply hide the intermediate dimension by highlighting “Intermediate dimension” under
the Cube Structure tab of the cube designer and then changing its visible property to False. Once that is set, most
client applications will not see the intermediate DimProducts dimension at all.
Search WWH ::




Custom Search