Weekly Backup of Hyperion

Weekly Backup of Hyperion

Duncan
Duncan

February 21st, 2013, 10:40 pm #1

Hi,

With Hyperion 11.1.2.0 I used a backup script using LCM xml files that looked something like this:

--------------------------------------------------------
weeklybackup.bat
:: This will create a timestap like yyyy-mm-dd.
set TIMESTAMP=%DATE:~10,4%-%DATE:~4,2%-%DATE:~7,2%

call utility.bat Plan1.xml >weeklybkuplog%TIMESTAMP%.txt
call utility.bat Plan2.xml >>weeklybkuplog%TIMESTAMP%.txt
call utility.bat Reporting.xml >>weeklybkuplog%TIMESTAMP%.txt
call RenameMigration.bat

--------------------------------------------------------

RenameMigration.bat
:: This will create a timestap like yyyy-mm-dd.
set TIMESTAMP=%DATE:~10,4%-%DATE:~4,2%-%DATE:~7,2%
CD D:\Oracle\Middleware\user_projects\epmsystem1\import_export\admin@Native Directory
RENAME Plan1 "Plan1-%TIMESTAMP%"
RENAME Plan2 "Plan2-%TIMESTAMP%"
RENAME Reporting "Reporting-%TIMESTAMP%"

--------------------------------------------------------

Now that we're on Hyperion 11.1.2.2 I want to do something similar. Problem is I can't figure out how to generate the .xml files for the LCM migration definition. Is there a new method to automate backups?

Thanks everyone.
Quote
Share

Joined: November 15th, 2007, 1:21 pm

February 21st, 2013, 10:44 pm #2

Hey Duncan,

If you were to go in to Shared Services, and create a manual LCM, there is an option to save the LCM definition near the end of the process.

Does that make sense?

JM
Quote
Like
Share

Duncan
Duncan

February 21st, 2013, 11:21 pm #3

I know what you're talking about but it's driving me crazy because I can't find that option anymore.

I just see "Export" and no longer see "define migration"
Quote
Share

Joined: November 26th, 2001, 10:15 pm

February 22nd, 2013, 2:17 pm #4

There is a section in the docs that talks about sample files:
http://docs.oracle.com/cd/E17236_01/epm ... 05s02.html

In fact if you look in the docs, every tool has sample export files. Oh joy, now we get to blunder through defining these things instead of having the tool do it for us. :)

Here's something *really* weird -- I am migrating a Planning classic app from LCM file output. When I import a dimension to Planning it is *immediately* moved to Essbase with no Essbase refresh required. That is something I do not believe I saw in 11.1.2.1. I had to triple check to prove that I wasn't entering some kind of LCM-induced haze where I did Planning refreshes but had no memory of them. Nope, LCM does it automatically. Kind of nice, actually.

Regards,

Cameron Lackpour
Quote
Like
Share

Duncan
Duncan

February 24th, 2013, 4:17 am #5

Thanks Cameron!

Looks like I need to get down and dirty with some XML.

At least I have the template from 11.1.2.0
:)

Also, it did seem like importing the planning application went unusually smooth....

No error messages and multiple imports. Did it in one trick!
Quote
Share

Joined: February 24th, 2012, 8:50 pm

February 25th, 2013, 2:26 pm #6

I know what you're talking about but it's driving me crazy because I can't find that option anymore.

I just see "Export" and no longer see "define migration"
11.1.2.2 LCM creates Import.xml and Export.xml, you can make use of these to perform an Import or export
Quote
Like
Share

Joined: November 26th, 2001, 10:15 pm

February 25th, 2013, 3:33 pm #7

Wow, it would have been nice if that was documented. But it sure beats having to build the xml by hand.

Regards,

Cameron Lackpour
Quote
Like
Share

Joined: February 24th, 2012, 8:50 pm

February 25th, 2013, 4:53 pm #8

It's the import.xml and Export.xml under import_export\<LCM_Folder>.

I was planning to write a blog post on this (then forgot about it).
Quote
Like
Share

Duncan
Duncan

February 26th, 2013, 11:41 pm #9

And there it is...

Very awesome indeed!
Quote
Share


Confirmation of reply: