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.

	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.
	Compound Data: This object performs analytical calculations between the results of two or more other statistical or analytical fields in a given report. For example, you can calculate the Minimum, Maximum, Average, Sum, or Standard Deviation of multiple items.
	Expression Data: This object accepts a manually entered expression involving one or more statistical object, mathematical operator, or constant.
	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.
	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.
	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.
	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.
	Automatic Statistical Table: This calculates numerous statistical functions and displays them in a table for easy viewing and analysis.
	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 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: 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.
	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: This object allows the user to add Energy, Water, Eco, or custom indicators.
	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.
	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
	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.
	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.