Hyperion DRM Query record limit

Recently we had an issue while running various queries in DRM, we would only get 5000 records.  While looking at System Preferences, this was discovered.
You can go into Administer, System Preferences and then WarnHL.
Default limit is 5000 records.  You can change this limit to a higher number, save the changes and re-run your queries.

Hyperion Calculation Manager Issues With Hyperion Planning

 Tuning considerations

• In the calcMgrConfig.properties file you may want to increase the HBR.timeout to 60000 and remove the comment # from this row
• In addition to traditional java settings of Xms and Xms you may want to consider increasing the default stack size as well –Xss
• Oracle recommends rules that take longer than one hour to be run in batch, not on the web but if you have some that take longer, consider increasing the session timeout on the web application server

11.1.2.x

Most issues with calculation manager will be captured in one of the following logs by default:

\\Oracle\Middleware\user_projects\domains\EPMSystem\servers\CalcMgr0\logs