Drillback from Target System Error (from HFM to FDM) "Error: No locations were found matching the passed intersection values."

Drillback from Target System Error (from HFM to FDM) "Error: No locations were found matching the passed intersection values."
		Modified 19-AUG-2010

---

Applies to:

Hyperion Financial Data Quality Management - Version: 9.2.0.0.00 to 11.1.2.0.00 - Release: 9.2 to 11.1
Information in this document applies to any platform.

Symptoms

When performing an audit intersection from HFM back to FDM the following error is returned: 

Error: No locations were found matching the passed intersection values. Please verify: 
1) that the target system (originating the drillback) is properly configured; 
2) that FDM POVs have not been retroactively modified or compromised. 

Cause

When updating the HFM adapter to the latest adaptor for FDM from a previous adaptor, by design, the target periods and target years automatically get set to [EMPTY] in the tPOVPeriodAdapter table as well as the target category from the tPOVCategoryAdapter table.

This causes the intersection of data that you import into FDM to store the target period value as [EMPTY] in the vdatafact view, which is what the DrillBack process is querying against to locate the source record..

Solution

To resolve the issue the tPOVPeriodAdaptortPOVPeriodAdaptor and tPOVCategoryAdaptortPOVCategoryAdaptor tables need to have the Target Period, Target Year, and Target Category values updated from [EMPTY] to the proper target value.

#1 Launch Workbench and login to the FDM Application that HFM is attempting to drillback to

#2 Choose the Tools menu | Table Editor

#3 In the table drop-down, choose tPOVCategoryAdaptertPOVCategoryAdapter

#4 Manually type in the HFM Target Category into the CatTarget field

#5 Save the table by clicking the diskette icon

#6 In the drop-down of table editor, choose tPOVPeriodAdaptertPOVPeriodAdapter

#7 Manually type in the HFM Target Period into the PeriodTarget field and the HFM Target Year into the YearTarget field

#8 Save the table by clicking the diskette icon

#9 Re-import the source file (very important since it will use the correct data this time) and complete the FDM Workflow to reload the data to HFM.

**Note: Table Editor is Not Available in Workbench Beginning with the 11.x release.  The updates must be done directly in the database using database utilities.