Configuring Blox Sampler for IBM DB2 OLAP Server and Hyperion Essbase
For use with IBM DB2 OLAP Server and Hyperion Essbase, this Blox Sampler example
set requires the following:
- The QCC-Essbase sample data
- DB2 Alphablox running
- Supported Web browser
- Comment database repository (required for running the examples in the Commenting
on Data section)
To use the files in Blox Sampler, you need to make sure that the following
steps have been performed:
- Define an DB2 Alphablox data source for QCC.
- Create a comment database repository.
- Define an DB2 Alphablox data source to access the comment repository.
1. Install the QCC data on an IBM DB2 OLAP Server or Hyperion Essbase server
The QCC-Essbase sample data is available on the DB2 Alphablox installation
CD under the sampledata/qcc/essbase6
directory. For installation instructions, see the associated readme.txt
file.
2. Define the QCC-Essbase data source on DB2 Alphablox
Once the sample data is installed, it needs to be defined to DB2 Alphablox
through the
Admin Pages. Instructions for defining data sources are available
online on the Admin Pages as well as in the Administrator's
Guide. The following are the configuration values to use:
- Data Source name: QCC-Essbase
- Adapter: IBM DB2 OLAP Server or Hyperion Essbase
- Server Name: <enter your IBM DB2 OLAP Server or Hyperion Essbase data
server name>
- Application: Blox
- Database: qcc
- Default User Name:
<userName>
- Default Password:
<password>
- Use DB2 Alphablox Username and Password: No
- Maximum Rows: 1000
- Maximum Columns: 1000
Note: After the QCC-Essbase
data source is configured, you can use all of the Blox Sampler examples, except
for those in the Commenting Data section. To use those
examples, continue with steps below.
3. Create a Comments database repository
In order to use examples in the Commenting Data section, you first need to
configure a CommentsBlox database repository to store and use comments. This
only requires that you create a database using any of the DB2 Alphablox-supported
relational databases. DB2 Alphablox will automatically create any required
tables it needs. After creating this database, you need to define a DB2 Alphablox
data
source.
4. Create a DB2 Alphablox data source for the comments repository
For DB2 Alphablox to use the comments database you created, you
need to define a DB2 Alphablox data source using
the Admin
Pages. Instructions for defining data sources are in the online help available
in the Admin pages as well as in the Administrator's
Guide. After you select the appropriate adapter for your database,
fill in the required fields and make sure to define a default username and
password. For the data source name, use CommentsCollection.
5. Creating a Comments Collection
After you have created a database for your comments repository, follow these
steps to create a comments collection (within your comments repository) for
storing comments:
- Go to the DB2 Alphablox Admin Pages, click on the Administration
tab, then click on the General tab.
- Under Runtime Management, click the Comments
link to open the Comments Management window.
- Select the CommentsCollection as your data source, enter your username
and password, then press the Connect button. The Collection area (below Datasource)
should become available.
- To create a new collection, press the Create button. In the right side
of the window, three new sections (Name, Fields, and Dimensions) should appear.
- In the Name section, enter the name of your comments collection -- for
Blox Sampler, use CommentsCollection as the collection name too.
- In the Fields section, three required default fields are included: the
Author, Timestamp, and CommentText fields. You can add additional fields,
defining their names, and optionally, descriptions for each field you define.
For this collection, you can use the default fields.
- In the Dimensions section, select the QCC-Essbase from the list of defined
data sources. A list of available dimensions should appear.
- For the Blox Sampler examples, select all of the available dimensions
by Shift-clicking or Control-clicking on the dimensions in the list.
- Press the Save button. At this point, the name of the newly defined collection
should appear in the Collection listing.
The Blox Sampler comments-related examples should
work properly now.