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:
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 Getting Started guide in the IBM
Alphablox Information Center.
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 through
the QCC-README.html file on IBM Alphablox installation CD's
sampledata
directory as well as online on the Admin Pages. 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 IBM Alphablox-supported relational databases. IBM Alphablox will generate any tables. After creating this database, you need to define a 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 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.