Need help in FR Reports Migration which are built on HFM
846286Nov 10 2011 — edited Nov 11 2011Hi,
We have all the Hyperion applications [HFM, Shared Services, FR and other BI + Services] on Hyperion 9.3.1.0 and we have to migrate the FR reports that are built in PROD environment to UAT.
These FR Reports which are available on PROD are working fine with out any issues.
To migrate these FR reports from PROD to UAT, i have followed below steps.
1. Export the FR reports one by one from PROD Workspace to .des files.
2. Login to UAT Workspace, Import -> as "Financial Reports" -> select the file and then click on "Import".
3. Select "Tools" -> "Change Database Connections" on Workspace , select the file and changed the DB connection file to the PROD HFM Database Connection file.
I have run the copy utility on HFM application to sync up the data between the environments and i have verified for the data too. Its looking good.
When i try to open up the FR report, I am unable to get the data on UAT environment and I am suspecting Connection related issues as my collegue hinted that there could be issue on the row and column level on the FR Grids. I haven't worked much on FR side, so not sure whats the issue.
Though i am not sure, I have tried changing the FR report connection details by opening it on "notepad" and tried importing the file and tried opening it. Even then i see no data on the report.
Can you please look into my steps and help me in getting FR reports run on UAT environment. Thanks you.
*Tried checking on the Forums, but I am unable to find any related information.