Individually, these products give you greater freedom to design, maintain and analyse your business data. Together, they form a powerful, integrated platform for budgeting and forecasting.

Why make do with static, two-dimensional extracts and reports when analysing business data, or spreadsheets when producing budgets and forecasts?

Affordable BI

Info-Explorer is a versatile, intuitive tool providing affordable Business Intelligence, with features normally only available to very large companies.

Gain in-depth insight into your true business performance, using current data. Explore many views from within a single cube, rather than relying on multiple reports. Change dimensions (e.g. product, customer, region, period, employee) for clearer insight, and identify trends or exceptions. Drill through to data entry screens for full detail, or keep it high level. Modify data and write it back to Sage 300 (or other databases).

Sample Cubes

Sample Info-Explorer cubes are provided, allowing you to get up and running quickly. They can also be used as a base for creating your own cubes.

Try Before you Buy

The "Lite" edition of Info-Explorer, available for free, lets you use pre-defined cubes to analyse your own data, as well as customizing cubes, graphs and dashboards.

Tip: Combine Info-Explorer with Process Scheduler to regularly refresh and distribute your cubes.

Custom data - within Sage 300

Optional Tables frees you from the limitations of the Sage 300 data model. Key business data normally stored and maintained externally can now be brought in from the cold and stored in custom data structures within your Sage 300 database. This might include KPIs, budgets, forecasts, actual results or non-financial data at any level.

You can also view and manipulate this data in Excel then write it back to Sage 300, or incorporate it into Info-Explorer cubes.

Budgeting & Forecasting

When it comes to budgeting and forecasting, the combination of Info-Explorer and Optional Tables are a match made in heaven. Click the image above to watch Anne's detailed demonstration

Sample Scenario

  1. Use the Optional Tables Spreadsheet Add-in to build a detailed bottom-up budget at the level you need, e.g. Customer & Item rather than just GL level, and store it in an Optional Table 'Infoset' within the Sage 300 database.
  2. Pull both the Optional Tables budget data and Sage 300 actual sales data into an Info-Explorer cube, and perform slice and dice analysis.
  3. Within the cube make a top-down budget adjustment, using a spread formula to apply the change to Customer and Item budgets.
  4. Use Info-Explorer’s write-back feature to update both the Sage 300 GL budget and the Optional Tables detailed budget fields.