Lesson 1-4 - Modifying Default Table Names

APPLIES TO:yesSQL Server Analysis ServicesnoAzure Analysis Services

You can change the value of the FriendlyName property for objects in the data source view to make them easier to notice and use.

In the following task, you will change the friendly name of each table in the data source view by removing the "Dim" and "Fact" prefixes from these tables. This will make the cube and dimension objects (that you will define in the next lesson) easier to notice and use.


You can also change the friendly names of columns, define calculated columns, and join tables or views in the data source view to make them easier to use.

To modify the default name of a table

  1. In the Tables pane of Data Source View Designer, right-click the FactInternetSales table, and then click Properties.

  2. If the Properties window on the right side of the Microsoft Visual Studio window is not displayed, click the Auto Hide button on the title bar of the Properties window so that this window remains visible.

    It is easier to change the properties for each table in the data source view when the Properties window remains open. If you do not pin the window open by using the Auto Hide button, the window will close when you click a different object in the Diagram pane.

  3. Change the FriendlyName property for the FactInternetSales object to InternetSales.

    When you click away from the cell for the FriendlyName property, the change is applied. In the next lesson, you will define a measure group that is based on this fact table. The name of the fact table will be InternetSales instead of FactInternetSales because of the change you made in this lesson.

  4. Click DimProduct in the Tables pane. In the Properties window, change the FriendlyName property to Product.

  5. Change the FriendlyName property of each remaining table in the data source view in the same way, to remove the "Dim" prefix.

  6. When you have finished, click the Auto Hide button to hide the Properties window again.

  7. On the File menu, or on the toolbar of SQL Server Data Tools, click Save All to save the changes you have made to this point in the Analysis Services Tutorial project. You can stop the tutorial here if you want and resume it later.

Next Lesson

Lesson 2: Defining and Deploying a Cube

See Also

Data Source Views in Multidimensional Models
Change Properties in a Data Source View (Analysis Services)