When attempting to install the cubes for the Data Loss Prevention report pack for IT Analytics for Data Loss Prevention 14 the console says the pre-requisites for the DLP cubes haven't been meet with a message that says 'IT Analytics Data Loss Prevention Connection must be installed'.
Data Loss Prevention 14 supports the use of Oracle 12, however the report pack hasn't been updated to support this version of Oracle. This causes 4 necessary functions & views to not get created. This affects both the stand alone version of IT Analytics and the Data Loss Prevention 3.7 report pack for ITMS.
Need to update the current SQL stored procedure spITAnalytics_DLP_CreateViews in the database Symantec_CMDB or IT Analytics.
Download the attached spITAnalytics_DLP_CreateViews_updated.sql file.
Open SQL Management Studio and connect to the SQL server housing the Symantec_CMDB or IT Analytics database.
Run the updated spITAnalytics_DLP_CreateViews script to update the stored procedure
Run exec spITAnalytics_DLP_CreateViews to create the missing functions and views.