While reviewing the custom attributes, while verifying the content of all of the dimensions for the custom attributes, we ran the query:
Select * from vITAnalytics_DLP_IncidentCustomAttributesFact
This returned results, but the CUSTOMATTRIBUTEINDEXKEY Column was displaying as a scientific notation number, instead of just a number, which was wrong
ITA For DLP 8.0x
We reviewed then the SQL function, vITAnalytics_DLP_IncidentCustomAttributesFact - The Select statement generating the data for CUSTOMATTRIBUTEINDEXKEY was problematic, generating the scientific notation values instead of a regular number value.
We isolated the SQL statements to see what the data returns were like. They returned scientifc notation results for that column.
We need to update the SQL query in the SQL views for CustomAttributesFact to properly convert the data coming from the Oracle DLP database to be displayed as a whole number instead scientific notation.
Open SQL Management Studio & connect to the SQL Server housing the ITAnalytics database.
Find vITAnalytics_DLP_IncidentCustomAttributesFact in the Object view tree of SQL Management Studio under ITAnalytics\Views.
Right-click on vITAnalytics_DLP_IncidentCustomAttributesFact and choose Script View As\Alter To\New Query Window
Update the SQL query to added the BOLD TEXT in the function to read:
(10000000000 * 1)+INCIDENTID as INCIDENTIDKEY
,(10000000000 * 1) + CUSTOMATTRIBUTESRECORDID as CUSTOMATTRIBUTESRECORDID
,(10000000000 * 1) + convert (nvarchar (255), CUSTOMATTRIBUTEINDEX) as CUSTOMATTRIBUTEINDEXKEY
--,(10000000001 * 1) as CUSTOMATTRIBUTEINDEXKEY
,convert (nvarchar (255), CUSTOMATTRIBUTEVALUE) as CUSTOMATTRIBUTEVALUE
5. Execute the updated query to update the view.
6. Repeat steps 2-5 for views: vITAnalytics_DLP_EndpointIncidentCustomAttributesFact, vITAnalytics_DLP_NetworkIncidentCustomAttributesFact, & ITAnalytics_DLP_NetworkIncidentCustomAttributesFact
Once completed, and reprocessing of the cube had occured, this resolved the issue.
Subscribing will provide email updates when this Article is updated. Login is required.