Data loaded in HFM 22.214.171.124 using FDM 126.96.36.199 and it has been replaced by ERP integrator 188.8.131.52.501. When we perform drill through from Financial reporting report it is navigating to the FDM landing page instead of ERP integrator landing page. In FDM landing page, showing the ERROR:
"Error: Error Retrieving recordset"
Anyone please help me to solve this issue.
I suggest you create a HFM Web Form with the same intersections as your report and then try to drill down. If you are able to drill down , then it might be some thing do with FR drill configuration.
I try to drill down from Data form and also from data grid, it is showing both the options "Drill through to ERP integrator" and "Drill through to FDM". When I select the option "Drill through to ERP integrator" it is navigating to the ERP landing page properly and from there I could drill down to the source system.
But, If I select the option "Drill through to FDM" it is showing the same error that i have mentioned above.
My guess is that , when you loaded the data from ERPi the drill regions created by FDM have been over written. Hence you are not able to drill down to the FDM page. This happens in most of the scenarios , where if the data is loaded across an intersection using FDM and then again the data is loaded in the same intersection using some other way like Flat Files or ERPi the Drill Regions or Drill POVs get compromised.
To confirm whether your FDM drill back is working or not , create a simple form using any of the intersections from your dimensionS ( not the same ones used above ) and load a single line of data using FDM across those intersections in the form. Try drilling back to the FDM Landing Page and check. Same way , create a report for the same intersections and check drill back to FDM. Remember to check the :Drill - Through" check box in the property grid in the Grid Properties for that report.
Now, I have loaded data using ERP integrator, if I drill through from FR report it is routing to the FDM landing page instead of ERP integrator landing page. Please give me a clear solution for this issue.
Edited by: 931561 on Jun 14, 2012 4:05 AM
I am not sure whether you can drill down to the ERPi Landing Page using FR. By ERPi landing page , I mean it should display the GL source accounts from ERP. I doubt whether this is supported in FR. I know that when data is loaded using a combination of ERPi and FDM you can drill down from the FR report to the FDM Landing page , which would display the source records which have been loaded in the ERPi schema in the AIF_GL_BALANCES_STG table. This is transferred to FDM Application schema using a db link.
Please check with Oracle For The ERPi Landing Page scenario.