OLAP Office Explorer Feature Summary PDF Print E-mail

Considerable performance gains have resulted from new market techniques being employed by OLAP Office Explorer™. OLAP Office Explorer™ is the fastest Excel based OLAP reporting toolset for Microsoft’s Analysis Services, as well as the fastest Excel based browser on the OLAP market today! Why not apply for a trial of OLAP Office™ now. Click here

Enhancements Include:

  • Improved data collection and writeback functionality. New techniques employed allow for faster retrieval and loading of data to Microsoft’s Analysis Services.
  • Improved budgeting and forecasting techniques. New functionality added to OLAP Office™ Explorer allows for users to quickly model, create, allocate, update and consolidate budget and forecast information. Also included, are improved techniques in managing and controlling this whole process.
  • Improved multiple hierarchy control. New techniques available allow for a more controlled and streamlined approach to the maintenance of multiple hierarchies within an OLAP environment. This is particularly pertinent within a financial reporting environment where it improves data integrity and reduces reconciliation.
  • Extended modelling capabilities. New functions have been added to extend the modelling functionality within OLAP Office Explorer™. You do not have to be limited to a static matrix approach for OLAP reports. As always, you can model and browse information from more than one cube in a report.
  • Extremely flexible

Key Features:

  • An Excel based browser that provides highly flexible analysis and exploration capabilities including ad hoc summarisation, which is optimised for financial users.
  • Provision of modelling capabilities through the inclusion of spreadsheet writeback and input journals.
  • What-If functionality.
  • Ability to easily produce customised storybooks without coding that enables non technical users to view and manipulate data in an attractive and intuitive manner.
  • Rapid report production incorporating text, tables and graphics with consistent formats using templates.
  • Key Performance Indicators with hundreds of graphics
  • Spark graphics engine
  • Centralized settings and reporting pack creation.

Benefits to Users:

  • Provides the fastest way to deliver Microsoft Analysis Services (OLAP) solutions, information and reports to an enterprise. No MDX is required to generate a data view.
  • Provides business intelligence out of the box with the power of improving business knowledge management.
  • Integrates and streamlines the management, consolidation, budgeting, planning, forecasting and data analysis reporting environments for a competitive advantage.
  • Helps in successfully producing and analysing enterprise data and using that data to make key business decisions.
  • Provides an Excel objects development environment that requires no Visual Basic for Applications (VBA) macros. Executive information systems (EIS) are a cinch with this rapid application development environment (RAD).
  • Enables data capture (writeback), entry and analysis through power Excel objects for the Microsoft's SQL Server and Analysis Services (OLAP) cubes.
  • Helps data mining and presenting your data warehouse solution information for data analysis. Enables Finance to develop applications without high levels of technical knowledge or coding.
  • Completely consistent with a Microsoft centric IT strategy and enables IT to have an appropriate level of control over Finance activities, without inhibiting effectiveness.
  • Low cost through the use of Microsoft technologies.
  • Enhanced openness and integration with existing applications such as the Microsoft SQL Server and Office suite.
 

Newsflash

Start on the right foot, not the back foot when choosing a solution provider.
Talk to OLAP Office™
Start on the right foot, not the back foot when choosing a solution provider. Talk to OLAP Office™

Affiliates Earn 40%

Earn up to 40% commission on your sales and 10% commissions on any affiliate's sales you introduce. Through our Affiliate Marketing Center we provide access to all the marketing material you need to sell our products online and earn affiliate commissions. click here to join for free

Vision

The two most important days in your life are the day you were born and the day you knew why. – John Maxwell.