Dimensions that existed in the old database connection but not in the new database
connection are removed. The dimensions and its members that existed in the rows and or
columns are removed from the grid. If, as a result of the removal, no dimension exists in
the row or column, you need to add a valid dimension to the cleared row or column in order
for the report to run.
Dimensions that exist in the new database connection but not in the old one, are added to
If the report contains at least one dimension in both the row and column, it can be run and
opened when the error message is received. The report can also be exported from the repository.
If you do not like the modifications that are automatically made for mismatched dimension,
you can close the report and change to the original database connection.
When you change the database connection for reports or books, you can also select to validate
that the databases have the same dimension. When this option is selected for a report, and
dimensions do not match, you are prompted that the action failed. Likewise, if dimensions do
not match for a specific report in a book, you are prompted that the action for the entire book
failed. If you do not choose to validate, the database connection for the reports and books are
changed and you are not prompted for mismatched dimensions. However, errors may occur
when you open or run the reports or books.
To change the data source in the repository:
From Workspace, select Navigate > Explore to display the Select dialog box, then select Tools > Change
In the Type field, select a report type to change, and click OK. Change Database Connection is displayed.
Select the item and click OK.
In Find all references to the Database Connection, select the database connection to change.
In Replace With, select a database connection.
To create a new database connection, click New Database Connection. See “Adding Database
Connections” on page 102.
Make changes to all items that you selected.
Changing Analytic Services and Planning Details
When changing a report from Analytic Services database connection to a Planning Details
database connection or vice versa, there are several restrictions. The data source reference is the
only change and there is no conversion.
100 Exploring and Managing Items