Blox Sampler can be configured to be used with either the IBM Cubing Services Feature, a standalone component available in some editions of DB2 Warehouse. or the embedded IBM Alphablox Cube Server (ACS).
The Blox Sampler example set requires the following:
To use the files in Blox Sampler, make sure that you follow the steps described
in the QCC-README.html file on IBM Alphablox installation CD's
sampledata
directory. The same instructions are also provided in
the Started guide in the IBM
Alphablox Information Center. The procedures involve the following steps:
Once the sample data is installed, it needs to be defined to IBM Alphablox through the Admin Pages. Instructions for defining data sources are available on-line on the Admin Pages as well as in the Administrator's Guide.
The following are the configuration values to use:
Once the sample data is installed, it needs to be defined to IBM Alphablox through the Admin Pages. Instructions for defining data sources are available on-line on the Admin Pages as well as in the Administrator's Guide.
The following example show the configuration values to use IBM Alphablox Cube Server with an IBM DB2 database:
<loginName>
<password>
You also need to define an Alphablox Cube Server data source whose cube definition will be based on the qcc2003-rdb data source. The following are the configuration values to use for the ACS data source:
Leave the other values set to their default settings and save your data source definition.
Store the provided cube definition property file into your IBM Alphablox Repository. A qcc_2003.properties file that contains the cube definition is provided on the CD.
To run the examples in the Highlighting and Commenting on Data section, perform the following steps:
In order to use examples in the Commenting on Data section, you first need to configure a Comments database repository to store and use comments. This requires that you create a database using any of the IBM Alphablox-supported relational databases. IBM Alphablox will generate any tables. After creating this database, you need to define an IBM Alphablox data source.
For IBM Alphablox to use the comments database you have created, you have to define a data source on IBM 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. After you select the appropriate adapter, fill in the required fields and make sure to define a default username and password. For the data source name, use CommentsCollectionACS.
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:
You have created a comments collection for use with Blox Sampler.