Oh no, this is not about converting water to wine or fog to vodka. If you are here looking for some a miracle, then you are at the wrong place.
However, if you came looking for an option to convert your existing Oracle Hyperion Planning/Oracle Essbase application to OneStream platform, then read along. Before I can talk about H2O Converter, I would ask you to read the disclaimer section of this blog site. I hope you did read it, now that you are back I need to reiterate that all contents on this blog are mine and is not a reflection of OneStream Software or any other corporation.
Any recommendations provided here are not validated by OneStream software.
Hyperion to OneStream converter is a “Make your consultant life easier” tool. As the name implies, it helps you convert a Hyperion (Planning/Essbase) application into a OneStream application. The tool is intended to use as a starting platform only. (It means you cannot just use this tool to convert the application and be done with it :)) Both softwares tries to solve the problem in multiple ways and they are different, do keep that in mind when you use this utility.
At this point, H2O converter can convert metadata of Planning and Essbase into OneStream equivalent metadata file; it can also provide you with a readable/convertible security file for Planning.
H2O converter can convert both Oracle Essbase and Oracle Hyperion Planning applications.
For all the Essbase folks out there, you can use a
- Database XML export
- Flat files, for metadata
For all the Planning folks out there, you can use a
- Planning LCM extract
- Flat files, for metadata
Oracle Essbase conversion
To perform Essbase migration, you can provide the XML/file location
If you are using a file, provide the file delimiter, once done select a file location (full file path) for OS metadata XML file.
If you are using an Outline XML file, you can select the dimensions you want to convert using “Show dimensions.”
Make OS Dimension type
For selected dimensions, you can use the drop down to make them an OS dimension as shown above.
Attributes and UDAs to Text property
Attributes and UDAs can be converted to OS text types if this option is selected then attributes cannot be created as a dimension.
Caffeinated and Ounces attribute members got converted to Text property.
Market type UDA is converted to Text property.
Essbase formula and consolidation members
A file with all Essbase formula and the members with different consolidation other than addition is extracted and kept in separate files.
Oracle Hyperion Planning conversion
Planning LCM option will require you to unzip the file and select the Planning application folder.
You got same options like converting attributes, UDAs to Text property.
You can export the security assignment (if present in the LCM extract), this will create 3 files
- OS_SecurityDefinition – a file that can be used with another utility to produce a security file for OneStream
- OS_SecurityDefinition_All – a file that contains all definitions in a readable format
- OS_SecurityDefinition_Exception – a file that contains exceptions
Currency attribute to OS Entity currency
If Planning contains a current attribute dimension assigned to Entity dimension you can use this to convert to OneStream Entity currency.
Oracle Hyperion Planning account to OS Account type
If you are converting a Planning Account dimension, the utility will assign OS AccountTypes by looking at Planning Variance Reporting, Time Balance, and Planning Account Types. Following tables illustrate how the conversion works.
A file similar to one given below is produced after a successful conversion.
File based conversion
File extract works the same way for both Planning and Essbase.
You can only convert one dimension, and you can choose the OS dimension type and the name of the dimension.
You can read about H2O converter here.
You can download H2O converter using this link.