Sample Data

From Alchemex 7.1

Home > Connector > Testing > Sample Data

Sample Data

The Sample Data icon    enables a sample of data to be viewed from a source container in a Sage Intelligence Reporting Data Screen. The sample includes 50 Rows with all columns from the underlying source.

 

Note that the sample brings back all fields regardless of what expressions have been published for the container.

 

This feature is useful in the MetaData mapping process and allows a quick way to view and choose the fields that should be published. It is also useful when used on individual expressions, especially when using SQL expressions to ensure that the syntax you have used will achieve the desired result.

 

Note that the Sample Data feature cannot be performed on a container or a container expression where the connection server and database names are set as pass through variables.