Attributes are commonly based on fields from a data source view. When
adding attributes to a dimension, you can include fields from any table in the
data source view.
In this task, you will use Dimension Designer to add attributes to the
Customer and Product dimensions. The Customer dimension will include attributes
based on fields from both the Customer and Geography tables.
In the Attributes pane,
notice the Customer Key and Geography Key attributes that were created by the
Cube Wizard.
On the toolbar of the Dimension
Structure tab, make
sure the Zoom icon to view the tables in the Data Source View pane
is set at 100 percent.
Drag the following columns from the Customer table in the Data Source View pane to the Attributes pane:
o BirthDate
o MaritalStatus
o Gender
o EmailAddress
o YearlyIncome
o TotalChildren
o NumberChildrenAtHome
o EnglishEducation
o EnglishOccupation
o HouseOwnerFlag
o NumberCarsOwned
o Phone
o DateFirstPurchase
o CommuteDistance
Drag the following columns from the Geography table in the Data Source Viewpane
to the Attributes pane:
o City
o StateProvinceName
o EnglishCountryRegionName
o PostalCode
On the File menu, click Save All.
Adding Attributes to the Product Dimension
To add attributes
Adding Attributes to the Product Dimension
To add attributes
1. Open Dimension Designer for the Product dimension.
Double-click the Productdimension in Solution Explorer.
2. In the Attributes pane,
notice the Product Key attribute that was created by the Cube Wizard.
3. On the toolbar of the Dimension
Structure tab, make
sure the Zoom icon to view the tables in the Data Source View pane
is set at 100 percent.
4. Drag the following columns from the Product table in the Data Source View pane to the Attributes pane:
o StandardCost
o Color
o SafetyStockLevel
o ReorderPoint
o ListPrice
o Size
o SizeRange
o Weight
o DaysToManufacture
o ProductLine
o DealerPrice
o Class
o Style
o ModelName
o StartDate
o EndDate
o Status
5. On the File menu, click Save All.
No comments:
Post a Comment