Thursday, September 04, 2014

SSAS Tutorial : Modifying the Customer Dimension

Modifying the Customer Dimension


1.       Switch to Dimension Designer for the Customer dimension in SQL Server Data Tools (SSDT). To do this, double-click the Customer dimension in the Dimensionsnode of Solution Explorer.
2.       In the Attributes pane, right-click English Country Region Name, and then clickRename. Change the name of the attribute to Country-Region.
3.       Change the names of the following attributes in the same manner:
o    English Education attribute — change to Education
o    English Occupation attribute — change to Occupation
o    State Province Name attribute — change to State-Province

On the File menu, click Save All.

No comments:

Post a Comment