For use with Microsoft Analysis Services (MSAS), the Blox Sampler example set for MSAS 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 in the following directories:
sampledata/qcc/msas
- use with Microsoft SQL Server 2000 Analysis Services (MSAS 2000)sampledata/qcc/ssas2005
- use with Microsoft SQL Server 2005 Analysis Services (SSAS 2005)For installation instructions, see the associated readme.txt
file.
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:
<loginName>
<password>
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 CommentsCollectionMSAS.
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:
To run the DrillThrough example in the Retrieving Data section, you need to perform the following steps in Analysis Manager:
a) Open the Analysis Manager console
b) Find and click on the QCC cube, right-click, then choose the Edit option.
c) In the Tools menu, select Drillthrough Options.
d) Check the Enable Drillthrough checkbox, then check each of the following columns:
Region,Area,Sales,Cost,Units,Year,Scenario.
e) Press the OK button. You will be prompted that changes will only occur after
you save the cube.
f) In the Cube Editor menu, select File, then Save. Close the Cube Editor.
a) Right-click on the cube again, and select the Manage Roles option.
b) Right-click on the Drillthrough column.
c) Check the Allow Drillthrough checkbox, then OK.
The QCC cube should now be Drillthrough-enabled and the example should work
properly.