PowerOLAP - Other Benefits



64bit Server Platform

PowerOLAP Server is available in both 32bit and 64bit versions. The 64bit version removes restrictions on memory usage and database size and enables users to query the largest data sets with complex multi-dimensional analytics.


Internet Data Services (IDS) and Web Services
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.


Click here to read more about IDS functionality and Web Services


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. 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 software 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.

Seeing is Believing
We know once you see PowerOLAP in action, you’ll wonder why you didn’t engage us sooner. Our clients consistently tell us we deliver a cost effective, stable, fast and effective single platform that supports their organizational reporting, budgeting, planning, forecasting, consolidation and analytics requirements, with real-time data. Average implementations can be done in weeks, not months.


Special Offer


  • To get you started, why not register today and download a Free 30 Day Trial of PowerOLAP V11 and to take advantage of our free online webinars.
  • Alternatively, please This email address is being protected from spambots. You need JavaScript enabled to view it. us to take advantage of a Free 10-user SME system for 12 Months.

- or -

  • Receive a fully functional PowerOLAP SME Designer Client License * worth £900 for free if you engage BIOLAP for 1 day’s consulting. The day includes hands-on user training including building a cube application and creation of reports to start you off on this exciting multi-dimensional journey.

* PowerOLAP Small-Medium Enterprise (SME) Edition accommodates 1 PowerOLAP database at a time, each containing 5 cubes, consisting of 10 dimensions and 10,000 members per dimension and includes OLAPExchange allowing a user to load and update data from ODBC compliant data sources.  This offer is only available to new customers and is limited to 1 license per company.



SAP Crystal Solutions

Simple, Affordable, and Open BI Tools for Everyday Use

SAP Crystal solutions deliver an affordable, open, self-service approach to entry-level business intelligence (BI) – empowering your business users to explore, view, report, visualize, and manage actionable information in an intuitive, secure way. With insight into every aspect of your business, you can monitor performance, identify opportunities for growth, and transform how you run your business.

SAP Crystal solutions can help your business users, IT users, and developers do the following:

  • Turn data into actionable reports using SAP Crystal Reports software
  • Discover answers to business questions using SAP Crystal Interactive Analysis software
  • Drive better decision making with interactive presentations using SAP Crystal Presentation Design software
  • Monitor business performance through real-time business dashboards using SAP Crystal Dashboard Design software
  • Rely on automatic delivery of personalized, secured dashboards and reports with SAP Crystal Server software

With SAP Crystal solutions, everyone in your organization can leverage a personalized view into trusted, timely, information. As a result, they can make fast, smart decisions – and you gain a competitive edge.

Get the latest SAP Crystal solutions

Affordable business intelligence (BI) enabling you to balance information security with end user self-serve access. The new semantic layer makes it easy for users to access and author BI content for fast, informed decisions reducing the pressure on IT for answers.

Give your users rich reporting, real-time dashboards and data exploration so they can make informed decisions.

SAP Crystal Dashboard Design (formerly Xcelsius Engage) provides an easy introduction to dashboarding functionality. In just a few hours, you can create business dashboards and data presentations from spreadsheets and corporate databases – and share them live through Microsoft Office, Adobe PDF and the Web. SAP Crystal Dashboard Design provides end users with access to up-to-the-minute company data in a simple and actionable interface.

Product Benefits

With SAP Crystal Dashboard Design, you can:

  • Obtain better insight into your business performance
  • Build professional-looking dashboards in just a few hours
  • Gain the confidence to take action by evaluating different what-if scenarios
  • Transform complex company data into simple, actionable visual information
  • Engage, inform, and persuade your audience with stunning visualization

Consider the features and functions of SAP Crystal Dashboard Design and view the interactive demos.


Thumbnail image

Point-and-click ease – An intuitive interface, including pre-built components and data connectors, enables you to create dashboards connected to live company data in days instead of months.


Flexible design capabilities – Using various visual analytics, themes, colours, and fonts, you can easily customize the look and feel of your dashboards to fit your corporate standards.


Built-in quick start guides – Start creating interactive dashboards right away by taking advantage of the built-in quick start guides and user samples.

