The dialog found under Edit > Data Table Properties contains settings that apply to the data tables used in the analysis. For example, you can define which data table to use as default when creating new visualizations, set up sharing routines, or define how data should be stored when saving the analysis. To learn more about data tables, see Data Tables Overview. You can also change some data table properties directly from The Expanded Data Panel.
To change the name of a data table:
If the data panel is not already
open, click .
Click on the Expand
data panel for tools and details button, .
If you had a column selected in the data panel you may need to click on the Got to data table view link to see the data panel view.
In the expanded data table view, click on the edit button to the right of the data table name and type the new name.
To change the default data table to use when creating new visualizations:
Select Edit > Data Table Properties.
Click on the data table to use in the Data tables list.
Comment: New data tables are added by selecting File > Add Data Tables....
Click on the Set as Default button to the right of the Data tables list.
Click OK.
Response: All new visualizations created from here on will use the specified data table.
Comment: To change the data table used in an already-created visualization, right-click on the visualization and select Properties from the pop-up menu, then go to the Data page.
To define a new relation between two data tables:
Select Edit > Data Table Properties.
Go to the Relations tab.
Click on Manage Relations....
Response: The Manage Relations dialog is opened.
Select the data table to Show relations for.
Click New....
Select the two data tables you want to connect from the Left data table and Right data table drop-down lists.
Select the columns containing the identifiers from the Left column and Right column drop-down lists.
If desired, you can apply a Left method or Right method to modify the values of one or both columns.
Comment: For example, if the identifiers are written in uppercase letters in one of the data tables and in lowercase letters in the other, you can use the Lower method on the uppercase column and change the letters to lowercase. For data tables referring to cube data sources you can specify that the match should be based on keys rather than values by selecting the KeyOf method for the cube data table.
Response: The result of the method application is shown in the Sample field, when applicable.
Click OK.
To add a new match between columns in different data tables:
To add a new data table property:
Select Edit > Data Table Properties.
Go to the Properties tab.
Click on the New... button.
Response: The New Property dialog is opened.
Enter a name for the new property.
Select a data type for the new property.
Enter a value to use as default value for the property.
Click OK.
Response: The new property is added to the list of available properties.
Comment: New properties can also be created on most places where you can use them. For example, by right-clicking in the Available properties for column list in the expression dialogs.
See also:
Details on Data Table Properties - General
Details on Data Table Properties - Source Information
Details on Data Table Properties - Relations
Data Table Properties – Column Matches
Details on Data Table Properties - Properties