In this recipe, we will determine hierarchies in relational models. This recipe will also go over some of the main attribute dimension types. Attribute dimensions are dynamic dimensions that allow users to report on their data without increasing the foot print of the database. Attributes work in a similar way to an alternate hierarchy, but unlike an alternate hierarchy you can use an attribute dimension to conduct cross tab reporting on a different axis than your base dimension.
To get started, open SQL Server Management Studio, and add a database
TBC, or if you are using Oracle you can add schema
TBC and use TOAD or Golden to complete the recipe.