Adding Attributes to Dimensions

In the following tasks, you will use Dimension Designer to add attributes to the Customer and Product dimensions.

http://i.msdn.microsoft.com/Global/Images/clear.gif Adding Attributes to the Customer Dimension

To add attributes

1.      Open Dimension Designer for the Customer dimension. To do this, double-click the Customer dimension in the Dimensions node of Solution Explorer.

2.      In the Attributes pane, notice the Customer Key and Geography Key attributes that were created by the Cube Wizard.

3.      On the toolbar of the Dimension Structure tab, use the Zoom icon to view the tables in the Data Source View pane at 100 percent.

4.      Drag the following columns from the Customer table in the Data Source View pane to the Attributes pane:

·         BirthDate

·         MaritalStatus

·         Gender

·         EmailAddress

·         YearlyIncome

·         TotalChildren

·         NumberChildrenAtHome

·         EnglishEducation

·         EnglishOccupation

·         HouseOwnerFlag

·         NumberCarsOwned

·         Phone

·         DateFirstPurchase

·         CommuteDistance

5.      Drag the following columns from the Geography table in the Data Source View pane to the Attributes pane:

·         City

·         StateProvinceName

·         EnglishCountryRegionName

·         PostalCode

6.      On the File menu, click Save All.

http://i.msdn.microsoft.com/Global/Images/clear.gif Adding Attributes to the Product Dimension

To add attributes

1.      Open Dimension Designer for the Product dimension.

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, use the Zoom icon to view the tables in the Data Source View pane at 100 percent.

4.      Drag the following columns from the Products table in the Data Source View pane to the Attributes pane:

·         StandardCost

·         Color

·         SafetyStockLevel

·         ReorderPoint

·         ListPrice

·         Size

·         SizeRange

·         Weight

·         DaysToManufacture

·         ProductLine

·         DealerPrice

·         Class

·         Style

·         ModelName

·         StartDate

·         EndDate

·         Status

5.      On the File menu, click Save All.


Mr. Ravi Krishna - Senior Software Engineer
I am a Mocrosoft ASP.net Developer and MCP Certified professional. I have overall 5 years of experience in IT Industry,in that 3 years experience in Microsoft BI(SSAS,SSIS,SSRS). I have experience on various business domains like Automation and Chemical.
https://sites.google.com/site/rkkumardotnet/
Read moreRead more about Contributor