(4) modify the default table name

The metadata of tables and views in the data source view is derived from the metadata of these objects in the basic data source. Business Intelligence Development studio uses the metadata of these objects in the data source view to define dimensions, attributes, and measurement value groups. However, Bi development studio usesFriendlynameAttribute instead of itsNameAttribute. You can changeFriendlynameAttribute Value to improve the user-friendly feature of dimension and Multidimensional Dataset object names created in the data source view. After defining the names of these objects, you can also change them. For more information, see And .

In the following task, the friendly names of each table in the adventure works DW Data Source view will be changed, that is, the "dim" and "fact" prefixes will be deleted from these tables. This improves the user-friendly features of the multidimensional datasets and dimension objects that will be defined in the next course.

You can also change the friendly name of a column, define a calculated column, and join tables or views in the data source view to improve user friendliness. These options will be available in subsequent courses of this tutorial.

 

Modify the default table name

2. InData Source view designerOf"Relationship Diagram"Right-clickFactinternetsalesTable, and then click"Attribute".

   In this case, the hidden "properties" window appears, showing the adventure works tutorial Data Source viewFactinternetsalesObject Attributes.

4. Click"Hide automatically"Button to keep the window unhidden.

   When the "properties" window remains open, it is easier to change the attributes of each table in the data source view. If you do not use"Hide automatically"Button to keep the window open"Relationship Diagram"When you click another object in the pane, the window is closed.

6. SetFactinternetsalesObjectFriendlynameProperty changedInternetsales.

   IfFriendlynameClick an attribute unit to apply the change. In the next lesson, we will define a measurement value group based on this fact data table. Because of changes made in this course, the name of the fact data table will be internetsales rather than factinternetsales.

8. Click"Table"In the paneDBO. dimproduct, Click"Relationship Diagram"In the paneDimproduct, Or selectDBO. dimproduct datatable, And thenFriendlynameProperty changedProduct.

   In the next lesson, the dimension is defined based on the dimproduct table. Because of the changes made during this process, the dimension name will be product rather than dimproduct.

10. Use the same method to changeFriendlynameAttribute to delete the "dim" prefix.

12. After the changes are completed, click"Hide automatically"To hide the Properties window.

    Displays the data source view in the data source view designer and the new object name.

14. In"File"Click"Save all".

    This will save the changes you have made in the Analysis Services Tutorial Project so far. You can stop the tutorial here as needed and continue later.

You have successfully changed the default name of the table in the data source view, improving the user friendly feature that will be based on the dimension and measurement value groups defined in these tables.

Download and install the updated example to obtain the complete project used in Lesson 1st. For more information, see To obtain the updated example ".