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
Publish &
Distribute reports
Generate
reports
Design report
templates
Connect to
data sources
Leader in Industrial Reporting Technology
The Architecture:
Automatically Publish and Distribute
Web Portal
File Server
FTP Server
eMail
Printers
Mobile
Provide Reports
Generate and execute
Manually:
Automatically:
Generate
Reports
 On Schedule
 On Event

Select Report

Change period or select batch

Generate new report
Provide Data
Design and configure
• Design reports in easy environment
• Use Page Templates
Design
Reports
Configure Data
Aggregation
• Use Report Templates
Provide Data
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
Real-Time
Data and Alarms
Leader in Industrial Reporting Technology
Define and execute periodically
any type of calculations:
Min, Max, Average, Current, Integral,
Duration, Counter, SQL commands,
free Mathematical Calculation…
Access existing
3-d party archives
REAL TIME
data and alarms
HISTORIAN DATA
OPC HDA
- OPC DA-AE
•
ODBC & OLE
- Native Drivers
•
CSV files
•
Native drivers for
proprietary archives
HMIs, PLCs, DCS, SCADA, …
Connectivity
Open Communication
Protocols:
Direct Communication
To HMI/SCADA:
Access to
Open Databases:
Leader in Industrial Reporting Technology
Direct Access to
Custom Historians:
Reporting Development Environment
Charts
Tables
Leader in Industrial Reporting Technology

Developer-friendly environment

Integrated statistical objects

Built-in statistic functions

Template-based development

No programming, no SQL scripts
Widgets
Pictures
Runtime Environment
Runtime engine runs as a service
Runtime Management Console –
User Interface window
Dynamic Report Generator as a
window or ActiveX component
User is able to generate also reports using:
Command Line
Web Portal
Leader in Industrial Reporting Technology
External Data Source
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
Dream Report on Mobile Devices
Dream Report Has Special
Web Portal for Mobile Devices
 Android
 iOS
 User authentication
 Access to all generated reports
 Generate new reports
 iPad
 Use Interactive Dynamic Web Applications
 iPhone
 Use Interactive Dynamic Web Applications
 Windows Mobile
 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
Using different databases
Central
Database
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
File Server
Auto-load of aged data
for report generation
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
Dream Report
SQL Server
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 3rd party application
Leader in Industrial Reporting Technology
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
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
Thank You!