AccTech Advanced Analytics Application(A3) for Sage 300cloud ERP and Sage ERP X3

For most companies a data warehouse is an essential component to extract data from various source systems to get a holistic view of financial and other business critical information.  In most cases designing and implementing a data warehouse can be expensive and out of reach for many companies. With AccTech Advanced Analytics(A3) you can dynamically build an optimised data warehouse in a few easy steps.

The A3 “Smart Solution” enables self-service reporting from ERP source systems including Sage 300cloud ERP (Accpac) and Sage ERP X3 by creating a data warehouse and the ETL processes. Transform the data from your ERP system into friendly data structures, empowering users with advanced analysis capability using a Business Intelligence tool of their choice.

The AccTech Advanced Analytics Application is a server based application designed to dynamically build an optimised data warehouse for the Sage ERP Products and other related solutions. With minor configurations it can be used to access other solutions and data sources outside the Sage ERP Product.

Simplify, Automate and Optimise Source Data

AccTech Advanced Analytics Application DIAGRAM


A³ application features and benefits

  • Optimised ERP data warehouse
  • ETL Processes
  • Increased speed and efficiency
  • Punctual Task and Process Scheduling
  • Eliminate data duplication (Normalisation)
  • Field format correction
  • Adds Date and Time Dimensions
  • Improved Data Quality
  • Enables Self Service Reporting Capabilities
  • Account Mappings and level groupings within the application
  • Enhanced Security
  • Optimised Aggregation and Consolidation
  • A wide range of Business Intelligence / Reporting tools can be used to report on the data warehouse
  • Write back to data warehouse from Microsoft Excel

Features Specific to Sage ERP X3

  • Advanced Date & Time dimensions added to the data warehouse
  • Budget Pyramids in Sage ERP X3
  • Optimise transactional data from Sage ERP X3 ledgers
  • Can connect to multiple schemas or Sage ERP X3 Folders
  • Backdated reporting requirements
  • Multiple companies, multiple ledgers
  • Simple 4 step process to create a standard data warehouse
  • Import and export features for account mappings
  • Variable calendar year lengths/number of periods within companies (change of financial year end)
  • Different dimension structures for companies
  • Multi-currency capability
  • Aggregated reporting
  • Catered for all budget sets/types
  • Custom structure and table builder for data sources
  • Write back to data warehouse from excel

Features Specific to Sage 300cloud ERP

  • Multiple companies
  • Data formatting
  • Associations / relationships defined
  • Date and time dimensions standard in the data warehouse
  • Optimised & Normalised data tables, fields & structures
  • Import & Export features for account mappings
  • Enables Self-Service Business Intelligence
  • Optional fields (segment or transactional level), accounting segments, multiple companies, selected modules
  • Different accounting structures between companies is provided for company or aggregate reporting


A3 Initial Setup