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