In the Type field, select a report type, then select and item, 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 30.
If you select more than one item, 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.
Changing from Analytic Services to Planning Details
The following is a list of considerations when changing the database connection from Analytic
Services to Planning Details for a report:
The dimensions and functions defined in reports and books must exist in the target data
source. The following limitations apply:
Attribute dimensions are only supported for Essbase.
Hsp_Rates is not available as a dimension.
The cell text function cannot be used, because Linked Reporting Objects (LROs) are not
Only the member selection using a level 0 is supported.
Validate that dimensions exist prior to opening the report. If a dimension defined on a grid
is not available in the Planning Details data source, no change is made. If an invalid function
is used, an error is returned. The report designer has to remove the invalid function or
Changing from Planning Details to Analytic Services
There are several features that may be defined in a Planning Details report that are irrelevant for
Analytic Services report, including PlanningAnnotations, Supporting Detail, and OrderBy. If
Supporting Detail is defined in the report, the details are ignored. If PlanningAnnotations or
OrderBy are used, they return an error. The report designer must remove the
PlanningAnnotation function and OrderBy for the report to run.
Changing Financial Reporting Database Connections