Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Strategy for keeping historical data from HFM

iamjorgensenFeb 9 2016 — edited Mar 9 2016

Hi

We have a application that we need for historical purposes - including data from many years back. We need to be able to access this for many years to come, but it is a burden when it comes to both storage usage and when it comes to upgrading. We are currently planning an upgrade to HFM 11.1.2.4.

Anybody have good alternatives to keeping historical data without performing migrations etc? Any other tools that could be used for keeping such data? HFM has an export option to database - creating a star schema of the data, is this something that can be used? We only need sentral access to this data and it would be sufficient to be able to access it using e.g. SmartView (or equivalent tool).

By having some alternatives here we could "strip" the staging and production applications from data only needed on ad-hoc basis. Any input would be appreciated.

Brgds

Christian

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 6 2016
Added on Feb 9 2016
8 comments
2,452 views