When logging into the UAT or Production environments, users are able to view the analytics of the Fulfillment Center they have enabled, which comes from JASCI reporting.
The menu option for JASCI Reporting is often found under REPORTING → Dashboard & Reports → Reports.
This menu options allow users to see all the reports and dashboard. If a user is unable to view dashboard options, please refer to the User Visibility for JASCI Reporting Page.
There are tables for different types of reports that can be created, as well as unique tabs for your company.
Reporting
Inbound
Outbound
Locations & Planning
Sales Reports
Inventory
Labor
Management
Interface
These tabs contain reports where the data is pulled directly from our database.
Within each report, you can filter results by specific columns, Fulfillment Center, Company, set specific dates, row visibility, and have the ability to create custom reports.
Custom reports can be created by users, but more complex and personalized reports will need to be requested via ticket. To create a custom report, please refer to the Custom Reports page.
The Actions menu appears to the right of the Go button on the Search bar. Along with creating a custom report, these are the options users can use to sort, save, export, and subscribe to information.
Columns - Used to modify the columns displayed. The columns on the right display. The columns on the left are hidden. Users can reorder the displayed columns using the arrows on the far right. Computed columns are prefixed with **.
Filter - Focuses the report by adding or modifying the WHERE clause on the query. Users can filter on a column or by row.
Data - Allows you to sort data with the following options:
Sort - Used to change the columns to sort on and determines whether to sort in ascending or descending order.
Aggregate - Mathematical computations performed against a column. Aggregates display after each control break and at the end of the report within the column they are defined.
Compute - Enables you to add computed columns to your report.
Format - Enables users to customize the display of the report. Format contains the following submenus:
Control Break - Used to create a break group on one or several columns. This pulls the columns out of the interactive report and displays them as a master record.
Highlight - Enables users to define a filter. The rows that meet the filter criteria display as highlighted using the characteristics associated with the filter.
Rows Per Page - Sets the number of records to display per page.
Chart - Users can define one chart per saved report. Once defined, you can switch between the chart and report views using view icons in the Search bar. Options include:
Chart Type - identifies the chart type to include. Select from horizontal bar, vertical bar, pie, or line.
Label - enables users to select the column to be used as the label.
Axis Title for Label - title that displays on the axis associated with the column selected for Label. This is not available for pie chart.
Value - enables users to select the column to be used as the value. If the function is a COUNT, a Value does not need to be selected.
Axis Title for Value - the title that displays on the axis associated with the column selected for Value. This is not available for pie chart.
Function - an optional function to be performed on the column selected for Value.
Sort - allows you to sort your result set.
Group By - Users can define one Group By view per saved report. Once defined, you can switch between the group by and report views using view icons on the Search bar. To create a Group By view, you select:
The columns on which to group
The columns to aggregate along with the function to be performed (average, sum, count, etc.)
Pivot - Users can define one Pivot view per saved report. Once defined, you can switch between the pivot and report views using view icons on the Search bar. To create a Pivot view, you select:
The columns on which to pivot
The columns to display as rows
The columns to aggregate along with the function to be performed (average, sum, count, etc.)
Report - Options to save a custom report based on filters applied to report, or reset report back to it’s original state.
Download - Enables the current result set to be downloaded.
Subscription - Allows users to schedule the report to be sent to emails containing the current data using the report setting that were present when the subscription was added.
Help - More detailed information on each of the functions above.
Click on Actions → Filter, a small window will open where you can information as desired. Once you click ‘Apply’, the filter will apply to the report.
To export a report, click on Actions → Download.
This enables the current result set to be downloaded. The download formats include PDF, Excel, HTML, and CSV. The download options differ depending upon the selected format. All formats can also be send as an email. To send as an email, please fill out the appropriate information needed, and click ‘Send’.
To Subscribe to a report, click on Actions → Subscription
When you add a subscription, you provide an email address (or multiple email addresses, separated by commas), email subject, frequency, and start and end dates. The resulting emails include an exported version (PDF, Excel, HTML, or CSV) of the interactive report containing the current data using the report setting that were present when the subscription was added.
Once all information is added, click on ‘Apply’ to solidify your subscription.
