EMMAWiki/WebDocumentation/HowTos/DatasetBrowserHowTo

Browse DataSets

This Section describes the use of the Dataset Browser. A description of shered terms can be found in HelpSystem and shortcuts are explained in Ontology.

This Howto is subdevided in 2 subsections (chronological by menu prompt):

• Select Dataset(s)
• View Dataset(s)

Select Dataset(s)

The following imgage shows the dialog whith three raw datasets of the current exemplary experiment. Each dataset has an unique Identifier, a self explainig Name and if available a short Description. The Cube-Order, #BA-Dim,. #DE-Dim and #QT-Dim gives you information about the size and range of the dataset:

• Cube-Order: lay down the following order but is at current state always BDQ,
• #BA-Dim: show how many arrays where use of this dataset and is also at current state always one,
• #DE-Dim: shows how many Designelements where used and stands for the number of rows,
• #QT-Dim: shows how many Quantitationtypes where used and stands for the number of columns.

The Quality is an index for the user (ranges from very good to insufficient).

 === Show ===
 Clicking the Show All button shows the selected dataset(s) in one table as described in View Dataset(s).

 === Coincid QuantitationType-Selection ===
 The Common Label/Column Selection button let you take a preselection of Quantitationtypes which leads in the dialog shown below. Thus you decide for all
 selected dataset at once which Quantitationtype should be shown. You can get more information about each Quantitationtype by following the link.

 File:EMMAWiki$$WebDocumentation$$HowTos$$DatasetBrowserHowTo$browse dataset dialog preselection.png

 === Individual QuantitationType-Selection ===
 A more sensitive preselection occour if you click the Individual Label/Column Selection button. Thus you decide not for all at once but for every selected
 dataset individual which Quantitationtype you want. The dialog is almost se same as shown above but as many as selected datasets.

View Dataset(s)

The datasets are shown as one table which can be easily browsed with the navigation bar. Each DesignElement and Quantitationtype is linked for getting detailed information.

 === Range Designelements ===
 The first section of this window is for specifying how many DesignElements are shown each page. Enter a start and end position in the Dimension-Range label to jump to this
 position and also to commit the number of Designelements per page. The Search label offers you a simple possibility to restrict the Designelements by the Identifier. 

 === Sort by Quantitationtypes ===
 The blue arrows in the first row of the table let you sort the dataset ascendending or descendending. Also you can choose to sort only the currently shown page or the whole
 dataset(s) by switching the radio buttons above the table between Sort only this page or Sort whole dataset. If you decide to sort the whole dataset the 
 assortion remains while browsing the dataset until you click Drop Assortment. 
 of your table.

 === Filter Data ===
 The button filter data opens a new window where you are able to filter the dataset. Start to single out the whished Quantitationtype in the first drop-down menu then
 select an operator and leave the value for the comparison in the right text field. If you want to filter for more than one Quantitationtype or one Quantitationtype with 
 different  operation you have to chose AND at the first drop-down menu of ervery next line you want to include. The More button leads in as many new lines you want.
 As by the sorting the filter keeps by as long until Drop Assortment. You can reactivate the sorting/filtering by pressing the Keep Assortment button. This way 
 you switch between the raw dataset and your last performed sorting/filtering.

 File:EMMAWiki$$WebDocumentation$$HowTos$$DatasetBrowserHowTo$browse dataset filter.png

The following operators available:

• > : greater
• < : less than
• >=: greater or equal
• <= : less or equal
• != : not equal
• approx value epsilon : get all values approximately equal to value within an range of +/-epsilon (default 0.001). e.g.:

approx 10 0.1 will return all rows where the selected column value is between 9.9 and 10.1

• not missing : filter rows where selected column has a good value (not NaN)
• missing : the opposite, return all rows with missing values

 === Export ===
 It is possible to download the dataset as a tab seperated text file. You can either export the foltered/sorted dataset ore the whole dataset.