|
|
o2olap Technical Summary
|
Business Analysis and Reporting Solutions
o2olap extends Microsoft’s Analysis Services (OLAP) and SQL Server with
the new release of the market leading and innovative product "o2olap for Excel",
which integrates into Microsoft’s Office suite of products. "o2olap for Excel" 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). o2olap 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.
"o2olap for Excel" 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
"o2olap for Excel" 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 "o2olap for Excel". In addition, you can utilise the power of OLAP
using "o2olap for Excel", to improve the effectiveness of decision-making by helping
organisations understand their financial information.
Business intelligence solutions built using "o2olap for Excel", 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 "o2olap for Excel" Executive Information System (EIS) development environment, provides
for rapid application development (RAD).
"o2olap for Excel" 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 o2olap for Excel:
- 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.
|
|
|