Viewing cached reports from the Application Console

The Sterling Order Management System Software enables warehouses to schedule reports during lean periods and cache them in a IBM® Cognos® Analytics content repository. If a cached version of the reports is available, you can view the reports without generating them each time.

To view the cached reports, you must save the report view in the following format:

Prefix the report name with parameter values sorted alphabetically and separated by an underscore (_).

  • If the parameter name has only one value, sort the parameter names alphabetically in the ascending order and prefix the report name using the parameter values.

    For example, consider a report with two parameters, Enterprise and Zone, with values E1 and A1 respectively. Sort the parameters in the ascending order (Enterprise and Zone) and prefix the report name with values E1 and A1. When you schedule a report, save the report as E1_A1_ReportName. When you run the report for Enterprise E1 and Zone A1, the system queries the Analytics content repository for the E1_A1_ReportName report.

  • If a parameter name has multiple values, first sort the values alphabetically, and then sort the remaining parameter names.

    For example, consider a report that takes the parameters Enterprise and Zone. The value of Enterprise is E1. The values of Zone are A1 and B1. First sort the values of Zone (A1 and B1), and then sort Enterprise (E1) in the ascending order of the parameters, and prefix the report name using the values E1, A1, and B1. When you schedule a report, save the report as E1_A1_B1_ReportName. When you run the report for Enterprise E1 and Zones A1 and B1, the system queries the Analytics content repository for the E1_A1_B1_ReportName report.