PowerOLAP Version 9.0 - Intelligent Performance Management for your business
PowerOLAP® has been
dramatically empowered in
the latest release, Version 9.
The highlight of this release is a
64bit Server Platform. The 64bit
platform removes restrictions on
functionality such as memory
usage and database size,
maximizing your performance and
enabling you to query the largest
data sets with the most complex
multidimensional analytics.
Many PowerOLAP® features have
been optimized to save you time
and energy including the caching and
dependency functions, integration with
MS Analysis Services, as well as save
and load performance for opening and
saving databases. For import and
export functions, limitations have been
eliminated, and the Scheduler and
Tasks routines can now be executed
through Excel. IDS features have
been enhanced to support write back
and to provide clientless access to
PowerOLAP® Data--in both Google and
via Mobile PowerOLAP.
Highlights of Version 9
that clients will love
PowerOLAP and OutlookSoft
PowerOLAP now allows users with
existing investments in OutlookSoft
to easily migrate to PowerOLAP
to perform their consolidation
and planning functions with writeback
capability. PowerOLAP will
deliver a faster, more flexible, more
agile and cost-effective platform,
without any costly ERP upgrades.
PowerOLAP and
Analysis Services
Build robust and dynamic cubes
for budgeting, planning and
forecasting, leveraging the data
that you already have in Analysis
Services. PowerOLAP allows you
to overcome the current write-back
limitations in Analysis Services.
You can now plan for the future, not
just analyze the past. We integrate
using Analysis Services 9.0 Driver,
allowing connection to AS 2000,
2005 and 2008. Integration is
optimized using dynamically written
MDX queries. This offers significant
performance improvements by prequerying
the values from Analysis
Services. No other product does
a better job filling the Planning
gap left with the elimination of
MSAS PerformancePoint.
Scheduler
The Scheduler functionality originally
introduced in V8 has now been
enhanced to fully automate the
kick-off and scheduling of tasks
across ALL applications you are
running given our exposed API.
Scheduler lets you add, edit and
delete tasks for scheduled execution.
Notifications provide feedback
on the execution of tasks. The
task and scheduler routines can
now be executed from Excel.
V9 Enhancements: 
• Increase in maximum thread
handling capabilities
• Improved performance in
saving and loading data
• More intelligent caching,
dependency clearing and
regeneration
• Clearing of cache only when
it must
• Reduction of dependency
regeneration
• Drill through has been
optimized to query fewer
points from relational
databases
• OLAPQuery function in Excel
now supports write-back to a
PowerOLAP Cube
Enhanced Functionality
in Version 9:
Internet Data Services (IDS)
IDS allows for the widespread
deployment of the PowerOLAP solution
to muliple, dispersed locations across
the web. The web interface provides
easy access to PowerOLAP data
via a standard web browser, taking
advantage of PowerOLAP as an
HTTP Server. IDS web functionality
now supports write-back capability.
Google and PowerOLAP for
Reporting
Given the new IDS functionality,
users have the ability to perform
OLAP manipulations with real-time
organizational data, using Google’s
free spreadsheet as your front end.
This gives users a fast, efficient and cost effective report publishing and
distribution platform for free and
powered by the speed and flexibility
of the PowerOLAP solution.
Mobile PowerOLAP
Web access to PowerOLAP gives
users access to reports, budgets,
forecasts on your PDA (including iPhone and Blackberry). Access to
important real-time business data
immediately, when you need it.
Excel Pivot Tables and PowerOLAP
Access to PowerOLAP data via
the web, with Excel Pivot Table
front end, provides a clientless
zero install, zero footprint.
PowerOLAP for Budgeting
and Planning
Many Budgeting and Planning
products on the market today can not
support the simultaneous usage of
hundreds of people in an organization
that need to have real-time access
to their data to get their job done
without significant system performance
issues. IDS now allows thousands
of employees real-time access to
data to perform OLAP manipulations,
without any system performance
issues. Our solutions deliver
faster, more compact aggregate
information than our competitors.
You thought PowerOLAP
was awesome before,
now try V9!
PowerOLAP maintains a dynamic connection to an underlying data source system. By dynamically integrating Excel spreadsheets, browser, relational database, and an optimized multidimensional database into a faster, more powerful, more flexible single application, PowerOLAP will be the cornerstone of your own Business Operations. It is an ERP system that anyone can use, anyone can customize. A true competitive advantage.
As a standalone application or as a server client, PowerOLAP can access data provided by Microsoft's Analysis Services, adding key end-user features users of Analysis Services.
PowerOLAP is available as a client side standalone product or can act as the client application within a PowerOLAP S3 - MDB Server deployment, which also includes the installation of the entire PowerOLAP Suite.
PowerOLAP is the core of a business intelligence solution that puts your company’s performance at your fingertips. Be ready to move your business into the future with knowledge backed by data integrity to support strategic goals.
PowerOLAP moves with you through all aspects of your decision support needs: accessing real-time actuals; understanding scorecard metrics from any area of your business; budgeting and forecasting for tomorrow’s direction. PowerOLAP business solutions are built around your business information needs.
PowerOLAP allow your transactional systems, your business processes, and your Microsoft Excel spreadsheets to be integrated with On-Line Analytical Processing (OLAP). PowerOLAP make enterprise processes more collaborative and provide a simple interface to otherwise complex enterprise data problems. Our Intelligent Solutions provide all levels of the organization with an unprecedented level of capability to plan, implement, control, and monitor management's vision for the enterprise.
Business Benefits of using PowerOLAP Version 9.0
Better Decision-Making and Increased Productivity.
PowerOLAP is an enterprise-wide information system designed to connect people in your organization to the data they need to make better decisions. Because PowerOLAP delivers your company’s latest data directly into Excel, productivity is dramatically increased and staff can spend more time on advanced analysis and much less time on retrieving data and maintaining spreadsheets.
Reach Data Anywhere.
Data can be drawn from any source, relational databases like Microsoft SQL Server or Analysis Services OLAP cubes, as well as other OLAP sources. This compatibility enables you to leverage PowerOLAP’s high-performing engine even while you work with existing database systems.
Powerful Business Benefits:
- Accessible company information through Excel or the web, connecting live to all organization data, including data in Microsoft’s OLAP cubes.
- Faster Budgeting cycles, dynamic report building, and advanced analytics through “multidimensional” views of your company’s business structure and performance.
- Timely and accurate data available across your organization, synchronized and real-time delivered to the right people at the right time.
- Rapid ROI with little training required and significant reduction in current task time and effort, and great increases in staff productivity.
- Open and flexible software architecture which adapts to all your business needs in every department, from Finance and Sales, from Inventory to HR.
With the release of PowerOLAP Version 9.0, PARIS Technologies has renewed its commitment to innovation.
PowerOLAP includes a revolutionary Internet Data Services technique which can quickly, conservatively, and effectively distribute data and processing across multiple servers, even in multiple locations. In addition to IDS, many of the existing PowerOLAP processes have been enhanced: OLAP Exchange, OLAP Services, and Transfer Cube, to better suit user's needs. The cherry on top is the addition of a Scheduler, just to make your life that much easier. Below are some benefits we've associated with PowerOLAP:
- Unparalleled support for synchronization of internet data.
- Integrates easily with Excel’s pivot-table functionality—a favorite of seasoned Excel users.
- Instant access to data via a standard web browser.
- Integration with Analysis Services is more flexible and powerful than ever before.
- Distribute calculation processing between multiple machines.
- Perform “what-if” scenarios without impacting the performance of other users and distribute meta-data changes to remote databases.
- Accumulate metadata changes made by remote users.
- Synchronize fact data changes between cubes with different dimensionality.
Other Features
Internet Data Services (IDS) and IDS Web Server
IDS allows for the widespread deployment of the PowerOLAP solution to multiple, dispersed locations across the Web. The WEB interface provides easy access to PowerOLAP data via a standard WEB browser, taking advantage of PowerOLAP being an HTTP Server. To access the feature, users simply launch a WEB browser and enter the Name or IP Address of the machine running the PowerOLAP MDB server. The IDS feature supports the synchronization of databases over the internet. This includes all data modifications that might be made on either end of the connection. PowerOLAP data in IDS also integrates easily with Excel’s pivot-table functionality—a favorite of many a seasoned Excel user. The PowerOLAP analytical super engine, coupled with the muscle of the new IDS, gives all users freedom and flexibility to use their data at their convenience any time, anywhere. IDS can be used in any combination for the following:
- Distribute calculation processing between multiple machines.
- Perform “what-if” scenarios without impacting the performance of other users.
- Distribute metadata changes to remote databases.
- Accumulate metadata changes made by remote users.
- Synchronize fact data changes between cubes with different dimensionality.
IDS requires the PowerOLAP MDB server with HTTP enabled and that the client license supports IDS. Using IDS involves configuring and executing IDS tasks. The task is saved in the current database and can even be scheduled using the new Scheduler feature.
Scheduler
The Scheduler can Add, Edit, and Delete Tasks for scheduled execution. Also new, Notifications provide feedback based on the execution of jobs. Tasks that can be Scheduled:
- Internet Data Services
- Import Metadata
- Import Fact Data
- Rebuild Cube
- Export Slice
- Transfer Cube
- Export Cube
- Clear Cube
- Windows Script
- Execute SQL via ODBC
- Windows Executable
- Batch File
- Data Transformation Services
- SQL Server Integration Services
Transfer/Export/Clear Cube
The features to transfer, export, and clear cubes have existed since early versions of PowerOLAP. In version 8, we’ve enhanced functionality by extending the available options, simplifying the interface, and allowing users to save configurations as saved tasks. Tasks can be executed directly by any Administrative user or via the scheduling application. You can now add, edit, delete and execute for any of these functions: Transfer Cube, Export Cube and Clear Cube.
Rebuild Cube (Process Cube) - Several enhancements have been made to the processing of OLAP Exchange’s Rebuild Cube feature. First, the Rebuild Cube and Update Cube menus have been merged into a single menu called Process Cube. The Process Cube Dialog now has several new options for rebuilding cubes.
Synchronization Server, like OLAP Exchange, works via an ODBC connection and adds another powerful tool to establish a dynamic relational/multidimensional connection—in this case to leverage an installed relational system for the purpose of synchronizing independent PowerOLAP clients.
Power
OLAP Web Services provides Internet connectivity through a customizable Web browser that enables staff or customers to create unlimited reports and analytical views, including graphs, of data made available to them. Web Services also allows clients to enter figures into PowerOLAP cubes from wherever they can make an Internet connection. PowerOLAP Web Services is truly a means to extend a company's "real-time reach" to virtually anywhere.
