Hi,
11.1.2.2
Extracting data from HFM can hardly get any more trivial, right? Well, if it comes to extracting base level data, then probably yes. In our HFM application we have about 25 Scenarios, 800 odd Entities and 6 Years worth of data. For the purposes of building a company wide data warehouse, we now need to extract all HFM data on daily basis including all parent levels, all hierarchies across all dimensions and all dynamic accounts. When doing this just for a single base level Entity and selecting [Hierarchy] for all other dimensions in the Extended Analytics POV, and selecting calculated data and dynamic accounts, the output to file or database alike times out after ....24 hours!
Exploring the next avenue with our existing EAL link to Essbase, we tried to output the HFM data using a EAL Bridge to a relation database, hoping we can pull only the changed data in regular intervals. Apparently, the EAL output to relational database cannot be incremental, it can only be full which brings us back to the original problem and impractical extract times.
Does anyone have a better idea of how to get everything out of HFM in a reasonable amount of time?
Many thanks!