Friday, June 1, 2018

Duplicate Hyperion Planning app creation (with a different name) from LCM Backup



Hyperion administrators frequently have to restore a planning application from an LCM backup, but not very often the need arises to create a duplicate application with a different name from a backup. There are no clear-cut processes to do it but there are workarounds to achieve this objective.
In this blog, we will cover the steps to create a new planning application from an existing application LCM backup. As mentioned earlier, it is not a straight forward process, but we can hack some existing backup files to get this done.

Existing Planning Application:
Application Name: TestApp
Datasource Name: FinCon

To Be Created:
Application Name: TestApp1
Datasource Name: FinCon1


Step#1 

Create a new datasource (FinCon1) connection from Planning administration UI. (Request your DBA to create a new database schema if required)


Step#2

 Take LCM backup of the existing application and download it to your computer.


Step#3

Extract the files from the LCM to a temporary folder.


Step#4

Find the file “Import.xml” and change the application name from “TestApp” to “TestApp1”. Save your changes and close the file.





Step#5

Find the file “ApplicationDetails.xpad” and change the application name from “TestApp” to “TestApp1”. Also change the datasource name from “FinCon” to “FinCon1”. Save your changes and close the file.




Step#6

Select all the files in the extracted LCM backup folder and create a new archive/zip file.  This is a bit tricky step as you shouldn’t create zip file from the LCM root folder.

                   
Step#7

Navigate to Shared Services->File System.  Upload the zipped updated LCM backup.


Step#8

Expand the uploaded backup file, select the application folder. In the Artifact List shown in the right pane you may want to unselect Security, User Preferences and User Variables as they are optional and may not be relevant for the new application. Now click on Import to progress with the application creation process


A prompt would show up with the new application name (TestApp1). Click Import.

         
Step#9

Once the import is successful, go to Navigate->Application->Refresh in workspace main menu to refresh the application list. Then, go to Navigate->Application->Planning and open the new application (TestApp1) from the list.


Step#10

You may want to load data from the source application (TestApp) if data is not part of the LCM backup. Once data is loaded, go ahead and run necessary aggregation scripts before releasing it to your users.