Business Analysis and Reporting Solutions

OLAP Office™ extends Microsoft’s Analysis Services (OLAP) and SQL Server with the new release of the market leading and innovative produc t "OLAP Office Explorer™", which integrates into Microsoft’s Office suite of products. "OLAP Office Explorer™" is the first in a set of next generation, OLAP solution toolkits for users to develop and maintain their Analysis Services and executive information system (EIS) solutions without having to know any Microsoft Multidimensional Expression (MDX) Language or Visual Basic for Applications (VBA). OLAP Office Explorer™ was designed to meet Microsoft Analysis Services user needs and wants, improve user efficiency and to leverage the market leading functionality available in Microsoft’s Analysis Services and Office suite. "OLAP Office Explorer™" integrates seamlessly into Excel, significantly improving user productivity, collaboration and access to Analysis Services cube data and other organisational information.

----Cubes ------ Dynamic Data ------ Multidimensional Reports

"OLAP Office Explorer™" improves an organisation’s business intelligence to give it a competitive advantage by empowering workers to have information at their fingertips through the familiar Microsoft Excel reporting environment. Workers can make better and faster decisions more effectively, by streamlining information, gathering and analysis using "OLAP Office Explorer™". In addition, you can utilise the power of OLAP using "OLAP Office Explorer™", to improve the effectiveness of decision-making by helping organisations understand their financial information.

Business intelligence solutions built using "OLAP Office Explorer™", in combination with Microsoft’ Analysis Services, SQL Server and Office, provide the ability to integrate and deliver valuable information in structured personalised views to users in a fraction of the time taken by other OLAP offerings. This, combined with the "OLAP Office Explorer™" Executive Information System (EIS) development environment, provides for rapid application development (RAD). 

"OLAP Office Explorer™" has a logical Excel interface, allowing users to generate and maintain Microsoft Analysis Services objects, as well as allowing users to browse, interrogate and slice cube data into dynamic, multi-dimensional worksheets.

15 Reasons for OLAP Office Explorer™:

• Give Finance the tools they need and still get all the benefits of a Microsoft Architecture.
• Explore, slice and dice and summarise data in an ad hoc, intuitive manner that has a dramatic effect on productivity.
• The Excel browser requires no MDX knowledge for cube browsing and report generation. The browser includes ad hoc member selection and ordering, ranking, sorting, exception reporting, querying, etc.
• Consistently formatted output using a template approach.
• Efficient data capture, writeback and modelling environment using Microsoft Excel.
• Allocations using various methods, helps to streamline the budgeting and forecasting process.
• Drillthrough and flexible dimension drilling options.
• Rapid Excel and FrontPage EIS development environment that integrates with the award wining help authoring tool, RoboHelp.
• Circulate customised reports and storybooks for managers throughout the enterprise without needing IT assistance.
• Journaling and commenting for multidimensional data.
• High performance and flexible Analysis Services model development.
• Multi-lingual applications.
• Querying (no MDX), data mining and report generation options.
• Low cost of ownership.
• Actions and closing the analysis loop.
• Improved management and documentation of OLAP Information.

OLAP Office Explorer Version Compatibility

• Excel Versions
  • 2003
  • 2007
  • 2010

• SQL Server & Analysis Services
  • 2008
  • 2005

Note: There is a free version for anyone that works with SQL Server 2000