Skip to main content

SHARED SERVICE BACKUP AUTOMATION


LCM has a graphical interface to take backup of the applications and Foundation services. We can also take backup using a command line utility which again can be used to automate and schedule backups. The following steps are needed to be followed in order to do automation of Shared Services or Application backup. Here the steps are shown of automation of backup of Foundation services. Same steps hold true for any Planning Application as well. The steps are as follows:



     1)      First you need to login to Shared Services to create a migration definition xml.
2)  Go to Application Groups-> Foundation-> Shared Services and select all artifacts and click on Define Migration.
3) Click on NEXT.
4) Select Destination as File system and give a name like – ‘SharedServicebkup’.
5) Click on next.
6) Click on Save Migration Definition.
7)  A pop up opens asking you to save the xml file on your local machine. Save it and a file will be saved with the name MigrationDefinition.xml. Then using WinSCP copy the xml file on the planning server in the directory - /Hyperion/Oracle/Middleware/user_projects/epmsystem1/bin.


                                                                                                                                                                

 8) Then log into the Planning server and go to the directory using the command :

      cd /Hyperion/Oracle/Middleware/user_projects/epmsystem1/bin

Here the utility Utility.sh will be used to take Shared Services backup using the MigrationDefinition.xml file. The xml file contains the details of all the artifacts that are to be backed up.

9) First time we run the  command   ./Utility.sh MigrationDefinition.xml
and it asks for username and password of Shared Services.

10)  Enter the credentials and let it run for the first time. After it runs for the first time the username and the password get saved into the xml file in an encrypted format, so from second time onwards it does not need any credentials.

11) Now a shell script or a batch file can be created with the corresponding commands and can be scheduled for a regular backup.
./Utility.sh MigrationDefinition.xml        ->                            Shell Script (Linux Server)
               Utility.bat Migratio0nDefinition.xml    ->                            Batch Script(Windows Server)

            12)  The backup is formed in the same directory as the utility Utility.sh (i.e/Hyperion/Oracle/Middleware/user_projects/epmsystem1/bin) with the name (SharedServicesbackup) that was provided while creating the MigrationDefinition.xml.




Thanks!!








Popular posts from this blog

Essbase for Beginners: Data Block concepts Part A

An Essbase outline has a number of dimensions.  The number of dimensions can range in quantity and size, but each dimension is identified as a dense or sparse dimension.  As we understood the concept of Dense and Sparse in our last discussion, let’s begin with the cocept of data blocks now. To understand this, let’s carry forward our hierarchy of 5 dimensions in a test application in my previous post.. We have 3 dense and 2 sparse dimensions each with 3 stored members. So let’s begin: Number of Existing Blocks = (potential number of blocks) * estimated density= 9 Block Size = Dense Stored * Dense Stored * Dense Stored * 8 bytes = 3*3*3 *8 = 216 Potential number of blocks = Sparse Stored * Sparse Stored = 9 If all dimensions are assigned as Dense, Number of Existing Blocks = (potential number of blocks) * estimated density= 1 Block Size = Dense Stored * Dense Stored * Dense Stored * 8 bytes = 3*3*3*3*3 *8 = 1944 Potential number of bloc...
Home

Shared Connection and Private Connection

You connect to data sources through shared or private connections. Shared Connections •Shared connections are stored in a central location and are available to multiple users through the Smart View Panel. You cannot add, edit, or rename shared connections, but you can save them as private connections, which you can edit and rename. Private Connections •Private connections are those that you create by saving a shared connection to your local computer or by entering a URL to a provider that is not configured for shared connections. When you create a private connection, it becomes the active connection. Shared Connections : 1. From the Smart View ribbon, click  Panel . 2. From Smart View Home or from the menu displayed when you click the arrow next to Home button, do one of the following: • Click a connection name under  Recently U sed . You can click    to pin items to this list. • Select  Shared Connections  to open th...
Home

Essbase for Beginners: Data Block concepts Part B

Below concepts involve Data Blocks in some way or the other, so to understand how Data Blocks behave it’s good to understand these concepts: Let's Begin!! Compression Clean and Dirty Blocks Fragmentation Restructure Compression: When Essbase stores blocks to disk, it can compress the data blocks using one of the following compression methods, this is based on the type of data that is being loaded into the Essbase database. Essbase provides several options for data compression: 1. Bitmap compression : This is the default compression method. Essbase stores only non-missing values and uses a bitmapping scheme. A bitmap uses one bit for each cell in the data block, whether the cell value is missing or non-missing. When a data block is not compressed, Essbase uses 8 bytes to store every non-missing cell. 2. Run-length encoding (RLE): Essbase compresses repetitive, consecutive values --any value that repeats three or more times consecutively, including...
Home