Presentation Transcript

1. Ocean Data Systems The Art of Industrial Intelligence

   Dream Report® Programming Free™Designer Friendly™ REPORTING

2. Dream Report is: Dream Report is professional Designer-Friendly™ reporting software for industrial automation Open connectivity Real-time connectivity to SCADAs, HMIs, PLCs, … Connectivity to databases (SQL Server, MySQL, Oracle, …) Direct connectivity to proprietary historians Easy-to-use tool for non-programming users No programming or scripting No software development skills are required to design reports 2 Days training is enough to develop and maintain reporting Scalable All-In-One Solution No strong hardware or server OS requirements Produces PDF, Excel, Web, Database output Leader in Industrial Reporting Technology
3. The Professional Result in Short Time Leader in Industrial Reporting Technology
4. How it Works and What it Does: Publish & Distribute reports Generate reports Design report templates Connect to data sources Leader in Industrial Reporting Technology
5. The Architecture: Automatically Publish and Distribute Printers Mobile Web Portal File Server FTP Server eMail Provide Reports Generate and execute Manually: Select Report Change period or select batch Generate new report Automatically: On Schedule On Event Generate Reports Provide Data Design and configure Define and execute periodically any type of calculations: Design Reports ConfigureData Aggregation Design reports in easy environment Use Page Templates Use Report Templates Min, Max, Average, Current, Integral, Duration, Counter, SQL commands, free Mathematical Calculation… Provide Data Provide Data Connect to Data Sources Access existing 3-d party archives Data Logger Real-Time Data and Alarms Dream Report logger can archive real time data into any open database SQL Server MySQL Oracle Access … HISTORIAN DATAOPC HDA ODBC & OLE CSV files Native drivers for proprietary archives REAL TIMEdata and alarms - OPC DA-AE - Native Drivers HMIs, PLCs, DCS, SCADA, … Leader in Industrial Reporting Technology
6. Connectivity Open Communication Protocols: Direct Communication To HMI/SCADA: Direct Access to Custom Historians: Real-time Data Access to Open Databases: External Archives and Databases Leader in Industrial Reporting Technology
7. Reporting Development Environment Developer-friendly environment Integrated statistical objects Built-in statistic functions Template-based development No programming, no SQL scripts Charts Tables Widgets Pictures Leader in Industrial Reporting Technology
8. Runtime Environment User is able to generate also reports using: Runtime engine runs as a service Dynamic Report Generator as a window or ActiveX component Runtime Management Console – User Interface window Command Line Web Portal External Data Source Leader in Industrial Reporting Technology
9. Web Portal Security User authentication Access to predefined report list per user Accessibility Can be used in Internet and Intranet Is supported by all common web browsers Run on mobile devices (Android, iOS, …) Ergonomy Access any existing reports library Generate new dynamic reports Fully automatic. No web skills required Interactive reporting Easily create interactive web application Dynamic filtering, navigation, … Leader in Industrial Reporting Technology
10. Dream Report on Mobile Devices Dream Report Has Special Web Portal for Mobile Devices N E W !!! User authentication Android Access to all generated reports iOS Generate new reports iPad Use Interactive Dynamic Web Applications iPhone Use Interactive Dynamic Web Applications Use MANUAL DATA ENTRY FORMS! Windows Mobile Leader in Industrial Reporting Technology
11. Auto-Batch Reports Reports can be automatically generated at the end of a batch: By a command line By web URL command By real-time event (e.g. OPC, Modbus, …) Dream Report Leader in Industrial Reporting Technology
12. Secure Environment FDA CFR 21 Part 11 validation: User Management: Local or Windows-integrated user management Support Windows local or/and domain users and user groups Extended user access control to reports and modules Version Control Secure version ID stamp on reports Ability to roll back to the specific (certified) report version Track user changes in secure database Runtime is running as a service! DID YOU SEE THAT?!! Leader in Industrial Reporting Technology
13. Report Version Control Add secure object with report version on report page Every save of report modification increment its version Option to oblige developer to enter comments Ability to roll-back or roll-forward report to desired version Audit trail database with all versions information with: Date and time Report name and Version number User name User comments Leader in Industrial Reporting Technology
14. Redundancy Redundant servers will share: Connectivity to data sources Archiving data Generating reports Two runtime engines can run in a couple in hot-backup mode: Sharing one database Using different databases Central Database Main Server Backup Server Main Server Backup Server Leader in Industrial Reporting Technology
15. Dream Report ® Leader in Industrial Reporting Technology

    Engineering Tools

