Impact Manager uses an Interactive Reporting document to report which documents are affected if tables, columns or hierarchies change. This report identifies Interactive Reporting and Web Analysis documents. The Impact of Change Report is deployed as a hidden file in workspace /Administration/Impact Manager/Impact of Change.bqy. As with all Interactive Reports that are imported to EPM Workspace, a four step process is required before the report can retrieve metadata from the data source.
Define the data source in the EPM Workspace Data Access Service (DAS).
In the Services section of EPM Workspace (select Navigate, then Administer, then Reporting and Analysis, and then Services), select the DAS service and use the Data Sources tab to add a new service.
Create a connection file (OCE) that references the data source in DAS.
Use the Interactive Reporting Designer to create a connection file that references the Hostname/Provider of the DAS data source.
Publish the connection file in EPM Workspace.
Log onto EPM Workspace with an Administrator role and publish the connection file
Associate the Impact of change dashboard’s data model sections with the published connection file.
Set your View options to show hidden folders and files. Navigate to /Administration/Impact Manager and select Impact of Change.bqy. Select the Interactive Reporting options and set every Query / Data Model use of the connection file imported later.
Note: | To make running the Impact of Change report easier, configure the connections to use a default user id and provide a password for automatic logon. If automatic logon is not enabled, users will have to supply the database user id and password every time they run the report. |