search cancel

Imported Cost Center Data not showing in applicable reports

book

Article ID: 243145

calendar_today

Updated On:

Products

IT Management Suite Asset Management Solution Asset Management Suite

Issue/Introduction

After an off-box upgrade, importing cost center data exported from the old database does not show Cost Center data in the  
Assets by Type, Status, Department, Cost Center and Location report. 

Cause

The connector import was missing configurations to create an association to a Cost Center.

The Customer

  • Created a data source from a SQL query ran from the old database:

SELECT
 ac.[Name],
 cc.[Name] as 'Owner',
 id.[Ownership Percentage]
FROM inv_cost_center_ownership AS id
JOIN Inv_AeX_AC_Identification AS ac on  ac.[GUID] = id.[_ResourceGuid]
join vRM_Cost_Center_Item cc on cc.Guid = id.Owner
where ac.guid <> ''

  • Saved the results with headers to a CSV file.
  • Created a Data Connector data source using the CSV file
  • Created a resource import/export rule and verified the Dataclass mapping was correct.

 

 

Environment

Release : 8.x

Resolution

Added the association to a Cost Center.

 

 

 

Attachments