16. Engineering Tools Create report instances just by selecting different sets of tags No need to re-create reports Manage one report with multiple sets of tags as multiple reports Separate generation and distribution rules for each report template Virtual Report Instances One Report Apply to multiple equipment Leader in Industrial Reporting Technology
17. Aggregation Data Filter Define extraction mode for any object from any data source: Build a Chart or Calculations on Prepared Aggregated Data (e.g. Hourly averages, first 10 values, 100 values over period, any …) Build charts directly on key values Automatically works on all retroactive historical data Leader in Industrial Reporting Technology
18. Setpoint Analysis Automatic Setpoint Analysis and Results Calculation Start and End of stability zone Mark on a chart Start and End of stability Automatic stability process validation – Pass or Failed Calculate rate of change before/after stability Calculation and Display on a chart: Fastest/Slowest TC, All TCs Various rules for process validation Leader in Industrial Reporting Technology
19. Database Archiving Define maximum age for data in Dream Report database Archive Aged Data and Keep it Ready and Available All aged data will be recorded into binary archive files and deleted from Dream Report database When generating report, which requires aged data – it will be automatically loaded into the database, generate report and then remove it from the database again. Dream Report Database Generated reports Archiving aged data Auto-load of aged data for report generation Binary archive files with aged data File Server Leader in Industrial Reporting Technology
20. Engineering Tools Periodic automatic import of any external open or custom archive into a Dream Report database (e.g. SQL Server) Is not limited to a database – the tool is available for all historical drivers Available import by period (e.g. every 1 hour) or by absolute time Custom Archive Import: Dream Report SQL Server Custom Archive Import BACnet trend data CSV Excel Leader in Industrial Reporting Technology
21. Ocean Data Systems The Art of Industrial Intelligence

    Interactive Reporting

22. WEB Reports User is able to: Add dynamic generation and filtering controls directly to report Drop down list (List box) Button (action button) Date/time picker Hyperlink User can make filtering selections directly in report and see the result straight forward. Web reports do not create a document (file) for every generation The result is on the screen Leader in Industrial Reporting Technology
23. Web Reports Filtering capabilities for web reports: Combo boxes can be automatically filled with: List of tags for dynamic replacement User can in real time select tags, which will be used in report List of batch Ids for report generation User can in real time select Batch ID, which will be used for report Result of SQL query for filtering Predefined manual entries Text edit boxes can contain user manual entries Leader in Industrial Reporting Technology
24. Ocean Data Systems The Art of Industrial Intelligence

    OEE and Energy Reporting

25. Maintenance Reports OEE – Operating Efficiency Evaluation Reporting Dream Report has integrated built-in functions to calculate: Equipment Running time Equipment Down time On Counter / Off Counter System Availability Production KPIs Conditional calculations Leader in Industrial Reporting Technology
26. Proactive Maintenance Reports Automatic report generation and distribution upon calculated OEE data Generate and send report as soon up time reaches pre-defined value Generate and send service request upon equipment running time Let system analyze and control maintenance of your equipment for you! Leader in Industrial Reporting Technology
27. Energy Efficiency Reporting Display Energy Information Calculated information can be displayed as: Numeric value Dashboard Energy indicator Bar graph Chart Leader in Industrial Reporting Technology
28. Reports Examples Leader in Industrial Reporting Technology
29. Dream Report The Art of Industrial Intelligence

    Advanced Manual Data Management

30. Manual Data Entry Web Forms Define manual parameters (Names, types, validation rules) Add text box objects, combo (list) boxes and link them to corresponding manual parameters Build multiple data entry forms in a free way Also, build data correction and data validation forms Leader in Industrial Reporting Technology
31. Manage Manual Data Using Manual Data, User Can: Insert Manual Values Correct existing values Correct timestamp of existing values Validate existing values (either original or corrected) Do report on non-validated values only Do report on validated values only Do report on non-validated and validated values Leader in Industrial Reporting Technology
32. Integration Into External Applications Ocean Data Systems The Art of Industrial Intelligence
33. Command Line Report Generation Compile a Command Line in HMI or other external application Launch command line and generate report Report can be automatically open upon generation Dream Report will be used as invisible/transparent report generation platform Leader in Industrial Reporting Technology
34. Dynamic Report Generator as ActiveX Dynamic Report Generator can be integrated into external application User Interface as ActiveX User will see all reports tree, select report, time period and generate report directly from his native user interface Default time period can be pre-defined Perfect solution to use with any ActiveX container 3rd party application Leader in Industrial Reporting Technology
35. Web Reports Integration – Dynamic URL Integrate Dream Report web page into 3rd party web portal Generate and display result report using URL command only Pass dynamic time period and/or other multiple dynamic parameters using URL command or/and Web API So, user can user Dream Report as transparent report generation platform, seamlessly integrated into external web application Leader in Industrial Reporting Technology
36. Dream Report in Vertical Markets Top 8 Vertical Markets for Dream Report: Water and Waste Water Manufacturing & Batch Pharmaceutical & Chemical Energy and Facility Management Heat Treatment (Steel, aluminum, aerospace, …) Machine builders Oil and Gas Building Automation & BMS solutions
37. New Dream Report 4.6 Open new in DR 4.6 ppt
38. Ocean Data Systems Thank You! The Art of Industrial Intelligence