The following sections provide information about how to clean up data, rename or delete metrics, and delete machines.Before you do the following you must disable all the ETL and OLAP jobs.
The Delete Machines task lets you remove servers and devices from Analysis Center when you no longer want to report on them. This task removes the servers and corresponding data points from the Data Warehouse and Data Mart databases for these machines in Analysis Center. This does not prevent Analysis Center from collecting data points from the same machines again.
To remove the machines that you do not want to include in reports:
Launch the Admin Console.
In the left navigation pane, click Data Management > Delete Machines.
Select the machines you want to delete and follow the on-screen prompts.
After the specified machines and data points are deleted, Analysis Center reprocesses machine dimensions and partitions, and does not display these machines in the Analysis Center reports. Deleted machines are not displayed in the Deleted Machines folder in the Console. To view a deployed report without the specified machines in SSRS, redeploy the report.
The Delete Metrics task allows you to remove specified metrics that you do not want to include in the report or that were collected unintentionally. It is especially helpful when you have an obsolete metric, collected the wrong metric, or specified an incorrect metric such as "C:" instead of "C:\". The Delete Metrics task removes the existing metrics, but does not prevent Analysis Center from collecting the same metrics again.
To remove the metrics that you do not want to include in reports:
Launch the Admin Console.
In the left navigation pane, click Data Management > Delete Metrics.
Select the metrics you want to delete and follow the on-screen prompts.
Ensure that you do not remove metrics that are currently in your reports. When you delete a live metric, Analysis Center stops collecting data for it, which results in broken links and missing data in your Analysis Center reports.
To begin collecting data again for a live metric that you deleted by mistake, run a new Knowledge Script job in AppManager to regenerate the deleted metric. Then, reconfigure all reports that reference the deleted metric. However, the new Knowledge Script job does not retrieve data that Analysis Center would have collected during the period when the links were broken.
After the specified metrics are deleted, Analysis Center reprocesses metric dimensions and partitions, and does not display these metrics in the Analysis Center reports. To view a deployed report without the specified metrics in SSRS, redeploy the report.
The Data Cleanup task is helpful if Analysis Center has already collected a range of data that you do not need. The ETL Filter task prevents Analysis Center from collecting specific data, but the Data Cleanup task removes the existing data. The Data Cleanup task does not prevent Analysis Center from collecting the same data again.
You can also use this task to remove data points only for specific machines or Knowledge Scripts. If you do not want data from the previous year in your reports, you can remove data points collected from all machines and Knowledge Scripts before that specific date.
To remove data collected for machines or Knowledge Scripts in a particular UTC time frame:
Launch the Admin Console.
In the left navigation pane, click Data Management > Data Cleanup.
Select one or more criteria and follow the on-screen prompts.
If you do not specify a machine or Knowledge Script, Analysis Center removes data collected for all machines and Knowledge Scripts. If you do not specify a time frame, Analysis Center removes data right from data inception time until now.
After the data points are removed, Analysis Center re-creates partitions based on the currently available data and does not display those data points in Analysis Center reports.
The Rename Metrics task allows you to modify the names of metrics specified in reports. Analysis Center continues to use the original metric name internally. This task is helpful when you want to include a more business-oriented and less technical metric name in your reports. You can also rename the metric if the Knowledge Script writes a metric incorrectly, or if the metric name changes over time and you want to publish just one name.
To modify the names of specified metrics:
Launch the Admin Console.
In the left navigation pane, click Data Management > Rename Metrics.
The Metric column displays the metric type and the original internal names of the parent and child metrics. The Edit Metric column displays the new alias as the Analysis Center report displays it.
In the Edit Metrics column, select the metrics you want to rename and specify the new name.
You can rename multiple metrics at the same time. For example, you can add a parent metric name to each child metric you select or add the same prefix to multiple metrics.
Click Apply Changes.
(Conditional) To revert the metric name, right-click the metric and click Restore Default.
After you rename a metric, Analysis Center processes only the metric dimensions, and does not process the OLAP database. To view a deployed report with the renamed metric in SSRS, redeploy the report.
Certain predefined reports delivered with Analysis Center and AppManager Report Packs for Analysis Center, such as SystemUptime, VoIP, Exchange 2007, Virtual Center, and custom reports, contain specific metric names built into the metric selection filter of the report itself. If you rename one of these metrics, they might no longer be available in the metric context selector of the predefined report or the report might no longer return data for the selected metric names. To fix the broken reports, reset the metric name to its default name. If you are unsure about a specific report, please contact NetIQ Technical Support.