Material History (New Design)#

Description#

This report enables you to customize some of information provided in the Material History report, which is available for any Material in the Operational Data Store (ODS) database.

The fields currently available are:

• Step
• Service
• Material Attributes
• Data Collection
• Losses/Bonuses
• Defects

Customization#

The Material History New Design report can be accessed through the Business Intelligence menu, as shown in the image below.

To customize the report, start by creating a clone of the original report:

Specify a name and a description for the cloned report.

Navigate to the Business Intelligence menu and apply the Only New Design filter. From the filtered list, select the cloned report that was just created.

Expand the panel by selecting the icon and choose the Edit Layout button on the top ribbon.

The Editor mode is powered by a third-party software, Stimulsoft ⧉, which is a rich designer with several customization options.

Editing Report and Page Properties#

The editor allows you to edit the properties of any layout element, including the page object and the Report. To access the editor, locate the Properties tab at the bottom of the left panel. There, you may select the different page elements in the main dropdown of the panel.

Depending on the object selected above, the customization options may vary. For example, if you select the Page object, you may set a different Paper Size, Page Width, Page Height, and more. You may also define a Watermark Style by uploading an image or text as displayed below.

Layout Design#

Context#

All values of the Material History Context Items plus the system data items, are available on the Dictionary tab of the layout designer, which is located next to the Properties tab, at the bottom of the left panel. There, you can access the Data Sources, Variables, System Variables, Functions, and Resources.

You can manipulate the Material History report items within the Dictionary tab. For example, if you expand the Data Sources category, you will access all the information that could be displayed in the report. You may add or remove as you desire; you may also change the position of the data in the report. For each data source, if you right-click on top of an element you will have several options, including accessing the Properties of the same item. Similarly, you may do the same for Variables and System Variables.

Data#

You can tailor the data displayed in the report to meet your specific needs, simply:

1. Navigate to the Dictionary tab in the left panel and select New Data Source from the New dropdown.

   

2. In the Report Connections section, choose DataManager-DWH.

   

3. Select the data you wish to include in the report.

   

4. Drag and drop the desired data into the report layout to use it.

   

Additionally, you can add new Variables, Functions, and Resources. For more information, see Data Dictionary ⧉.

Validation#

To validate your report, select the Check for Issues button, which is located below the Dictionary tab. This feature identifies and displays errors, warnings, informational messages, or report rendering messages that may require your attention.