- This article was considered for deletion at Wikipedia on April 25 2014. This is a backup of Wikipedia:Dream_report. All of its AfDs can be found at Wikipedia:Special:PrefixIndex/Wikipedia:Articles_for_deletion/Dream_report, the first at Wikipedia:Wikipedia:Articles_for_deletion/Dream_report.
- The topic of this article may not meet Wikipedia's general notability guideline. But, that doesn't mean someone has to… establish notability by citing reliable secondary sources that are independent of the topic and provide significant coverage of it beyond its mere trivial mention. (April 2014)
Dream Report is a business intelligence application specifically developed for industry, currently marketed to discrete, hybrid and process industries by Ocean Data Systems ltd. It is used to design and generate and distribute reports from a wide range of data sources.
Report generation in industry differs greatly from report generation in business. The differences fall into several areas; connectivity to industrial data sources, analysis functions common to industry, ease of use - designed for process engineers, and 24x7x365 reliability. While report generators for industry can also be used for business reporting, business reporting tools are challenging to apply in industry as they require integration with additional solutions in order to meet industrial requirements.
Industrial requirements include:
Connectivity - Industrial data sources fall into three categories - real-time data, alarm data and history data. Industrial products typically support a combination of proprietary interfaces and automation industry standards. A reporting solution for industry will include support for these various interfaces in addition to the typical interfaces within business systems. Proprietary interfaces are typically enabled by industry vendor tool-kits. Industry interface standards include Modbus, BACnet, OPC Foundation - OPC DA, OPC AE and OPC HDA. Business standards include OLE-DB, ODBC, Comma-separated values (CSV) files, and Microsoft Excel workbooks.
Specialized Data Sources - Leading industrial data sources include Data recorders, Programmable Logic Controllers (PLCs), Process Automation Controllers (PACs), Human Machine Interfaces (HMIs), Supervisory Control and Data Acquisition Systems (SCADA), Historians, Distributed Control Systems (DCS), Manufacturing execution systems (MES) and Enterprise Asset Management (EAM) systems.
Specialized Calculations - Industrial analytics and reporting requirements will vary from business analytics. Needs will vary by market. In the pharmaceutical industry industry, reporting systems must offer support to meet the regulations of 21CFRPart11 (Book 21 of the Code of Federal Regulations, Part 11). This entails requirements to meet activity audit trails, report security and electronic signatures to capture user updates and actions. The Life Sciences industry also required specilized calculations for Chamber Validation and Lethality F0. In manufacturing, there are standard calculations to calculate run-times, Overall Equipment Effectiveness (OEE), Downtime, Totalizations, and Energy Audits. In industries requiring heat treat chambers, there are common requirements for Thermal Uniformity Surveys (TUS). The support for these specializations are unique to report generators designed for industry.
Data Presentation - The formatting of data into visual representations is also an area of differentiation. The industrial automation marketplace is dominated by products that are configurable and that require very little specialized knowledge in terms of training and operation. This requirement exists for two reasons; 1) automation systems are typically implemented and then transition into operation and are updated infrequently, and 2) users of these systems are typically process engineers - experts in the process that is being automated, and they benefit most from systems that exhibit a major focus on ease of use. For this reason, display objects are typically configured through menus rather than scripted or relying on programming languages.
Distribution - Report delivery is also highly automated. Typical requirements include Printer Redundancy (engineering) (primary and backup printers), automatic report emailing, report distribution via File Transfer Protocol (FTP), and report display in Web Portals.
Dream Report is the product of Ocean Data Systems Ltd. a company headquartered in Lyon, France and having offices in the Ukraine, USA and Israel. Ocean Data Systems (ODS) was founded in 2005 and initially delivered Dream Report in 2006. As of 2014, Dream Report has been through over 18 version releases and is installed in over 5000 locations. Ocean Data Systems primarily markets its products through OEMs, companies that will brand and resell Dream Report as an extension of their product portfolio and through their channels (direct sales, distributors and representative companies). Major OEMs include Wonderware, Eurotherm and Indusoft (owned by Invensys and now Schneider Electric), Arc Informatique, among others.
Operation as a service
Dream Report operates as a service and in the background on both Workstation and Server versions of Windows. In normal operation, Dream Report is not visible to the user. Dream Report delivers a Run-time Management Console, both as a stand alone application and as an Active-X Control for embedding in other applications (like industrial control software solutions). The Run-time Management Console is used to manage both local and remote instances of Dream Report.
Supported data sources
- Databases such as Microsoft Access, Microsoft SQL Server, MySQL, and Oracle
- Spreadsheets such as Microsoft Excel
- Text files
- Industrial Automation Software solutions by Wonderware, Eurotherm, InduSoft, Rockwell Automation, Siemens, OSI Software, Aspen Technology, Yokogawa, Mitsubishi, Schneider Electric, and many more. Dream Report's support for the OPC Foundation Standards (www.opcfoundation.org) enables connectivity to virtually all automation solutions, when direct and proprietary interfaces have not been implemented. As of 2014, Dream Report includes over 64 data source interfaces.
- General Manufacturing - Batch Reporting, Production Reports, Quality Reports, Downtime Reports, Overall Equipment Efficiency Reports, Shift Production Reports, Scrap Reports, Key Performance Indicator Reports
- Building Automation - Building Efficiency Reports, Energy Use Reports, Utility Reports, Tenant Billing Reports, Energy Performance of Buildings Directive (EPBD) Reports, Leed EBOM-2009 EAc3.1 Reports
- Heat Treat Industry - Thermal Uniformity Survey (TUS) Reports, Energy Reports, Batch Reports, AMS 2750E - CQI-9 - AMS 2770 - NADCAP Standard Reports
- Life Sciences - Production Reports, Validation Reports, Audit Reports, Batch Reports
- Water - Pumpage Reports, Turbidity Reports, Chemical Usage Reports, Usage Reports, Water Distribution Reports, Monthly Operating Reports
- WasteWater - Discharge Reports, Monthly Operating Reports (MORs), State and Federal Environmental Protection Agency (EPA Reports)
Dream Report is developed specifically for reporting in industry. This includes the markets of Aerospace, Automotive, BioTech, Building Automation Systems (BAS), Chemicals, Consumer Package Goods, Food and Beverage, Metals and Mining, Pharmaceutical, Textiles, Transportation, Power Generation and Distribution, Oil and Gas - upstream and downstream, Utilities, Water and Wastewater.
- Wonderware (HMI Reports)
- Eurotherm (Dream Report)
- ARC Informatique (Dream Report)
- Indusoft (Dream Report)