Database Reference
In-Depth Information
Click on Next and if you are building your dimension from a set of snowflaked
tables, you get to the Select Related Tables set, where you have the option of
selecting other tables you want to use to build this dimension. After this, you move
onto the Select Dimension Attributes step, where you have the option of creating
other new attributes on the dimension by checking any columns that you'd like to
turn into attributes. You can also rename the attribute, uncheck the Enable Browsing
option (which controls the value of the AttributeHierarchyEnabled property, as
shown in the following screenshot), and set the Attribute Type —a property that has
a bewildering array of possible values, most of which are pointless, and which can be
ignored unless you're designing a Time or an Account dimension.
Now that we are into the final step of the wizard, all there is to do is to confirm the
name of the dimension and click on Finish .
 
Search WWH ::




Custom Search