Thursday, July 30, 2015

Extracting Data file from HFM application

Here comes the situation.
I set up a new DEV environment for HFM. After installation and configuration was done, I was required to get current application in DEV.
First, application profile is created via HFM desktop client. Please refer following article to create application profile.
http://evolvewithhyperion.blogspot.in/2015/07/creating-application-profile-for-hfm.html

Then, through workspace, HFM application is created.

After we create an application, we load application elements like metadata, member lists, rules, and security files. 
Now, we can load multiple files and then the system loads files in proper sequence.

But if we are loading individual application elements, we need to load them in proper sequence given below:
1) Security
2) Metadata
3) Member Lists
4) Rules

There are many different ways to load application elements but here we are loading using extract and load tasks from workspace.


  • Application security
In workspace, open application.
Administration --> Extract tasks --> Extract Security.

Save the security file at required location.
Load security to new application from load tasks.



  • Application Metadata
1.
From Extract Tasks, select Extract Metadata.



2.
In the Delimiter Character text box, enter the character to be used i.e. “;” – semicolon  to separate the metadata in the file.


 
3.
Select the Financial Management Application Format checkbox to extract the file in APP format. Clear the Financial Management Application Format checkbox to extract the file in XML format.



4.
Select the types of metadata to extract and click Extract.



5.
In the Download Instructions, click the Click here to download link.



6.
Click Save.


7.
Browse to your backup location. In the "Save as type" list, select All Files and click Save.
8.
Navigate to your backup location and verify that the APP extract file was saved and provide this extract file with app extension.




1 comment: