Sample Migration Definition Files

The product code used in the migration definition files for Essbase is ESBAPP. All sample migration definition files are provided in EPM_ORACLE_HOME/common/utilities/LCM/11.1.2.1/Sample.

Application-to-Application Migration

<?xml version="1.0" encoding="UTF-8"?>
<Package name="web-migration" description="migrating product to product">
    <Connections>
        <ConnectionInfo name="MyHSS-Connection1" type="HSS" description="Hyperion Shared Service connection" user="" password=""/>
        <ConnectionInfo name="AppConnection1" type="Application" product="ESBAPP" description="Destination Application" HSSConnection="MyHSS-Connection1" project="Analytic Servers:LCMDEV:1" application="Demo"/>
        <ConnectionInfo name="AppConnection2" type="Application" product="ESBAPP" project="Analytic Servers:LCMDEV:1" application="Sample" HSSConnection="MyHSS-Connection1" description="Source Application"/>
    </Connections>
    <Tasks>
        <Task seqID="1">
            <Source connection="AppConnection2">
                <Options/>
                <Artifact recursive="true" parentPath="/Databases" pattern="*"/>
            </Source>
            <Target connection="AppConnection1">
                <Options>
                    <optionInfo name="overWriteArtifact" value="false"/>
                    <optionInfo name="restructureCube" value="Retain cube data"/>
                </Options>
            </Target>
        </Task>
    </Tasks>
</Package>

Exporting to the File System

<?xml version="1.0" encoding="UTF-8"?>
<Package name="web-migration" description="migrating product to product">
    <Connections>
        <ConnectionInfo name="MyHSS-Connection1" type="HSS" description="Hyperion Shared Service connection" user="" password=""/>
        <ConnectionInfo name="FileSystem-Connection1" type="FileSystem" description="File system connection" filePath="/Essbase.Sample.Basic"/>
        <ConnectionInfo name="AppConnection2" type="Application" product="ESBAPP" project="Analytic Servers:LCMDEV:1" application="Sample" HSSConnection="MyHSS-Connection1" description="Source Application"/>
    </Connections>
    <Tasks>
        <Task seqID="1">
            <Source connection="AppConnection2">
                <Options/>
		<Artifact recursive="false" parentPath="/Databases/Basic" pattern="Basic outline"/>                
		<Artifact recursive="true" parentPath="/Databases/Basic/Calc scripts" pattern="*"/>
                <Artifact recursive="true" parentPath="/Databases/Basic/Location Aliases" pattern="*"/>
                <Artifact recursive="true" parentPath="/Databases/Basic/Rule files" pattern="*"/>
                <Artifact recursive="true" parentPath="/Databases/Basic/Text files" pattern="*"/>
                <Artifact recursive="true" parentPath="/Databases/Basic/Report scripts" pattern="*"/>
                <Artifact recursive="true" parentPath="/Databases/Basic/Substitution Variables" pattern="*"/>
                <Artifact recursive="true" parentPath="/Databases/Basic/Excel files" pattern="*"/>
                <Artifact recursive="true" parentPath="/Databases/Basic/Security" pattern="*"/>
            	<Artifact recursive="true" parentPath="/Substitution Variables" pattern="*"/>
	    </Source>
            <Target connection="FileSystem-Connection1">
            </Target>
        </Task>
    </Tasks>
</Package>

Importing from the File System

<?xml version="1.0" encoding="UTF-8"?>
<Package name="web-migration" description="migrating product to product">
    <Connections>
        <ConnectionInfo name="MyHSS-Connection1" type="HSS" description="Hyperion Shared Service connection" user="" password=""/>
        <ConnectionInfo name="AppConnection1" type="Application" product="ESBAPP" description="Destination Application" HSSConnection="MyHSS-Connection1" project="Analytic Servers:LCMDEV:1" application="Sample"/>
        <ConnectionInfo name="FileSystem-Connection2" type="FileSystem" filePath="file:/C:\Oracle\Middleware\user_projects\epmsystem1\import_export\admin@Native Directory\Sample.Basic" HSSConnection="MyHSS-Connection1" description="Source Application"/>
    </Connections>
    <Tasks>
        <Task seqID="1">
            <Source connection="FileSystem-Connection2">
                <Options/>
                <Artifact recursive="false" parentPath="/Databases/Basic" pattern="Basic outline"/>                
		<Artifact recursive="true" parentPath="/Databases/Basic/Calc scripts" pattern="*"/>
                <Artifact recursive="true" parentPath="/Databases/Basic/Location Aliases" pattern="*"/>
                <Artifact recursive="true" parentPath="/Databases/Basic/Rule files" pattern="*"/>
                <Artifact recursive="true" parentPath="/Databases/Basic/Text files" pattern="*"/>
                <Artifact recursive="true" parentPath="/Databases/Basic/Report scripts" pattern="*"/>
                <Artifact recursive="true" parentPath="/Databases/Basic/Substitution Variables" pattern="*"/>
                <Artifact recursive="true" parentPath="/Databases/Basic/Excel files" pattern="*"/>
                <Artifact recursive="true" parentPath="/Databases/Basic/Security" pattern="*"/>                
		<Artifact recursive="true" parentPath="/Substitution Variables" pattern="*"/>
            </Source>
            <Target connection="AppConnection1">
                <Options>
                    <optionInfo name="overWriteArtifact" value="false"/>
                    <optionInfo name="restructureCube" value="Retain cube data"/>
                </Options>
            </Target>
        </Task>
    </Tasks>
</Package>