Workbooks

Before you can create a report, pivot table, or chart, you need to create a workbook for your data. You can create as many workbooks as you need in DataMiner to display data in different sets and configurations. For example, one workbook might contain quality data; another might feature data from a selected Bill of Materials (BOM).

The following illustration shows a typical workbook created in DataMiner.

Open

Data sources

Data sources return predefined data, depending on the specific source and the search and filtering options you specify. When data is returned from search and filtering, you can manipulate and format it into specific value sets for use in charts, reports, pivot tables, or for raw export to various data formats such as *.xls, *.xml, and *.txt. A workbook can have one or multiple data sources, so there are many possible combinations of data for analysis and reporting.

Each data source has its own tab at the bottom of the workbook view; tabs at the top of the window contain the specific search and filter criteria for the selected data source.

Open

The default name for a new workbook is Workbook (1), Workbook (2), and so on. We recommend you implement an effective workbook naming convention to display your data accurately to others and to help keep your workbooks organized.

1. Log into the Analytics client application.

2. Select Data Miner/Data Analysis from the Analytics Home window.

3. Select New Workbook at the top of the DataMiner window.

4. Under Data Sources, select a data source category for your report, pivot table, or chart (Material and Traceability, Miscellaneous, NPI, Production & WIP Tracking, and so on).
   
   

Run a data set

After you add a data source, the Execute and Execute All buttons become available. These buttons initiate the data search/return after you define the search and filtering criteria.

• The Execute button executes a data search one data source at a time.
  
  If a single workbook contains a single data source, then the data for that source will be returned. If a workbook contains multiple data sources, the execute button returns the data for the selected data source (by its tab).
  
  

• The Execute All button executes a search on all data sources in a single workbook simultaneously.
  
  If there are multiple workbooks in the work area, only the selected workbook will return data.