Datasets contain information that can be viewed and modified in a grid. While queries return the most current information in the database, a dataset displays the same information until it is modified manually. For example, you might use a dataset to store information from an external system so that the data can referenced or used to create graphs in GE Digital APM.
When a dataset is created, a data type is defined for each column to indicate the type of data that can be stored in cells in that column. When you create or modify a dataset, if you attempt to enter data that conflicts with the data type defined for that column, the data will not be retained. The following types of data can be stored in a dataset:
- Character: Stores alphanumeric data. Cells in columns of this data type will appear as text boxes in which you can enter letters, numbers, and symbols.
- Numeric: Stores numeric data. Cells in columns of this data type will appear as text boxes in which you can enter numbers.
- Date: Stores date and time data in the format MM/DD/YYYY. Cells in columns of this data type will display the
button, which can be selected to access a calendar from which a date can be selected. You can also enter dates directly into cells. - Logical: Stores the value True or False. Cells in columns of this data type will appear as text boxes in which you can enter the value True or False.
You can create new datasets manually within GE Digital APM, or by importing a Microsoft Excel file (.xls or .xlsx), an XML file (.xml), or a text file (.txt or .csv).
After you create a dataset, you can access it, modify it, use it to create graphs, and export it as a Microsoft Excel file, an XML file, or a text file.