After uninstalling and reinstalling an IT Analytics report pack, such as the Altiris IT Analytics Client Server Management Pack, custom Cube Views that were previously saved are no longer present. These then require the user to be manually recreated.
Custom Cube Views are not kept when an IT Analytics report pack is uninstalled.
The cube views are saved in the CMDB database in the State field of the Item table for each Cube. The format is slightly different for post-7.6 Cube Browser console and old Office Web Components based console.
For example, I have created test custom view based on Computers Cube and named it QWERTY.
Here is how state field for that Cube looks in Item table in CMDB:
Attached set of scripts will copy the custom Cube View data records from the Symantec_CMDB into a new table for safe keeping. These "backed up" data records can then be later restored once the IT Analytics report pack is reinstalled. To accomplish this, SQL scripts for both versions of console are attached to this article that can perform a backup and restore of custom IT Analytics Cube Views. Instructions on how to use the scripts are provided inside of them.
Imported Document ID: TECH189590
SQL script "Backup IT Analytics custom Cube Views.sql" will backup custom Cube View data from the Symantec_CMDB database to a new table the script creates.