Viewing Sample Data

From the Data Sources tab of the Source Navigator, you can then view the available sample data for up to 200 rows of a table in a data source or from source columns within a table.

In the Metadata Navigator, you can also view up to 200 rows of the available sample data related to a dimension element.

Viewing Sample Data from the Data Sources Tab

To view sample data in a data source:

From the Source Navigator, select the Data Sources tab and expand the data source.
Perform either or both of the following actions:
- To view data for a table in the data source, right-click the table and select View Sample Data.
- To view data for one column from a table in a data source, expand the table, right-click a column, and select View Sample Data.
  Alternatively, to view data for one or more columns within a table, press and hold the Ctrl key, click on the columns whose data you want to view, and then right-click and select View Sample Data.
The sample data is displayed in a new tab in the work area of the console.
Note:
A maximum of 200 rows of sample data is returned.
To close the sample data window, click the X on the window tab.

Note:

If source data is added, modified, or deleted while the sample data viewing window is open, data does not automatically refresh in the open window. You must close the window and reissue the View Sample Data command to view the changed data.

Viewing Sample Data from the Metadata Navigator

To view sample data for dimension elements:

In the Metadata Navigator, navigate to the dimension elements for which you want to view sample data.
Right-click the element and select View Sample Data.
If the caption binding and key binding expressions for the selected element are the same, only View Sample Data is displayed and there is no submenu.
If the caption binding and key binding expressions for the selected element are different, both the With Caption Binding option and the With Key Binding option are shown as submenu items of View Sample Data.
If the key binding expression for the element is Delayed, then the With Key Binding option is disabled.
The sample data that you requested is displayed in a new tab in the work area of the console.
Note:
A maximum of 200 rows of sample data is returned.
For example, using the TBC sample database, create a dimension element based on the REGION column of the REGION table where the caption binding expression equals connection : \'tbcSource'::'tbc.region'.'REGION' . toString ; and key binding expression equals connection : \'tbcSource'::'tbc.region'.'REGIONID' . toString.
When you select the With Caption Binding option, the sample data results are:
```
    REGION
1   East
2   West
3   South
4   Central
```
When you select the With Key Binding option, the sample data results are:
```
    REGIONID
1   1
2   2
3   3
4   4
```
To close the sample data window, click the X on the window tab.