#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.

 

#1. How to extract the various details of reports and output cycles of EPM workspace from backend.

The workspace details are stored in Hyperion RDBMS in a table named V8_CONTAINER.

Connect to the schema created for Reporting and Analysis.

Run the below query to get the required details:

SELECT SYS_CONNECT_BY_PATH(name,'/')

FROM V8_CONTAINER

START WITH container_uuid ='REPORTMART'

CONNECT BY PRIOR container_uuid = parent_folder_uuid