This section provides an overview of significant changes in DB2 OLAP Server Version 8.1.
OLAP Miner enables you to examine your OLAP cubes (multidimensional databases) more thoroughly and easily by finding atypical or deviant values automatically. Instead of searching through your data manually to find data values that might be higher or lower than you expected, OLAP Miner can do this work for you. The OLAP Miner algorithm is optimized so that it can be deployed on large OLAP cubes.
You can search specific areas (subcubes) of your cubes by creating deviation detection definitions, which specify the way in which OLAP Miner examines the data that you selected for the subcube. OLAP Miner provides an easy-to-use wizard that helps you create deviation detection definitions. After you create and run a deviation detection definition, OLAP Miner applies an algorithm to the data to find deviations. Then you can view a simple list of deviations or bring up the Deviation Viewer, from which you can see the deviations in the context with other surrounding values. You can also view deviations in a standard spreadsheet application.
OLAP Miner was introduced in FixPak 7 of Version 7.1.
The following changes are specific to Release 6.5 of Hyperion Essbase OLAP Server.
Use OIS and the Hybrid Analysis manager to create applications that access relational data using Hybrid Analysis. The manager generates queries dynamically against the relational source, and runs as part of the OLAP Server.
For more information about how to use Hybrid Analysis, see these documents:
If you enable parallel calculation, DB2 OLAP Server analyzes all the tasks in a calculation pass and breaks them down into subtasks. The subtasks that can run independently of each other are scheduled to run simultaneously on up to four threads, each on a separate CPU.
See the Technical Reference, which entries in the configuration setting and calculation commands sections. You can enable and adjust parallel calculation by adding CALCPARALLEL (and optionally CALCTASKDIMS) to your essbase.cfg configuration file, or you can issue the calculation commands SETCALCPARALLEL (and optionally SET CALCTASKDIMS).
In addition, DB2 OLAP Server logs additional security activities in the server log, including the name of the user and group being changed and the user performing the change:
The following changes are specific to Release 6.2 of Hyperion Essbase OLAP Server.
To help administrators, DB2 OLAP Server now provides these new features:
To enable external authentication, administrators use this procedure:
You can use export LRO and import LRO(MaxL) to perform these tasks:
System administrators can log out all users of a particular application or database, or log out instances of particular users from a selected scope: an application, a database, or the entire OLAP Server system. If a user request is active when the administrator tries to log off the user, the administrator can force the user off. Using force safely terminates the request, and then logs the user off.
Additionally, administrators may terminate specific requests that have become problematic. For example, if a user loses the connection to the OLAP Server during a request (for example, a calculation), the abandoned request may cause the application to stop responding to subsequent requests.
Each user session has a unique ID number, which can be displayed and used by the administrator to terminate the current request associated with that session. When the administrator terminates a request, the user session remains active.
The improved handling of sessions and requests can be found in any of these areas:Some error messages have been rewritten to provide clarity. With this release, behavior on NT and UNIX platforms is identical.
Version 8.1 includes buffered I/O as the default. If you want to use direct I/O, as was the default for Release 6.0 and 6.1, you can use the configuration setting DIRECTIO TRUE.
Because buffered I/O may affect some DB2 OLAP Server caches, you may need to adjust cache size as well as change the DIRECTIO configuration setting.