Understanding Data Tree
Video tutorials
Data Tree provides the following three views to navigate through your data and saved analysis files: My Data, Discrete Values, and My Folders, as shown in Figure 2-1.
Figure 2-1  
My Data works with the Discrete Values viewer, which shows the content of explored fields, their values, and the number of stored entries with each value. Values are sometimes referred to as categories and entries as records.
Using My Data
My Data is available from Data Tree. Use My Data to display and navigate through databases, tables, and fields. To view the tables in a database, select the triangle icon beside the database name. To view the fields in a table, select the triangle next to the table, as shown in Figure 2-2. In this figure, the Demo database and the Customer table in the database are expanded and the fields in the Customer table are visible. Selecting the triangle next to an expanded database or table collapses the view of the items.
Figure 2-2  
Data items appear with a different identifying icon for each item type, as shown in Table 2-1. Unindexed fields appear without color but are otherwise the same as the associated physical field type.
In My Data, right-click an item to enable the following field operation options:
Making a calculated field permanent
A calculated field can be stored as a permanent field in the associated table for use by others. Identify a calculated field by the small, gray cog in the lower left corner of the calculated field icon. Unlike a calculated field, a permanent field can be used to sort columns in a report. Making a calculated field permanent replaces the calculated field. The database does not retain the original calculated field definition.
How to make a calculated field permanent
Using Discrete Values
Discrete Values is a view that shows the contents of individual database fields. Each unique value, or category, is represented by a total of all its occurrences or records.
Discrete Values appears when you double-click a database field in My Data. For example, double clicking the Age Numeric field in the Customers table displays a list of age ranges and the number of customer records matching each age range, as shown in Figure 2-3.
Figure 2-3  
Discrete Values also supports dragging fields and dropping them in places where selections or segments are used. For example, drag one or more specific categories to Scratchpad to examine the values in detail or store them for future use.
When a field has many categories, the viewer displays them on multiple pages. Typically, the list of discrete values is paginated, because most fields have a large number of categories. By default, the viewer shows 100 categories per page. For example, [Household].[Town] is a field that contains many discrete values. [Order].[Order No] contains more discrete values as there is a unique category for every order.
Categories can be sorted by name and the number of records they contain. The default sort order is by number of records. To sort categories in alphabetical order, click Value. A search engine supports finding particular categories by Name. Select multiple discrete values by holding CTRL while clicking the desired categories.
Using My Folders
My Folders displays the files and folders available to a user, as shown in Figure 2-4.
Figure 2-4  
Files and folders in the My Folders section in My Folders are available only to you. Files in the Shared section are visible to all users. Files can contain analyses, selections, and exports. There is no fixed limit to the number of folders you can create. To share a file with other users, move the file under the Shared heading.
Create new folders directly or while saving a file:
Figure 2-5  
To save a complete data structure into a file with a .ddw extension, right-click a file and choose Export. The file can be downloaded to your local system. To load previously stored structures, right-click a folder and choose Import.
Related topics
Understanding Scratchpad
Understanding Data Explorer
Understanding range selection
Video tutorials
Introduction to the work environment
Saved items
Interval selection
Make permanent

Additional Links:

Copyright Actuate Corporation 2013 BIRT Analytics 4.2