OLAP Excel
Excel OLAP - O2 OLAP for Excel
BUY | O2OLAP for Excel Start
Microsoft Analysis Services (OLAP) and SQL Server are outstanding products
but lack some key capabilities for finance and analyst users such as spreadsheet
modelling, freeform reports and write back. O2 OLAP for Excel overcomes these limitations,
allowing users to take advantage of the inherent architectural and commodity cost
benefits of Microsoft technologies. New market leading functionality enables users
to create executive information systems (EIS) without having to write or support
a macro.
Microsoft Excel OLAP
The combination of Microsoft technology and o2olap for Excel makes
a compelling solution for financial reporting, management reporting, financial consolidations,
currency translations, budgeting, planning, forecasting, executive information systems
(EIS), data mining and data warehouse solutions.
O2 OLAP for Excel provides a comprehensive toolset that extends the
Microsoft's Analysis Services (OLAP) and SQL Server environment to make it suitable
for use by finance professionals for business analysis and reporting.
Considerable performance gains have resulted from new market techniques
being employed within this new release. O2OLAP for Excel 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!
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
O2OLAP for Excel 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 O2OLAP for Excel. 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
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.
- Ability to easily produce customised storybooks with out coding that enable
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
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 the Excel objects development environment that no Visual Basic
for Applications (VBA) macros are required. Executive information systems (EIS)
are a synch 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 the Microsoft Office suite.
>>
Business Analysis and
Reporting Solutions | >>
Microsoft
SQL Server Analysis Services
Special !
Free Choice of
Complete Excel
Training Course or
Excel Add-ins Collection
on all purchases totaling over $70.00. ALL purchases totaling over $150.00
gets you BOTH! Purchases MUST be made via this site.
Send payment proof to special@ozgrid.com 31 days after purchase date.
O2OLAP for Excel
$850.00
Payment Problems/Options
Visit Developers Site for Free
Download. Purchases MUST be made via this
site for free software!
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package
Technical Analysis in Excel With $139.00 of FREE software!