Updating Details of Data You Added

After you add data, you can inspect its properties and update details such as the description and aggregation.

1. In the Data Sources pane, right-click the data, and then select Inspect.
2. Inspect the properties and update the description of the data as appropriate.
3. Optionally, change the Query Mode for a database table. The default is Live because database tables are typically large and shouldn’t be copied to cache. If your table is small, then choose Auto and the data is copied into the cache if possible. If you select Auto, you will have to refresh the data when it is stale.
4. In the Columns area, specify whether to change a column to a measure or attribute as appropriate. For measures, specify the aggregation type, such as Sum or Average.
   For more information, see Specifying Aggregation for Measures in Fact Tables for descriptions of aggregation types.
5. To specify if others can share the data, see Controlling Sharing of Data You Added.
6. Click OK to save your changes.

Note:

You can also inspect data sources on the Data Sources page. For more information, see Managing Data Sources.