Synthesis Data Warehouse (SDW)

Available in Weibull++, ALTA and RGA, the Synthesis Data Warehouse (formerly called “Reliability Data Warehouse”) enables you to access data from an XFRACAS incident tracking system for the purpose of life data analysis (in Weibull++/ALTA) or repairable system/reliability growth analysis (in RGA). Now in Version 10, we have added the ability to set up custom connections to obtain reliability-related data from external data sources (including Access, Oracle and SQL Server). You can also get data directly from your own custom reports created in ReliaSoft's XFRACAS.

You can then transfer the data to a standard folio in Weibull++, ALTA or RGA, or use the flexible Synthesis Dashboard utility to explore and present the data in a variety of graphical charts and grids. (See Transferring from the SDW to a Standard Folio or SDW Dashboards.) In addition, if a Synthesis Enterprise Portal has been implemented for an enterprise database, users can also access SDW dashboards from any web-enabled device.

To open the SDW in Weibull++, ALTA or RGA, choose Home > Synthesis > Synthesis Data Warehouse.

Managing Data Sources

The available data sources are listed in the data source manager on the left side of the window. They may include:

Static data collections that were extracted from XFRACAS at a particular point in time (and will not change if incidents are later added or updated). These can be either Weibull++/ALTA data or RGA data. (See Extracting Data from XFRACAS.)
Custom connections that have a live link to a specified external database or to a predefined report created in XFRACAS. (See Custom Connections in the SDW.)
Static data collections that were extracted from a custom connection at a particular point in time (and will not change if the original data source changes). (See Import to a Static Data Collection.)

If you are working with a long list of available data sources, this panel can utilize the same categories, identifiers and item filters that are available in many other locations throughout Synthesis desktop applications.

To create, delete, rename or edit the properties for these data sources, use the Manage Data Sources commands in the ribbon, or right-click inside the panel.

The Properties window allows you to enter identifiers for each data source, and to view its history.

Built-in Find/Filter, Configuration and Grouping Tools

Double-click any data source to display the data in a grid on the right side of the window. The SDW offers the same filter, column configuration and grouping tools that are built in to other Synthesis utilities that use a similar grid (e.g., the Synthesis Explorer, Actions Explorer, etc.). For details about how to use each feature, see:

Building the Data Set

The "Include in Analysis?" column shows whether each row will be included in the data set when it is transferred to Weibull++, ALTA or RGA, or viewed in a dashboard.

Include: Data points that will be included in the data set are shown in green.
Invalid: In XFRACAS data collections, incidents with a State Time of less than 0 are automatically set as invalid. These rows are shown in red.
Ignore: In XFRACAS data collections, incidents with a State Time of 0 that are marked as suspensions in the State FS column are automatically set to be ignored. These rows are shown in gray.
Exclude: Incidents that have been manually excluded are shown in blue.

By default, incidents that are marked as Invalid or Ignore will be excluded from the data set. To manually include or exclude specific data points, select the row(s) and choose Build Data Set > Include or Build Data Set > Exclude.

	Include
	Exclude

To view only those rows that are included, choose View > Show Only Included. You can toggle this command off to show all records.

In XFRACAS data collections, you can also select the row and choose Build Data Set > View XFRACAS Incident to open the incident in your web browser. This command is available only if you have permission to view incidents in the current XFRACAS entity (which is set via the XFRACAS administrative interface).

E-mail Link