Recreate missing KPI in the appropriate location or purge the metric/KPI entry from the Metrics table in the ICA database (if KPI is no longer needed).
To recreate the missing KPI, pull the information from the metrics table as to where the KPI should be located. Out-of-the-box KPIs are located in the ICA cube on the SQL Analysis Server. For recreating KPIs, the information can either be pulled from a backup of the Analysis Services database or another instance of the ICA cube.
If the missing KPI is no longer required, search for the corresponding metric record in the Metrics table in the ICA database and delete the record from the table. It is advisable to create a backup of the Metrics table prior to changing the data.
CAUTION: These commands assume a basic understanding of SQL. Any changes to the Database pose the potential to affect the operation of the product. ALWAYS ENSURE YOU HAVE A BACKUP OF YOUR DATABASE BEFORE MAKING CHANGES.
In order for Symantec to provide full support of the schema and the DB environment, you have to be running the database in the version specific to the used version as outlined in the System Requirements Guide. Please see the limitations section at http://www.symantec.com/docs/TECH220433
Thanks for your feedback. Let us know if you have additional comments below. (requires login)