Software Toolbox Corporate Home

 

 

 

 

Dream Report

Designer Studio - Data Extraction

Advanced data extraction from HDA sources with the Aggregated Data Filter tool: Connect to any external HDA data source and do a smart retrieval of key values or smart aggregation from any proprietary data source. For example, the user can retrieve the first 10 samples of every hour, or the average value of each day.

Automatic Data Extraction Through Drag-and-Drop Dynamic Objects: One of the major benefits of the product is about its ability to offer an easy method to extract statistics from all data sources without programming, defining SQL macros or complex scripts. Intuitive dialog boxes enable users to configure objects in minutes.

ItemSingle

Single Data: This object extracts the Last value, the Current value, the Minimum, Maximum, Average, Weighted Average, Sum, Integral, and Standard Deviation. It can also extract a specific Timestamp, the System Availability, the Up Time, the Down Time, and the Duration of any processes.  A user can directly create Counters, create a SQL query, evaluate an expression, and more.

ItemCompound

Compound Data: This object performs analytical calculations between the results of two or more other statistical or analytical fields in a give report. For example, you can calculate the Minimum, Maximum, Average, Sum, or Standard Deviation of multiple items.

ItemExpression

Expression Data: This object accepts a manually entered expression involving one or more statistical object, mathematical operator, or constant.

ItemTable

Item Table: This object displays historical values in a predefine table. Users can select one or multiple Items and define filters, if needed, to display only specific values.


AlarmTable

Alarm Table: This object displays Alarms and Events from the history in a predefine table. Users must first create their alarm filters, and then select the ones they want to display in each alarm table.


SQLTable

SQL Query Table: The SQL table enables automatic creation of a custom table with all the desired fields by directly inserting an SQL Query. Indeed, once the SQL Query is done Dream Report automatically creates the table for you.


StepTable

Step Table: The Step table extracts and displays statistical values for any period in a convenient table. The user selects the time period and the step. For example, the user could request the Min, Max and the average value for the temperature for each day during last month.

AST

Automatic Statistical Table: This calculates numerous statistical functions and displays them in a table for easy viewing and analysis.


Pie

Pie Graph: The Pie Graph compares multiple statistical values or alarms filters in a pie chart format. Display options can automatically insert the %, the unit, the legend and the values for each segment.


Bar

Bar Graph: Like the step table, the Bar Graph is used to display statistical values or alarm filters in a column or bar graph format. Different representation modes like Bar, Single Column and Pareto help to highlight results.


Chart

Chart: The Chart object displays values, moving average values, Linear and power regression. It is also possible to display XY charts, mix bars and trends. The user can also define different scale options to easily compare results from the same or different time periods.

SimpleTable

Draw Table: The Draw, or Free Table object combines different static and dynamic statistical objects into a single table. It is a user configurable open table. For example, the user could combine a static text object, a date/time object, and a Compound and Expression Data object in one table.

Indicator

Indicator: This object allows the user to add Energy, Water, Eco, or custom indicators.

DateTime

Date and Time: This object displays a dynamic date and/or time in the desired format with a pre-defined offset, if needed. This field contains the date and/or time that the report was generated.

PageNumber

Page Number: The Page Number object allows a user to display the number of the current page or the total number of pages in a report.

DynamicText

Dynamic Text: This object enables users to display text in a report, where the value will be determined during the report generation. For example, the Dynamic Text can display the report name, the project name, current user, report instance name, a version ID, and more.

Signature

The Electronic Signature: This feature provides the user the ability to electronically sign generated PDF reports, allowing them to meet regulatory requirements for certain industries

Legal Notices
Sitemap

Privacy
Search

P: 1-888-665-3678 (US) or +1-704-849-2773 (Global), F: +1-704-849-6388
148A East Charles Street, Matthews, North Carolina, USA 28105
© Copyright Software Toolbox, Inc. 1996-2011, All Rights Reserved Worldwide.
Dream Report is a trade mark of Ocean Data Systems