3.4 modify the "product" dimension

name calculation can be used to generate descriptive Dimension member names, define other user hierarchies, or specify the names of "(all)" members, to improve user-friendly features of the dimension. You can specify the "all"-level Member names of the Attribute Hierarchy based on the "all"-level Member names of each user hierarchy. In tasks under this topic, a user hierarchy is defined in the "product" dimension, and the product series name is spelled out by name calculation, specify the "(all)" member name for the Attribute Hierarchy and the new user hierarchy. You can also delete unnecessary dimension attributes and add them to the display folder. For more information, see , ,

Delete unnecessary attributes
Delete unnecessary attributes

2. In Solution Explorer, double-click"Dimension"Node"Product"To open the dimension designer for the "product" dimension.

3. In the features pane, select and delete the following features:

   • Arabic description

   • Chinese description

   • English description

   • English product name

   • finished goods flag

   • French description

   • French product name

   • Hebrew description

   • product alternate key

   • product subcategory key

   • size unit measure Code

   • Spanish Product Name

   • Thai description

   • weight unit measure Code

   the preceding attributes are not used in the initial analysis services tutorial multi-dimensional dataset.

Define name calculation, modify Name property values, and define user hierarchies
Define name calculation, modify Name property values, and define user hierarchies

2. Switch toAdventure works DWData Source view.

4. In"Relationship Diagram"Right-clickProductTable, and then click"Create name calculation".

   The"Create name calculation"Dialog box. You will use this dialog box to create a name calculation, which will be used to display the complete product series name without the encrypted name.

6. In the Create name calculation dialog box "column name" , enter productlinename .

8. In the Expression check box, enter the following SQL Script:

   	copy Code
   case productline when 'M' then' mountain 'when' R 'then' road 'when's 'then' accessory 'when' t 'then' touring 'else' components' end

   This SQL script creates user-friendly names for each product series in a cube.

10. Click"OK".

    In this caseProductlinename.

12. Switch to the dimension designer of the "product" dimension."Dimension Structure"Tab"Features"In the pane, select"Product series"In the "properties" windowNamecolumnAttribute Value changedDimproduct. productlinename (wchar)And then click"OK".

    After the above changes are deployed,"Product series"The members of the property hierarchy will display the full name of the product series, instead of the product series name.

14. In"Features"In the pane, select"Product"In the Properties windowNamecolumnProperty value changedDimproduct. englishproductname (wchar).

16. Set"Product"AttributeNameProperty value changed"Product name".

18. Set"Product series"Attribute from"Features"Drag pane"Hierarchy and level"Pane.

    The default name isHierarchy.

20. In"Hierarchy and level"In the pane, selectHierarchyIn the Properties windowNameProperty changed"Product model series".

22. Set"Model name"Attribute from"Features"Drag the pane"Product model series"Hierarchical Structure, and placed in"Product series"Lower level.

    The second level is defined in the "Product Model Series" User hierarchy.

24. Set"Product name"Attribute from"Features"Drag the pane"Product model series"Hierarchical Structure, and placed in"Model name"Lower level.

    In this case, a third level is defined in the "Product Model Series" User hierarchy.

Specify the folder name and "all" level member name
Folder name and member name

2. In"Features"In the pane, select the following features:

   • Class

   • Color
   • Days to manufacture
   • Reorder point
   • Safety Stock Level
   • Size
   • Size Range
   • Style
   • Weight

4. In the Properties windowAttributehierarchydisplayfolderIn the attribute unit, TypeStocking.

   These attribute groups are placed in a separate display folder.

6. In"Features"In the pane, select the following features:

   • Distribution price

   • Price
   • Standard Cost

8. In the Properties windowAttributehierarchydisplayfolderIn the attribute unit, Type"Finance".

   These attribute groups are placed in the second display folder.

10. In"Features"In the pane, select the following features:

    • End Date

    • Start date
    • Status

12. In the Properties windowAttributehierarchydisplayfolderIn the attribute unit, Type"History".

    Put these attribute groups in the third display folder.

14. In"Hierarchy and level"Select"Product model series"User hierarchy, and then in the "properties" windowAllmembernameProperty changed"All products".

16. Click"Hierarchy and level"Blank area of the pane.AttributeallmembernameProperty changed"All products".

    Click the blank area to modify the attributes of the Product Dimension. You can also click the "product" dimension icon at the top of the property list in the "properties" pane.

Check "product" dimension changes
Check "product" dimension changes

2. In business intelligence development studio"Generate"Click"Deployment Analysis Services tutorial".

4. After the deployment is completed, switch to"Browser"Tab. Confirm that you have selected"Hierarchy"In the list"Product model series", And then expand"All products".

   Note,"All"The name of the level member is displayed as "all products,"Product series"Level members have user-friendly names instead of single-letter abbreviations.

6. In"Hierarchy"Select from the list"Product series".

   Note,"All"Level members are displayed as "all products ".

8. In"File"In the menu, click"Save all"Save the changes to the Analysis Services Tutorial Project. In this way, you can stop the tutorial here as needed and continue later.

   In the next task of this lesson, you will check the analysis tutorial cube to view all your changes in this lesson.

In"Product"Dimension Definition"Product model series"User hierarchy, SetProductlinenameAdd namecomputation to the data source view, and then define the namecomputation column"Product series"FeatureColumnidProperties, you have successfully improved the user-friendly features of the Analysis Services tutorial cube. By deleting dimension attributes that are not required in a multi-dimensional dataset, You can group other attributes in the display folder and set the hierarchical structure of each attribute and"Product model series"The user hierarchy defines a "(all)" level name, and you have also improved the user-friendly feature of the adventure works tutorial cube.