A frequent issue With FDMEE processing is the time it takes to load data into a target system. One issue that significantly slows FDMEE processing is the use of LIKE mapping. If the number of LIKE Mappings gets large then the response time can be overly burdensome and may lead the user to wonder if there is an issue and the system has stopped processing.
FDMEE’s Universal Data Adapter (UDA) allows you to pull records from an external table or view. The UDA can be utilized to connect to a source database’s table or view when a standard FDMEE adapter is not available. When defining the UDA as a Source Adapter, filters can be applied by configuring parameters on “Parameters” tab.
This blog is to illustrate and walk you through the process of creating a CSV extract file from your Hyperion applications. For this example, I’m using Oracle’s COMMA4DIM sample application. Additionally, this is also useful for those who wish to use their Hyperion applications as a data source.