Thumbnail image

Software development kit – Leverage Adobe Flex to create your own custom visualization components, themes, and data connectors for use with SAP Crystal Dashboard Design.



Live data connectivity – SAP Crystal Dashboard Design dashboards connect to your company's XML-compliant databases and SOAP-based Web services ensuring up-to-minute information, whenever and wherever you view them.


Thumbnail image

Visual modeling – Visual sliders on the screen allow end users to quickly evaluate multiple business scenarios by altering the underlying assumptions, and immediately see the impact on the results. View demo.


Drilldown charts and maps – Summarize rows of data in easy-to-understand charts and maps and provide report-level details with the click of a button. View demo.


Dynamic menus and selectors – Take advantage of a large selection of dynamic menus to display a large amount of data clearly and concisely. View demo.


Stunning presentation – A comprehensive library of eye-catching visualization components allows you to deliver complex company data in easy-to-understand business dashboards. View demo.


Export to Adobe Acrobat 9 – Easily embed, resize, and maneuver your SAP Crystal Dashboard Design models inside PDF documents by taking advantage of the new Flash content support features in Adobe Acrobat 9.


Export to Adobe AIR – Expand the reach and use of your business data by delivering them as part of easy-to-use desktop applications and widgets.



Improved Crystal Reports integration – Create interactive charts and what-if scenario models for your reports and easily bind them to your report data with a click of a button - no manual coding required. View demo.


Platform independence – Xcelsius visual models can be exported with just one click to Microsoft PowerPoint, Word, Outlook, Adobe PDF, Adobe Flash and the Web. View demo.

Special Offer

Why not register today and download a Free 30-day Trial of SAP Crystal Dashboard Design and a number of fully functional and interactive tutorial examples or take advantage of our free online webinars to get you started.

Want to learn more? Contact us or call us on +44 (01952) 456-453 or +44 (07785) 766-829.

Web Services

OLAP Web Services Internet HTTP and XML enabled

PowerOLAP Web Services is HTTP and XML enabled, providing internet connectivity through a customizable web browser. Your staff and/or customers can now 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 with broadband or any other means of internet connectivity.

Connectivity via Web Services extends PowerOLAP's Internet integration strategy enabling end users to analyse, report, budget and forecast using up-to-the-instant data. By opening up advanced modeling to users who need only a Web browser connection, companies empower users/staff or customers to "slice and dice" and create advanced reports on data made available to them. Plus, Web Services includes a Chart View feature, an eminently flexible graphical report writer. Furthermore, Web Services allows privileged users to enter updated figures, leveraging PowerOLAP across the Internet for remote reporting, budgeting - even for "what if" modeling. All of PowerOLAP's strict security privileges remain in effect, ensuring users can see or model only that data to which they are given access.

Meet Leonardo - Delivering the convenience of PowerOLAP anywhere

  • Leonardo®, PowerOLAP's Web-empowered Excel client, allows users to access fully-functional PowerOLAP databases anywhere, any time.
  • Leonardo provides widespread deployment of a PowerOLAP solution to multiple, dispersed locations across the Web. The same familiar Excel environment, coupled with the muscle of PowerOLAP's full capabilities, gives all users freedom and flexibility to use this analytical engine simply and at their own convenience.
  • A very thin web-empowered Client auto-installs Leonardo on a user's machine, rather than requiring a full installation of PowerOLAP Client on each and every workstation.


Internet Portal (HTTP & XML)

PowerOLAP's server is HTTP and XML enabled. Building professional web front-end reports that are viewable in an Internet browser from anywhere makes real-time, dynamic "What if" analysis and reporting a reality.

Communication with the server through XML is bi-directional - retrieve and enter your data in your browser - no need for a thin client!

Internet Data Services (IDS) and IDS Web Server

IDS allows for the widespread deployment of a PowerOLAP solution to multiple, dispersed locations across the Web. The interface provides easy access to PowerOLAP data via a standard browser, taking advantage of PowerOLAP being an HTTP Server. To access the feature, users simply launch a browser and enter the Name or IP Address of the Machine running the PowerOLAP MDB Server. This access is even available via popular 3G devices such as Apple's iPhone allowing users to view their data while on the go!

