Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
FDMEE loads monitoring outside FDMEE

Hello Hyperion experts.. Is there a way we can monitor the FDMEE load at which step the current load is running and such details without logging into FDMEE. I have a group of users
who would need to know the load status (exact step of the fish) of all current loads and IT cannot grant them access to FDMEE, rather we want to pull that information from FDMEE repository
and display outside FDMEE as a report. Is that possible ? Is there a way in which we can capture the load status and granular details from Hyperion repository. And yes email notifications of start and end of the loads
is not acceptable solution. We are on 11.1.2.4 version Thanks !
Best Answer
-
As John says the information you would need is in the table TLOGPROCESS. As I see it you have a number of choices:
1. Create a Jython FDMEE custom script to read the TLOGPROCESS table which then creates the output (probably Excel)
2. Create a link to your FDMEE database from Excel and pull the data directly into a spreadsheet
3. Automate (and maybe modify) an existing Process Monitor Report
They all have their pros and cons. The easiest will be number 3 - you just have to devise a method of automating the production of the report (off the top f my head - drop a file as a trigger into a folder, a Windows batch file monitors that folder, when the file exists an FDMEE batch is called logging on as an automation user and the output file from the report is then saved to a folder). You can encrypt the automation user's password so you are not giving the group of users any logon info to FDMEE.
Answers
-
Have a look at the tables in the FDMEE database starting with AIF_PROCESS_*
If you want to know the status in the workflow then have a look at TLOGPROCESS
Cheers
John
-
As John says the information you would need is in the table TLOGPROCESS. As I see it you have a number of choices:
1. Create a Jython FDMEE custom script to read the TLOGPROCESS table which then creates the output (probably Excel)
2. Create a link to your FDMEE database from Excel and pull the data directly into a spreadsheet
3. Automate (and maybe modify) an existing Process Monitor Report
They all have their pros and cons. The easiest will be number 3 - you just have to devise a method of automating the production of the report (off the top f my head - drop a file as a trigger into a folder, a Windows batch file monitors that folder, when the file exists an FDMEE batch is called logging on as an automation user and the output file from the report is then saved to a folder). You can encrypt the automation user's password so you are not giving the group of users any logon info to FDMEE.
-
Thank you John and user6692921 for the leads. I see two tables tlogprocess , tlogprocessstates that start with TLOG in the repository DB and i'm trying to understand the tables
and we will see if the required information is captured in these tables, If we are able to figure out the select query we will most likely use that and connect from an reporting tool
in the landscape and provide the users access to the report that refreshes on demand.