Monday, June 3, 2013

#2. HFM Smart View error


Users in HFM smartview receives the following error message when trying to refresh their smartview spreadsheet.
Unknown Error in HFMProviderData at the root level is invalid. Line 1, position 1. 


Solution : Since the user is trying to connect to HFM, Login to EPM HFM database schema and check the values for USER_PARAMS table.
Delete the row entries for the particular users' ID/name from the rows displayed.
Reason: The issue is caused because an incomplete Point of View details being written to the users last POV in the UserParams table in the Hyperion Financial Management repository database. 
Deleting the users' POV data from the USER_PARAMS table solves the issue.
 

No comments:

Post a Comment