To try out an interactive example of IDS, click here (Please note that we endeavour to keep our demonstration server available 24/7. However, in the event that the server is not running for any reason, please email This email address is being protected from spambots. You need JavaScript enabled to view it. and we will restart the service). Not only can you select different regions and versions, but you can also change data and see the result with zero software footprint!

IDS supports the synchronization of databases over the internet. This includes all data modifications made on either end of the connection. PowerOLAP data with IDS also integrates easily with Excel's PivotTable functionality - a favourite of many Excel users.

The PowerOLAP analytical engine with the muscle of the new IDS, gives users freedom and flexibility to use data at their convenience anytime, anywhere.

IDS can be used in any combination for the following:

  • Distributed 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
  • Synchronise fact data changes between cubes with different dimensionality.


Web Reporting using PowerOLAP and other Third Party Solutions

PowerOLAP can be used in conjunction with other Third Party products to deliver a wide variety of web-based reporting and dashboarding solutions.


arcplan Enterprise®

images_products_enterprise_splashscreen20ae65sarcplan Enterprise®, highly rated by influential reviews such as Gartner and Magic Quadrant for its out-of-the-box flexibility, BI-focused corporate performance management (CPM), integration capability and low cost of ownership, deploys business intelligence and analysis applications that meet all of your organisational needs linked directly to your data held in PowerOLAP. 

arcplan Enterprise® is the ideal solution platform for building scalable, non-compromising BI and process-driven analytics applications for your organisation.

usingpoOnce developed, arcplan-based business solutions are easy to deploy and to administer via the arcplan Enterprise Server and retrieved using arcplan client interfaces, available in Java and .NET. This common interface ensures consistent data delivery and dissemination of knowledge to all employees throughout your enterprise. In addition, web services end points expose arcplan analyses for re-use by other applications and analytical tools. Click on the  image on the right to access an interactive arcplan application linked to PowerOLAP allowing you to update budget numbers and assumptions and see the impact immediately (Please note that Java JREneeds to be installed on your machine). 



Cubeware Cockpit V6pro

963448a4b9Cubeware Cockpit links seemlessly with PowerOLAP to deliver an intuitive front end for Windows and the Web.

Cubeware Cockpit brings the power of PowerOLAP to the desktops of business users. Build powerful yet intuitive management cockpits that offer cross-report and cross-cube analysis with context-sensitive links to reports and folders. Integrate into Web sites, text files, images and applications using parameters. Deliver multilanguage reporting environments to support your international business, and much, much more!

2643659ebeYou can access the full functionality of PowerOLAP with Cubeware Cockpit including all data, reports and analyses at any time through the Web. Roll out global Business Intelligence solutions quickly by integrating the multilanguage reporting environment into your corporate portal or Intranet.

Cubeware Web Cockpit is available in English and German and automatically complies with the current Web browser language settings. Simply install Cubeware Web Enabler (the actual application component) on your Web server and you can run Cockpit on any computer – with no further software installation necessary!


SAP Crystal Dashboard Design

income statement dashboardUnlike other data visualization software that provides static charts and difficult-to-integrate dashboards, SAP Crystal Dashboard Design (formerly Xcelsius Engage) software enables a decision maker or business user to interact with PowerOLAP in a visual format that provides additional insight. With SAP Crystal Dashboard Design software, you can:

Create dashboards –SAP Crystal Dashboard Design software gives you the power to transform complex data into a comprehensive dashboard. Create interactive dashboards from PowerOLAP driven Microsoft Excel reports as a live data source, and export your dashboard to a familiar format – Microsoft Office, Flash (SWF) files, Adobe PDF, and more for a zero footprint solution.

balance sheet dashboardConnect to multiple live data sources to make real-time decisions – SAP Crystal Dashboard Design Server software expands the benefits of SAP Crystal Dashboard Design, with a Web services generator that makes connecting simple. Plus, integration kits are included for the applications you use everyday, so you get the most from your existing IT environment

