Wednesday, September 03, 2014

SSAS Tutorial : Modifying Default Table Names

  1.  In the Tables pane of Data Source View Designer, right-click the FactInternetSalestable, 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 Diagrampane.
  3. Change the FriendlyName property for the FactInternetSales object to InternetSales.
  4. 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.
  5. Click DimProduct in the Tables pane. In the Properties window, change the FriendlyName property to Product.
  6. Change the FriendlyName property of each remaining table in the data source view in the same way, to remove the "Dim" prefix.
  7. When you have finished, click the Auto Hide button to hide the Properties window again.
  8. 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.

No comments:

Post a Comment