Orchid Info Explorer
For Sage 300
A powerful, affordable BI tool supporting integrated analysis & budgeting.
Analyze business performance in multi-dimensional cubes, with the familiarity of a spreadsheet-type layout. Combine data from multiple sources. Ideal for integrated analysis and budgeting.
Play Video
Gain in-depth insight into your business performance
- Slice & dice current data in a single cube
- Drill-through to Sage 300 screens
- Try the Lite edition for free, with no time limit and no commitment
- Analyze business performance, identify trends and exceptions
- Use the same tool to prepare detailed budgets and forecasts
- Budget with greater insight & detail, combining actual and budget data
- The familiarity of a spreadsheet-type layout, without the limitations
- No need to rely on static, two-dimensional extracts, or multiple reports and spreadsheets
Key Features
Data Sources and Processing
- Fed from your Sage 300 database, with background in-memory processing
- Include data from other SQL & ODBC databases, e.g. your CRM
- Incorporate user-defined calculations
- Work online or offline
- Export views to Microsoft Excel®, CSV or HTML
- Security options to protect your data
Slice and Dice Analysis
- Change dimensions (e.g. product, customer, region, period, employee) for clearer insight
- Dynamically control your view, filter your data, add and remove facts and dimensions
- Drill through to Sage 300 data entry screens for more information
- Roll up and consolidate to focus on high-level results
Presentation and Personalization
- Create and save multiple views, and convert to charts
- Create your own dashboards, highlighting exceptions and trends
- Apply your own formatting styles, e.g. 'traffic light' reporting
- Personalize, e.g. use custom styles to highlight amended data
Budgeting Features
- Budget beyond General Ledger level
- Build budgets bottom-up or top-down
- Insert a budget total and let Info-Explorer populate the build-up
- Adjust budgets using multiple spread methods
- Maintain multiple budget versions
- Write budget data back to your Sage 300 database
- Combine actual and budget data for forecasting
Sample Cubes Included:
- Sage 300 GL, AR, AP, PO, PJC, IC, OE/Sales Analysis
- Sage 300 US & Canadian Payroll
- Orchid Extender, RMA, Bin Tracking
- Budgeting
- Selected 3rd party products
Info-Explorer Editions
Info-Explorer Lite (Free)
A free, functional edition – no time limit, no commitment:
- Analyze yourown data with pre-defined cubes (published on the Orchid website)
- Customize cubes, graphs and dashboards (but not the underlying data queries)
- No need to upgrade, unless you want the additional features.
Info-Explorer Standard
Includes Lite edition features, plus:
- Create new cubes
- Create new data queries (or amend existing ones)
- Export cube data
Info-Explorer Writeback
All Standard edition features, plus:
- Writeback to Sage 300 (or other SQL and ODBC databases)
- Budgeting
- (see Budgeting Features above)