Create visually stunning and interactive presentations – SAP Crystal Dashboard Design software provides a powerful presentation tool that bridges the gap between spreadsheets and the need for visual, interactive presentations. Bring PowerOLAP driven Microsoft Excel spreadsheets further to life with interactive charts and what-if scenarios – no training or programming is required

Click here to see an interactive SAP Crystal Dashboard Design demonstration working with PowerOLAP!


PowerOLAP® Web

powerolapwebView and Deploy Excel Reports and Dashboards as Interactive Web Pages. Now you can create real-time Web reports that support the Excel functions, formatting, and graphic capabilities that you use every day. With just a Web browser, you can get secure, fast, live access to your reporting, analysis, budget, planning and forecasting applications developed with PowerOLAP.

PowerOLAP Web provides true thin client, zero footprint delivery of reports with interactive data that you create in Excel. PowerOLAP dynamically connects your back-end databases to an Excel or web interface providing you with the business intelligence you need in a single, cost-affordable platform.

With PowerOLAP® Web, you can:

  • Publish your reports as dynamic Web pages
  • Share reports and dashboards across the organization to anyone with permission and a web browser
  • Have best-in-class Web access to your reports with zero footprint
  • Write back data from reports to PowerOLAP databases

Simply create a report the way you want it to appear, then save it. When you open the file on the Web server it converts xls to html instantly, maintaining all of your calculations and the connectivity to your source data through PowerOLAP®. From the Web page you can view thousands of different reports from a single view, update budgets and plans, print reports, and even convert xls to pdf online



Special Offers


  • To get you started, why not register today and download a Free 30 Day Trial of PowerOLAP V11 and to take advantage of our free online webinars.
  • Alternatively, please This email address is being protected from spambots. You need JavaScript enabled to view it. us to take advantage of a Free 10-user SME system for 12 Months.

- or -

  • Receive a fully functional PowerOLAP SME Designer Client License * worth £900 for free if you engage BIOLAP for 1 day’s consulting. The day includes hands-on user training including building a cube application and creation of reports to start you off on this exciting multi-dimensional journey.        

* PowerOLAP Small-Medium Enterprise (SME) Edition accommodates 1 PowerOLAP database at a time, each containing 5 cubes, consisting of 10 dimensions and 10,000 members per dimension and includes OLAPExchange allowing a user to load and update data from ODBC compliant data sources.  This offer is only available to new customers and is limited to 1 license per company.


WhereScape Red

Builds data warehouses, fast

WhereScape RED unites source system exploration, ELT, dimensional and normal-form target schema design, and dependent cube-building construction with an integrated operations and management environment and a metadata repository, allowing small teams of data warehousing professionals to implement data warehouses using agile methodologies, practicing iterative-build-and-test disciplines and involving key end-users in the build process. All build-and-operate metadata is customizable, rewritable and stored in a central, managed and versioned repository, bringing application programming discipline, tool integration and automated documentation generation to data warehouse build projects.

WhereScape RED can be driven by WhereScape 3D, or used as a stand-alone Integrated Development Environment (IDE) in environments with advanced BI planning models.

Whether a team is focused on an enterprise data warehouse, a standalone data mart, a tier of reporting services, or the renovation or migration of an existing warehouse or mart, WhereScape RED provides an integrated, cost-effective alternative to complex and expensive do-it-yourself development environments, with team development support, and project-level control, at a fraction of the cost of the alternatives. products:


WhereScape Red

  • Automates the entire data warehousing life cycle, from design, through implementation, operation and renovation. WhereScape Red provides ELT facilities, and is the market’s first and best IDE for the data warehouse build process, end to end.
  • Supports agile as well as traditional project approaches, including Live Prototyping™ -- rapid prototyped and fully functional data warehouses in hours, for user reviews and feasibility testing
  • Generates code automatically, with complete editing freedom post-generation
  • Provides industry best practices out-of-the-box, including generation of surrogate keys, time dimensions, and target indices.
  • Delivers full extraction, load and transformation (ELT) facilities, with integrated dependency management and scheduling  Is based on a team-aware metadata repository for all code, audit and workflow components, with full versioning, code promotion, impact analysis tools (trackback and track-forward features), metadata search and automated documentation production.   




