Skip Navigation Links

ERM-IO360 Business Intelligence

AQIES IO360-BI provides powerful business intelligence tools
that offer self-service access to both data and intuitive
information analysis, helping users turn business insights into
effective decisions.


User Portal and Dashboards

IO360-BI offers a user-defined decision support portal and dashboards, providing users with actionable, up-to-the-minute graphical representations of key statistical information such as revenues and equipment usage.
The IO360-BI user portal enables each user to create a personalized management Dashboard for real-time tracking of the indicators most pertinent to his task. General or detailed information appears in the form of graphs, tables, or organized in a calendar,
with links making it possible to follow the entire security audit trail up to the information details.
Dashboards can help boost profits by providing instantaneous access to key company data, allowing management to react quickly to changing business conditions. Users can monitor the relevant indicators for their activity in real time and focus on anomalies.
In case of an unusual event or level of activity, it takes no longer than a click on the given indicator to move back by successive zoom operations to the detailed information or the original document explaining the result in order to make a wellinformed decision.



Advanced Business Intelligence Engine and Data Warehouse

Powered by leading OBIEE technology, Business Intelligence is fully integrated within the ERM360 system. It functions seamlessly in sync with the day-to-day business operations being processed by ERM360. It does not require maintenance of a separate data warehouse, and the integrated Business Intelligence data warehouse is fully managed–and kept up to date–as part of the ERP software system. Like all ERM360 functions, Business Intelligence is a web-native feature that may be accessed in the same fashion using a simple web browser, locally, or over a network such as the Internet.

Sales Map

Sales Map1

Powerful Query and Reporting

IO360 Business Intelligence allows users to analyze business performance on the fly by simple drag and drop of aggregated data that are updated with the flow of ERP operations. With a few mouse clicks, users create a query from scratch, format the retrieved information, and easily analyze it to understand underlying trends and root causes. And if they don't require the full power of query capabilities, users can simply explore information in existing reports–formatting and interacting with data to meet specific needs.

Preconfigured Answers(Metadata)

While a set of preconfigured Business Intelligence Answers covers most users' needs for advanced business statistics and indicators, IO360-BI provides the tools and information to build custom reports about any area of business.
Preconfigured Business Model notably include: Sales, Purchasing, Inventory, Manufacturing, and Finance.



Secure Access to Data

Designed as a fully integrated ERP function, Business Intelligence benefits from the highest level of security management that can be expected from an ERP solution. Security is controlled and managed at the ERP system level for all users and can easily be defined at the function, screen, and/or field level.

Simple Interface for Users

With IO360 Business Intelligence, users can access and format information to suit their needs with an easy-to-use, drag-and-drop web interface. And you can customize the web interface to meet specific user segments inside and outside of the organization. In addition, with minimal knowledge of the underlying data structures, users can access and synchronize data from multiple sources (whether structured,text-based, or even Microsoft® Excel® spreadsheets, CSV, and.txt files), create custom formulas, and use variables within a single report.

Within their web browsers, Business Intelligence users can:

  • View report metadata
  • View, edit, remove report, section, or block filters
  • Format and resize cells, tables, and charts
  • Recombine report objects and variables in tables and charts
  • Set breaks and sorts
  • Insert calculations
  • Add rows and columns to tables
  • Create and duplicate tables and charts
  • Turn a grid into a chart or a chart into a grid
  • Create formulas and variables
  • Edit cell formulas in place
  • Create/Manage their own Dashboards
  • Schedule reports for auto mail/Fax.
  • Export the reports to excel,word,csv,txt.




Integration with Microsoft Office®

Integration with Microsoft Office allows users to export and manipulate data in Office standard format, without losing the accuracy and consistency provided by the single, up-to-date database of the ERP system.

Features and Functions
  • User-defined triggering events for updating statistics in batch or real time
  • User-defined statistical codes and grouping Multidimensional analysis, accumulates amounts and quantities, user-defined periods (day, week, month), progressive zooming to event source.
  • Integrated business intelligence engine OBIEE
  • Web Intelligence
  • Integrated Data warehouse and ETL process
  • Supports multiple import/export formats such as structured, text-based, or even Excel spreadsheets, CSV,and .txt files
  • Web-browser interface
  • Simple query based on configurable Business Models(answers)
  • Preconfigured Business Model include:
Sales: Revenue; discount; margin; volume; item; line of business;
best-selling products; most profitable, seasonal trends;
geographic coverage; and more

Purchasing: Suppliers; products purchased by price, discount, volume, or number of orders; and more
Inventory: Stock movements by product, value, or quantity; top variations by period; receipts and shipments by product and period; rate of rejected items by product, category, product line,and/or supplier; and others

Manufacturing: Late work orders by period, average work order duration, work center efficiency, occupation rate, rejected product rate per period, material consumption, and others
Finance: Analyze and track costs at all levels (drill down and up from an aggregate level following dimension groupings), control actual vs. forecast, develop week/month/quarter analysis for internal/external reporting, and more .