Reports Generated by Fact Models You Create

By using the Report wizard, you can select and customize options for Reporting Services reports created from your fact models.

Because these reports are based on fact models, changes to the reports (other than the filtering options available through this option) are done in the Eclipse Report Editor and Format Editor, or by making changes to the fact model itself, using the Fact Model Builder.

Reports – [ReportName]: Report By

Field

Description

Report By Fields

Select the field that the report should be grouped by. For example, if the fields in your report are Name and PartNumber, select “PartNumber” for a report grouped by part number.

Reports – [ReportName]: Detail Filtering

Field

Description

Operator
The operator filter function enables you to further define search criteria for many report parameters. Valid values are:
  • ALL
  • Equal To
  • Not Equal To
  • Like
Note: IBM® Sterling B2B Integrator displays a text box if you select an operator other than ALL. Do not use special characters that are not allowed for the parameter you are filtering by.

Field Name

Type the name of a field

Reports – [ReportName]: Detail Filtering Date/Time

The date calculation is made when the report is run. You must select either during previous or a date range.

Field

Description

During previous Hours, days, weeks, months

The time period when the report was last modified.

Or From / To Date

The date and time range in which the report was last modified.

Reports – [ReportName]: Display Order

When you choose a display order, the Report By fields are evaluated as having a set sort order which is not changed by the display order options.

Field

Description

Sort Order (for display)

Whether the report is sorted in ascending order (for example, A to Z) or descending order (for example, Z to A).

Order

The exact order in which parameters are displayed. Select a parameter and click the arrows keys to arrange the parameters in the desired order.