For use with DB2 Alphablox Cube Server (ACS), the Blox Sampler example set for the Alphablox Cube Server requires the following:
To use the files in Blox Sampler, you need to make sure that the following steps have been performed:
The QCC sample data is available on the DB2 Alphablox installation CD under
the sampledata/qcc/acs
directory. For installation instructions, see the associated readme.txt
file. You need to follow the procedures for creating the relational database (qcc) and the DB2 Alphablox cube (qcc_2003).
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 on-line on the Admin Pages as well as in the Administrator's Guide. The following example show the configuration values to use for a DB2 database:
<loginName>
<password>
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 on-line on the Admin Pages as well as in the Administrator's Guide. The following are the configuration values to use:
Leave the other values set to their default settings and save your data source definition.
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 DB2 Alphablox-supported relational databases. DB2 Alphablox will generate any tables. After creating this database, you need to define a DB2 Alphablox data source.
For DB2 Alphablox to use the comments database you have created, you have to define a data source on 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. 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.