Social Icons

Thursday, August 15, 2013

Oracle Hyperion DRM Export Format

Oracle Hyperion DRM enables you to export the hierarchies with different encodings (ASCII, Unicode, UTF-8, and so on). 

We had our environment setup where we send the Metadata Feed from DRM to a Staging environment and then it goes to Hyperion Essbase Application. This is an ASO Application and we had a lot of Key Metric Formulas which are very huge and we thought of having a seperate feed in Parent, Child,Formula format and send it directly to Essbase Server which is sitting on a UNIX Box and somehow the metadata build is not happening. After a lot of hits and trials, we could finally find out that the issue was with the encoding which was set to UTF-8 by default. 

We changed the Encoding to ASCII and when the file was FTPed to the UNIX box and ran the Metadata built, it ran successfully. 

There are a couple of things that you can do to overcome this issue.  

  1. Change the Encoding of file to ASCII if you are sure that your members does not have any special characters and just pure text.
  2. 2. Check the Configuration settings of the the FTP tool that you are using if you want to transfer in UTF-8 / Unicode Format

Hope this information Help. Let me know if there are any other ways to handle this.

Happy Learning!!!

No comments:

Post a Comment