Managing the Reporting Service
Use the Administrator tool to manage the Reporting Service and the Data Analyzer repository content.
You can use the Administrator tool to complete the following tasks:
- •Configure the edit mode.
- •Enable and disable a Reporting Service.
- •Create contents in the repository.
- •Back up contents of the repository.
- •Restore contents to the repository.
- •Delete contents from the repository.
- •Upgrade contents of the repository.
- •View last activity logs.
Note: You must disable the Reporting Service in the Administrator tool to perform tasks related to repository content.
Configuring the Edit Mode
To configure the edit mode for Datasource, set the Data Source Advanced Mode to false for basic mode or to true for advanced mode.
The following table describes the properties of basic and advanced mode in the Data Analyzer instance:
Component | Function | Basic Mode | Advanced Mode |
|---|
Datasource | Edit the Administrator tool configured properties | No | Yes |
Datasource | Enable/disable | Yes | Yes |
Dataconnector | Activate/deactivate | Yes | Yes |
Dataconnector | Edit user/group assignment | No | Yes |
Dataconnector | Edit Primary Data Source | No | Yes |
Dataconnector | Edit Primary Time Dimension | Yes | Yes |
Dataconnector | Add Schema Mappings | No | Yes |
Basic Mode
When you configure the Data Source Advanced Mode to be false for basic mode, you can manage Datasource in the Administrator tool. Datasource and Dataconnector properties are read-only in the Data Analyzer instance. You can edit the Primary Time Dimension Property of the data source. By default, the edit mode is basic.
Advanced Mode
When you configure the Data Source Advanced Mode to be true for advanced mode, you can manage Datasource and Dataconnector in the Administrator tool and the Data Analyzer instance. You cannot return to the basic edit mode after you select the advanced edit mode. Dataconnector has a primary data source that can be configured to JDBC, Web Service, or XML data source types.
Enabling and Disabling a Reporting Service
Use the Administrator tool to enable, disable, or recycle the Reporting Service. Disable a Reporting Service to perform maintenance or to temporarily restrict users from accessing Data Analyzer. When you disable the Reporting Service, you also stop Data Analyzer. You might recycle a service if you modified a property. When you recycle the service, the Reporting Service is disabled and enabled.
When you enable a Reporting Service, the Administrator tool starts Data Analyzer on the node designated to run the service. Click the URL in the Properties view to open Data Analyzer in a browser window and run the reports.
You can also launch Data Analyzer from the PowerCenter Client tools, from Metadata Manager, or by accessing the Data Analyzer URL from a browser.
To enable the service, select the service in the Navigator and click Actions > Enable.
To disable the service, select the service in the Navigator and click Actions > Disable.
To recycle the service, select the service in the Navigator and click Actions > Recycle.
Creating Contents in the Data Analyzer Repository
You can create content for the Data Analyzer repository after you create the Reporting Service. You cannot create content for a repository that already includes content. In addition, you cannot enable a Reporting Service that manages a repository without content.
The database account you use to connect to the database must have the privileges to create and drop tables and indexes and to select, insert, update, or delete data from the tables.
1. In the Administrator tool, click the Manage tab > Services and Nodes view.
2. In the Domain Navigator, select the Reporting Service that manages the repository for which you want to create content.
3. Click Actions > Repository Contents > Create.
4. Select the user assigned the Administrator role for the domain.
5. Click OK.
The activity log indicates the status of the content creation action.
6. Enable the Reporting Service after you create the repository content.
Backing Up Contents of the Data Analyzer Repository
To prevent data loss due to hardware or software problems, back up the contents of the Data Analyzer repository.
When you back up a repository, the Reporting Service saves the repository to a binary file, including the repository objects, connection information, and code page information. If you need to recover the repository, you can restore the content of the repository from the backup file.
When you back up the Data Analyzer repository, the Reporting Service stores the file in the backup location specified for the node where the service runs. You specify the backup location when you set up the node. View the general properties of the node to determine the path of the backup directory.
1. In the Administrator tool, click the Manage tab > Services and Nodes view.
2. In the Domain Navigator, select the Reporting Service that manages the repository content you want to back up.
3. Click Actions > Repository Contents > Back Up.
4. Enter a file name for the repository backup file.
The backup operation copies the backup file to the following location:
<node_backup_directory>/da_backups/
Or you can enter a full directory path with the backup file name to copy the backup file to a different location.
5. To overwrite an existing file, select Replace Existing File.
6. Click OK.
The activity log indicates the results of the backup action.
Restoring Contents to the Data Analyzer Repository
You can restore metadata from a repository backup file. You can restore a backup file to an empty database or an existing database. If you restore the backup file on an existing database, the restore operation overwrites the existing contents.
The database account you use to connect to the database must have the privileges to create and drop tables and indexes and to select, insert, update, or delete data from the tables.
To restore contents to the Data Analyzer repository:
1. In the Administrator tool, click the Manage tab > Services and Nodes view.
2. In the Domain Navigator, select the Reporting Service that manages the repository content you want to restore.
3. Click Actions > Repository Contents > Restore.
4. Select a repository backup file, or select other and provide the full path to the backup file.
5. Click OK.
The activity log indicates the status of the restore operation.
Deleting Contents from the Data Analyzer Repository
Delete repository content when you want to delete all metadata and repository database tables from the repository.
You can delete the repository content if the metadata is obsolete. Deleting repository content is an irreversible action. If the repository contains information that you might need later, back up the repository before you delete it.
To delete the contents of the Data Analyzer repository:
1. In the Administrator tool, click the Manage tab > Services and Nodes view.
2. In the Domain Navigator, select the Reporting Service that manages the repository content you want to delete.
3. Click Actions > Repository Contents > Delete.
4. Verify that you backed up the repository before you delete the contents.
5. Click OK.
The activity log indicates the status of the delete operation.
Upgrading Contents of the Data Analyzer Repository
When you create a Reporting Service, you can specify the details of an existing version of the Data Analyzer repository. You need to upgrade the contents of the repository to ensure that the repository contains the objects and metadata of the latest version.
Viewing Last Activity Logs
You can view the status of the activities that you perform on the Data Analyzer repository contents. The activity logs contain the status of the last activity that you performed on the Data Analyzer repository.
1. In the Administrator tool, click the Manage tab > Services and Nodes view.
2. In the Domain Navigator, select the Reporting Service for which you want to view the last activity log.
3. Click Actions > Last Activity Log.
The Last Activity Log displays the activity status.