Database Reference
In-Depth Information
2.6.1.1.5 Folder First Folder
Ty p e
Name
Purpose
Package
n/A
Interface
n/A
Scenario
n/A
Procedure
ProC_LogFailureStatus
ProC_LognoActionStatus
ProC_LogSuccessStatus
Write time/date stamped failure message to the LoadStatus table.
Write time/date stamped no action message to the LoadStatus table.
Write time/date stamped success message to the LoadStatus table.
2.6.1.1.6 Load Plan PLAN_ASOsamp
PLAn_ASosamp executes oDI Interfaces and
Packages to perform the four steps of quality data via its Load Plan task hierarchy.
Extract, find and load missing hierarchy—
his is the overall master step for all oDI
processing. All of the following steps reside under and are controlled by this master step.
Extract Essbase to SQL—
Execute all of the Interfaces in subfolder 1: Extract.
Load missing hierarchy—
Execute the Scenario SCn_Pkg_LooPAnDLoAD to
find and load orphan metadata to ASosamp.
Load data—
Execute the Scenario SCn_Pkg_DLoADDAtA to load data to Essbase.
Validate—
Execute the Scenario SCn_Pkg_ExtrACtvALIDAtEDAtArEPort
to compare the data in Essbase versus the data in SQL.
2.6.1.2 Knowledge Modules
knowledge modules (kms) are the adapters oDI uses to
interface with different technologies.
2.6.1.2.1 Subfolder 1: Extract
Ty p e
Name
Purpose
reverse-Engineering
(rkm)
rkm hyperion Essbase
used to reverse engineer the Essbase database to a Data
model. This reversal process is only done once unless
dimensions are added or removed.
Loading (Lkm)
Lkm hyperion Essbase
mEtADAtA to SQL
Extract dimensional metadata from the Essbase Data
model to a temporary SQL data store based on
mappings in Interfaces.
Integration (Ikm)
Ikm SQL to SQL Control
Append
Write Essbase dimensional metadata from the
temporary tables to the permanent Dimensions table.
2.6.1.2.2 Subfolder 2: LoadMissing and Subfolder 3: Load Data
As no Interfaces are
used, there are no kms.
2.6.1.2.3 Subfolder 4: Validate
Ty p e
Name
Purpose
Loading (Lkm)
Lkm SQL to SQL
Extract data from the validateASoSamp flat file.
Integration (Ikm)
Ikm SQL to SQL Control Append
Load the mapped flat file data to the table
validateASoSamp.
