
If you chose to not automatically run scripts
when you installed the data warehouse server, additional steps are
needed to configure the data warehouse. By default, Windows® authentication is used for the Microsoft® SQL Server instance
and database. Therefore, you need to ensure that the users of the
report server connecting to the database and executing queries are
valid Windows users of the
data warehouse server. Also, you need to ensure that the batch files
for setting up the data warehouse run successfully.
About this task
After you have installed the Data Warehouse feature, configure
it:
- If the option for automatic execution of scripts was not chosen
when the data warehouse component was installed, the installer only
creates batch files to set up the Rational® Common Reporting data warehouse, but does not run them. Run the batch file
manually.
Note: These steps are needed only if you chose to manually run
scripts when you installed the data warehouse server.
Procedure
Create the data warehouse:- Go to the C:\Program Files\IBM\RCPR\datawarehouse\dw directory.
- Run the install.bat batch file.
- When prompted, specify the parameters for the data warehouse.
To see a list of parameters and their explanations, see the related
links at the bottom of this page.
Note: Rational Common Reporting users must enter the default parameters when manually
running the scripts.