ODI - ASO Metadata Loading

ASO Metadata Loading using ODI

Thanks,

Madhusudhan

ODI - ASO Data Loading

ASO Data Loading using ODI

Thanks,

Madhusudhan

FDM Migration

FDM Migration

Each and every FDM application will use/connect with one individual schema, where all artifacts, data etc will be saved.

Whenever we create an application, long with connecting schema we will get created 4 folders in mentioned path at time of application creation.

1. Inbox   2. Outbox   3. Data   4. Reports

So, Now Migration: For Existing application

• Migrating of schema from Source to Target
• Copy Folder structure from Source and Target
• validate connectivity and data.

For New application:

• Click on Modify and add application and then follow above steps.

Thanks,

Mady

HFM Migration

HFM Migration

HFM migration is very easy method, when we stuck any where tracing will be that much i can say. :)

Copy App Utility for HFM application migration:

1. Create one .udl file for Source  and Target application.
2. Mention Database, schema and password and test connection.
3. Launch Copyapp Utility and browse udl files. Start hfm migration.
4. Log file default location: D:\Oracle\Middleware\EPMSystem11R1\logs\hfm

In Latest version, Hyperion 11.1.2.4.204+ we will get an option Import Application for the same HFM migration. Check the below screen shot:

Link:

https://docs.oracle.com/cd/E12032_01/doc/epm.921/html_hfm_admin_webhelp/frameset.htm?/cd/E12032_01/doc/epm.921/html_hfm_admin_webhelp/AdminHelp-05-18.html

http://blog.checkpointllc.com/hfm-copy-application-utility-makes-a-big-return-in-11.1.2.4.2

For detailed migration for 11.1.2.4.204+
https://hyperion-mady.blogspot.com/2019/02/hfm-migration-11124200-from-workspace.html
Thanks,
Mady

Planning Migration

Planning Migration

1. For Planning migration (Existing), we can follow below steps:

Source:

• Export planning application artifacts including security but uncheck Essbase data.
• Export HSS Shared Services Security for Planning application
• Copy Essbase application into Target directly. (It will overwrite all files - index files, page files, db files, etc)

Target:

• Import Planning application artifacts without Security. (Uncheck Security)
• Copy Essbase data (Already mentioned in the above list, mentioned here for following flow)
• Refresh database from planning application
• Import HSS Security Shared Services Planning application security
• Import Planning application security 

2. For Planning Migration: we can do this way also

Source:

• Export Planning schema
• Export HSS Shared Services Security for planning application
• Copy Essbase application all files - index files, pag files, db files, app files etc.

Target:

• Import planning application schema into target application schema
• Import Security in Target Environment
• Paste Essbase application files
• Refresh database from Planning application

First time Planning application Migration:

http://www.oracle.com/technetwork/middleware/performance-management/tutorials/pln-lcm-obe-095602.html

One more link:
https://docs.oracle.com/cd/E57185_01/EPMMP/epm_migrate_planning_app.html

Thanks,

Mady

Essbase Migration

Essbase Migration

1 . Using LCM:

     Using LCM, we can export Essbase application artifacts from Source and import into Target.

• Export artifacts from Source 
• Find import_export folder in Source, copy and paste into same import_export folder in Target Environment
• Import artifacts from Target.

2. Without LCM:

• Stop Essbase application
• We can copy Essbase application from Source and paste into Target.
• Restart Essbase application
• In this way, we can copy application with data. No need to do restructure.

3. Using Migration wizard from EAS Console:

• After launching EAS console, Add Source and Target Essbase Servers and expand applications
• Launch Migration wizard and select Source and Target environments, click Next
• Select Source and Target applications and Click Next
• Verify migration artifacts which you want migrate and Click Finish 

Note: Check Replace option if you want to overwrite existing objects.

For first time migration, check out below link:
http://www.oracle.com/technetwork/middleware/performance-management/tutorials/essbaselcm-obe-101974.html

Thanks,

Mady

Hyperion Support Activities

Hyperion Support Activities

1. Essbase migration
2. Planning migration
3. HFM migration
4. FDM migration
5. FDMEE migration
6. Reports migration ( FR, Web Analysis, IR etc)
7. HSS Security migration
8. Application Security 
9. MSAD Configuration
10. Smart view netcount settings update
11. EAS console - java issue
12. planning not sync with security issue
13. FDM control tables not showing up target application
14. Big IP Urls
15. Smart view issues - User complaints
16. Startup document doesn't exist error while opening Workspace