As we all know that the Outline Load utility can be used to import
metadata and data for standard & custom dimensions, attributes, UDAs,
exchange rates, Smart Lists, and planning unit hierarchies from a flat file or
a relational data source.
You can also export metadata and data to a flat file or export
metadata to a relational data source using the Outline Load utility
Here let me cover how to load metadata & data from a
relational data source using the Outline Load utility
Loading the Metadata
from relational data source to Hyperion Planning using OLU
- Create
a metedata.properties file
A
sample .properties file is created as shown below which can connect to a
external Relation data source along with the SQL to retrieve the needed
metadata in the needed format with all the customized transformation you need, yes if you can't use ODI then this is awesome :-)
# /S:server where Planning
is running
/S:Example-Planning-Server.com
# Application where you
want to load the metadata
/A:Vision
# User used to load the
metadata
/U:admin
# jdbc catalog - the Source
Relational Schema
/RIC:HYPTEST
# jdbc url - the Connection
URL to connect to the Relational Data-source Schema
/RIR:jdbc:oracle:thin:@//database:1521/HYPTEST
# jdbc driver
/RID:oracle.jdbc.OracleDriver
# Relational Data-source
Schema user
/RIU:TDQPSPB
# rdbms password
/RIP:vrX4PSFuHXyyBQGQ0o6yHFzY2T7KLyHgcp3WAqQuJJ/JlYRlIV
# ignore order of members
/-O
# sql queries for loading
the Entities & Employee Dimension
