Report performance degrade for OBIEE when connecting to HFM using ADM Driver
Hi,
We are using HFM 11.1.2.2 and OBIEE 11.1.1.7 in Windows 2008 R2 64 bit environment. Here OBIEE is using Hyperion ADM Driver to connect to HFM and get the data for reporting. We are seeing very slow response on the report rendering process in OBIEE. In HFM application, we have 14 dimensions, 8 standard and 6 custom.
Question is whether anyone has used ADM driver to report on HFM? Is there any performance issue for ADM driver in general or is it specific to our environment only? BTW, we are using multiple server environment with 8 Core, 16 GB RAM.
It will be helpful if you can share some performance improvement tips for this ADM driver based reporting on OBIEE.