# Generating WebLogic RFID Enterprise Server Reports

# Generating Dwell Time Reports

Dwell time reports show how long assets have remained at a specified business location.

This chapter contains the following sections:

- Generating Dwell Time Reports
- Setting Dwell Time Report Options
- Contents of a Dwell Time Report

## Generating Dwell Time Reports

To generate a dwell time report:

1. In the Reporting Service Console, select the Dwell Time tab.
2. Specify settings for the report, as described below under Setting Dwell Time Report Options.
3. Click Run Report.

The results are displayed in your Web browser. If you want to print the report, print it from the browser.

## Setting Dwell Time Report Options

To prepare a dwell time report, specify values for the desired selection criteria, as follows.

- Set Asset Selection Criteria
- Set Start Time and End Time
- Set Location Selection Criteria
- Set Report Display Options

You must specify a location under Location Selection Criteria. Other than that, there are no specific dependencies among the other criteria. You can set criteria for none, one, several, or all of the remaining categories.

In some sections on this page, you can enter items (EPCs, GTINs, location URNs, etc.) directly in the field provided for that type of item. You can list multiple items by separating each one with a space or a carriage return.

### Set Asset Selection Criteria

Set options in this section to limit the report to assets of the specified types.If you set no options, the default criterion Select All Assets is used.

To specify a type of asset on which to report, select the type from the drop-down list. The choices are:

- Select All Assets. Select this option to report on assets of all types.
- Specify EPCs. After selecting this type, enter the Electronic Product Codes (EPCs) of the assets to report. You do not have to include the `urn:epc:id/urn:epc:idpat` portion of the EPC. For example:

    sgtin:1234567.000001.600

    sgtin:1234567.000001.780

    sgtin:1234567.*.*

- Specify GTINs. After selecting this type, enter one or more 14-digit Global Trade Item Numbers (GTINs) of assets to report. For example:

    10054000217255 10037000308048

- Specify Company Prefixes. After selecting this type, enter the GS1 Company Prefixes of assets to report. For example:

    1234567 0037000

- Specify EPC Classes. When you select this type, a second drop-down list appears. Do one of the following:

- Choose List EPC Classes to enter EPC class patterns directly, as URIs. You do not have to include the `urn:epc:idpat` portion of the EPC class pattern. For example:

        sgtin:1234567.000001

        sgtin:1234567

The report will be limited to assets of the specified EPC classes, where the EPC class pattern exactly matches or includes the string entered here.

- Choose Search EPC Classes to search for assets based on master data attributes defined for the EPC class to which the assets belong. (This option is available only when master data has been defined for EPC classes.)

When you choose this option, a table is displayed for specifying the search criteria. Enter criteria as follows:

- Select an attribute from the Attribute column.
- Enter a value for the selected attribute in the Value field. This field is case-sensitive, so enter the value using the correct upper- and lowercase letters. Only exact matches to this value will be returned.

To delete an attribute from the search criteria, click Delete in that row.

To add a row for entering a new attribute on which to search, click Add.

If master data exists for the EPC class of a reported asset, the master data value for the EPC class attribute is displayed in the report, whether you used the List EPC Classes option or the Search EPC Classes option. If master data does not exist, the URI that identifies the EPC class is displayed.

### Set Start Time and End Time

Specify options in this section to report only on assets associated with events that occurred during the period bounded by the specified start and end time ranges. You can specify a start time only, an end time only, both, or neither.

If you set no options in this section, time ranges are ignored when the report is generated.

If you want to specify a start time or end time, you must at least enter a year. The other values are optional:

- If you do not set a month, the default is January.
- If you do not set a day, the default is 1 (the first of the month).
- If you do not set a time, the default is as it appears in the Console, for example, 12:00 A.M.

### Set Location Selection Criteria

Set options in this section to limit the report to assets associated with events that occurred in the specified business locations. If you set no options in this section, business locations are ignored when generating the report.

If a specified business location includes "child" business locations (for example, a warehouse might contain several portals), all the locations in the hierarchy are evaluated when generating the report.

To specify a location, select an option from the drop-down list.

The choices are:

1. List Locations. After selecting this option, enter the business location identifiers on which to report. Specify a business location identifier as a URN, for example:

    urn:epc:sgln:1234567.123

Separate each business location identifier in a list with a space or a carriage return.

2. Search Locations. This option is available when master data has been defined for business locations. Choose this option to search for assets associated with events occurring at a specified business location. When you select this option, a table is displayed for specifying search criteria. Enter criteria as follows:

1. Select an attribute from the Attribute column. The attributes listed are from master data associated with business location identifiers.
2. Enter a value for the attribute in the Value field. This field is case-sensitive, so enter the value using the correct upper- and lowercase letters. Only exact matches to this value will be returned.

To delete an attribute from the search criteria, click Delete in that row.

To add a row for entering a new attribute on which to search, click Add.

If master data exists for the business location included in a record, the master data entry value is displayed in the report, whether you used the List Locations option or the Search Locations option. If master data does not exist, a URI is displayed.

### Set Report Display Options

Set display options as follows:

- From the Rows per page drop-down list, select a number to set the number of results to be listed per page.
- From the Sort By drop-down list, select the column on which you want to sort the results when the report is first displayed.

Note: | You can resort the report by clicking any column header label that is displayed as a hyperlink.

## Contents of a Dwell Time Report

The columns in a dwell time report are described in Table 5-1, below. Each row in the table shows an asset (identified by an EPC) plus the information to indicate how long the asset remained in a specified business location, according to the options specified for this run of the report.

If master data has been defined for assets in the report, the master data values are shown in the appropriate fields in the report, in place of more technical (and less readable) identifiers. The fields where that can happen are identified by a Yes in the Display Master Data column.

Table 5-1 Dwell Time Report Contents
Column Name | Description | Display Master Data?
--- | --- | ---
EPC | The Electronic Product Code (EPC) that uniquely identifies the asset. | No
Asset Description | A description of the asset, specified as master data. | Yes If no master data exists for this asset, this field is blank.
Entry Time | The time the asset entered the specified business location. The time is locale-specific. That is, it reflects the time zone where the event took place. | No
Exit Time | The time the asset exited the specified business location. The time is locale-specific. | No
Dwell Time | The time the asset was in the specified business location. The time is locale-specific. | No