Third-Party OLAP Providers

This section of the Readme contains late-breaking information related to third-party OLAP providers used with PowerPlay.

Unable to Open a Cube Using 8.2 DB2 OLAP or Essbase 7.1

If you are using 8.2 DB2 OLAP or Essbase 7.1, you cannot open a cube which has been designed to use Aggregate Storage. When the Aggregate Storage Option (ASO) cube package is opened the metadata is not shown. To ensure that you have the run-time library required to access the ASO feature, perform the following additional steps when installing your DB2 OLAP 8.2 client software.

Steps to Access the Run-time Library

1. In the DB2 OLAP 8.2 client installation wizard, select the Custom installation type, and then click Next.
2. Select the Essbase API for Windows 32 option if it has not already been selected, and then proceed through the remaining pages of the installation wizard.
3. When the installation is finished, locate libdb42.dll in the folder db2olap_installation_location\api\redist, and copy this file to the client installation folder db2olap_installation_location\bin.
4. Restart your system.

Note: If you apply a Fix Pak to your DB2 OLAP 8.2 client, remember to also recopy libdb42.dll (as explained above), to ensure that your \bin folder always contains the most up-to-date version of this required file.

nbna

Wildcard Searches Against Microsoft SQL Server Analysis Server 2005 Datasources Yield No Results

If you attempt to do a wildcard search against a Microsoft SQL Server Analysis Server 2005 cube from PowerPlay by selecting "*" in the "Find What" edit box on the "Find In Cube" dialog box with the "Use Wildcards" option enabled, you will receive no results from the search.