Transcript Dream Report presentation
Ocean Data Systems
The Art of Industrial Intelligence
Dream Report®
Programming Free™ Designer Friendly™ REPORTING
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
The Professional Result in Short Time
Leader in Industrial Reporting Technology
Design report templates Connect to data sources Leader in Industrial Reporting Technology Generate reports Publish & Distribute reports
The Architecture:
Automatically Publish and Distribute
Web Portal File Server FTP Server eMail Printers Mobile
Generate and execute Design and configure • Design reports in easy environment • Use Page Templates • Use Report Templates
Automatically:
On Schedule
On Event
Provide Reports Design Reports Generate Reports Provide Data
Manually:
Select Report
Change period or select batch Generate new report
Configure Data Aggregation
Define and execute periodically any type of calculations
: Min, Max, Average, Current, Integral, Duration, Counter, SQL commands, free Mathematical Calculation… Connect to Data Sources • • Dream Report logger can archive
real time data
into any open database •
SQL Server
•
MySQL
•
Oracle Access …
Data Logger Provide Data Provide Data Real-Time Data and Alarms
REAL TIME data and alarms
- OPC DA-AE - Native Drivers Access existing 3-d party archives HMIs, PLCs, DCS, SCADA, … • • •
HISTORIAN DATA
OPC HDA ODBC & OLE CSV files Native drivers for proprietary archives
Leader in Industrial Reporting Technology
Connectivity
Open Communication Protocols: Direct Communication To HMI/SCADA: Direct Access to Custom Historians: Access to Open Databases: Leader in Industrial Reporting Technology
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
Runtime Environment
Runtime engine runs as a service Runtime Management Console – User Interface window Dynamic Report Generator as a window or ActiveX component Command Line User is able to generate also reports using: Web Portal External Data Source Leader in Industrial Reporting Technology
Web Portal
Leader in Industrial Reporting Technology 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, …
Dream Report on Mobile Devices
Dream Report Has Special Web Portal for Mobile Devices
Android
iOS
iPad
iPhone
Windows Mobile
User authentication
Access to all generated reports
Generate new reports
Use Interactive Dynamic Web Applications
Use Interactive Dynamic Web Applications
Use MANUAL DATA ENTRY FORMS!
Leader in Industrial Reporting Technology
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
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!
Leader in Industrial Reporting Technology
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
Redundancy
Two runtime engines can run in a couple in hot-backup mode:
Redundant servers will share: Connectivity to data sources Archiving data Generating reports
Sharing one database
Central Database
Using different databases
Main Server Backup Server
Leader in Industrial Reporting Technology
Main Server Backup Server
Dream Report ®
Leader in Industrial Reporting Technology
Engineering Tools
Engineering Tools
Virtual Report Instances
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
One Report Apply to multiple equipment Leader in Industrial Reporting Technology
Aggregation Data Filter
Build a Chart or Calculations on Prepared Aggregated Data
Define extraction mode for any object from any data source: (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
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
Database Archiving
Archive Aged Data and Keep it Ready and Available
Define maximum age for data in Dream Report database 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 File Server Binary archive files with aged data
Leader in Industrial Reporting Technology
Engineering Tools
Custom Archive Import:
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
SQL Server Dream Report Custom Archive Import CSV Excel Leader in Industrial Reporting Technology BACnet trend data
Ocean Data Systems
The Art of Industrial Intelligence
Interactive Reporting
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
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
Slide 23
Leader in Industrial Reporting Technology
Ocean Data Systems
The Art of Industrial Intelligence
OEE and Energy Reporting
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
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
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
Reports Examples
Leader in Industrial Reporting Technology
Dream Report
The Art of Industrial Intelligence
Advanced Manual Data Management
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
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
Ocean Data Systems
The Art of Industrial Intelligence
Integration Into External Applications
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
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 3 rd party application
Leader in Industrial Reporting Technology
Web Reports Integration – Dynamic URL
Integrate Dream Report web page into 3 rd 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
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
New Dream Report 4.6
Open new in DR 4.6 ppt
Ocean Data Systems
The Art of Industrial Intelligence