WhereScape RED extracts data from database links, flat files, XML, and any ODBC compliant data source including Oracle, SQL Server, DB2, Teradata, Sybase, Informix, Progress, postGres and mySQL.

WhereScape RED builds data warehouses in the major merchant DBMS data warehousing platforms - Oracle, SQL Server, DB2 and Teradata - as well as providing automatic generation of Microsoft SSIS packages, and Analysis Services cubes.

Ultimately, WhereScape RED’s integration, speed and effectiveness enables data warehousing teams to produce data warehouses and marts that deliver value quicker, remain relevant to business users longer, and can be enhanced and modified nearly instantaneously -- data warehouses right, now.

If you don’t believe our claim that WhereScape RED can radically reduce the time and complexity associated with building a data warehouse, we encourage you to take our 24 Hour Challenge. Send us your working data, and we will send you back a working data warehouse prototype, ready to be loaded in your DBMS environment, complete with documentation, in a day or less.

Or sign up for an online walk-through of WhereScape RED with one of our working consultants - you can see the product in action, and talk through your specific needs, at the same time.

If you’re interested in understanding the details of how RED is implemented, and how it works, you can read the product brochure, the product data sheet, or the architecture overview, or just download a working copy of WhereScape RED and take it for a spin.

If you’d like to know why nearly 500 companies use WhereScape RED as their data warehousing IDE, you can see what the analysts have to say about WhereScape, its products and its commitment to the data warehousing market.


Use Cases  

WhereScape customers - nearly 500, worldwide - use WhereScape RED in a wide variety of BI-related situations, including:

  • Agile Data Warehousing and Business Intelligence: WhereScape customers committed to implementing agile methods and practices find WhereScape RED ideally suited to their needs. Agility is built into WhereScape RED.
  • Rapid Prototyping: WhereScape customers use RED’s Live Prototyping™ facilities to build, populate and test target schema, with users, in rapid iteration cycles, before manual implementation of those target schema in production environments.
  • Production-Ready Enterprise Data Warehouse: Using both purchased enterprise data models and manually-designed normal-form enterprise data warehouse schema, WhereScape customers have used RED to build, deploy and operate full-scale enterprise data warehouses, with small project teams, in months, rather than years.
  • Production-Read Data Mart: Using RED’s market-leading dimensional data modeling and implementation capabilities, WhereScape customers routinely use WhereScape RED to build independent data marts and reporting systems, from multiple source systems, moving from first test extraction to working data mart in weeks.
  • User Access Layer or Tier of Dependent Marts: In environments where existing enterprise data warehouses require a user access layer, or a tier of independent data marts, to protect the enterprise data warehouse from rapidly changing or volatile end-user requirements, WhereScape customers use WhereScape RED to create user access layers and tiers of dimensional data marts from normal-form enterprise data warehouses, quickly transforming corporate information assets into user-ready dimensional data sets. 
  • Warehouse Renovation or Replacement: When an existing legacy data warehouse or mart requires extension, renovation or replacement, WhereScape customers use WhereScape RED to replicate the existing warehouse or mart in a new target environment, with enhancements as appropriate.
  • Corporate Performance Management System: when rigorous corporate performance management or business activity monitoring initiatives require high-performance, highly summarized and pre-calculated federated star schema to drive sophisticated reporting, the power of WhereScape RED to quickly build sophisticated analytic structures is highly appreciated.
  • Analytics Workstation: WhereScape RED’s compact footprint makes it ideal for WhereScape customers seeking to implement large-scale workstation-based personal data marts, for database marketing, statistical analysis and data mining. Powerful multi-core workstations running Windows-based operating systems, SQL Server, and WhereScape RED make, our customers find, ideal and affordable analytical workstations.


Why not register today for a free trial of WhereScape Red? Also  download free resources such as white papers and success stories, or take advantage of our free online webinars to get you started, or contact us for more information about software pricing or about our WhereScape Red based solutions, or call us on +44 (01952) 456-453 or +44 (07785) 766-829

Login Form