Database Reference
In-Depth Information
2.6.1.1.2 Subfolder 2: LoadMissing
Ty p e
Name
Purpose
Package
Pkg_hmissingDimmembers
Identify orphan members in fact data and
load them to a single Essbase
dimension.
Pkg_LoopAndLoad
Loop all dimensions in the view vDimList
and call Scenario
SCn_Pkg_hmISSIngDImmEmBErS.
Interface
n/A
Scenario
SCn_Pkg_
hmISSIngDImmEmBErS
SCn_Pkg_
LooPAnDLoAD
Execute Pkg_
hmissingDimmember and
Pkg_LoopAndLoad from
Load Plan PLAn_ASosamp.
Procedure
ProC_DatanotInmetaData
Identify orphaned fact data and create
table for dimension load.
ProC_LogheaderFooter
Write process success/failure to the
Status table.
2.6.1.1.3 Subfolder 3: Load Data
Ty p e
Name
Purpose
Package
Pkg_dLoadData
Load data from the fact data source to Essbase.
Interface
n/A
Scenario
SCn_Pkg_DLoADDAtA
Execute Pkg_dLoadData from Load Plan
PLAn_ASosamp.
Procedure
n/A
2.6.1.1.4 Subfolder 4: Validate
Ty p e
Name
Purpose
Package
Pkg_Extractvalidatereport
Extract Essbase totals and sum SQL totals,
compare, and write the difference, if any, to the
table validateASosamp.
Interface
Int_Importvalidatereport
Import the Essbase report Script output to the
table validateASoSamp.
Scenario
SCn_Pkg_
ExtrACtvALIDAtErEPort
Execute Pkg_Extractvalidatereport from Load
Plan PLAn_ASosamp.
Procedure
ProC_FactvsEssbase
Compare the data values in the Fact table to the
upper-level Essbase export and write the
variance to the table validationvariance.
ProC_truncatevariance
truncate the table validationvariance.
