#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