Database Reference
In-Depth Information
Code Steps
Write Status
Command on Target
INSERT INTO <%=odiRef.getObjectName("LoadStatus")%> VALUES('#VAR_
AppName.#VAR_DbName', '#VAR_MaxLScriptName','#VAR_Object','No
Action', SYSDATETIME() )
2.6.1.4.7 PROC_LogSuccessStatus
Purpose—
Write out Essbase application and
database, maxL script name, Dimension, Success flag, and date and time to the
LoadStatus table.
Code Steps
Write Status
Command on Target
INSERT INTO <%=odiRef.getObjectName("LoadStatus")%> VALUES('#VAR_
AppName.#VAR_DbName', '#VAR_MaxLScriptName','#VAR_
Object','Success', SYSDATETIME() )
2.6.2 Essbase
2.6.2.1 Essbase Objects
Ty p e
Name
Purpose
report Script
validate
Export the current year and month's original Price, Price
Paid, returns, units, and transactions at the total level for all
dimensions.
rules Files
dData
Load all data from the table Facttable.
hDynSQL
Load unassigned members from the table hParentChild.
maxL Scripts
LoadDim.msh
Load a single dimension using the Load rule hDynSQL.
LoadData.msh
Load data using the Load rule dCurmth.
validate.msh
run the report Script validate and write the contents to a file.
2.6.2.2 MaxL
2.6.2.2.1 LoadDim.msh
OS_MaxLDimLoad Command line
cmd /c C:\Oracle\Middleware\EPMSystem11R1\products\Essbase\
EssbaseClient\bin\startMaxl.cmd c:\tempdir\MaxL\scripts\#VAR_
MaxLScriptName.msh #VAR_MaxLScriptName #VAR_AppName #VAR_DbName
Purpose—
Load missing dimension members through the SQL Load rule hDynSQL.
Code
/*
Purpose:
Load Dimension
Written by: Cameron Lackpour
Modified:
11 November 2011, initial write
Notes:
Parameter variables:
-- $1 = Script name
-- $2 = Application name
-- $3 = Database name
*/
/* Turn on timestamping */
