Database Reference
In-Depth Information
2.6.3 SQL Objects
Table Name
Purpose
Fields
DatanotInmetadata
Store a single dimension's unassigned members.
Programmatically written and loaded to Essbase.
• Dimension
• membername
Dimensions
Database members by dimension
• Dimname
• SortID
• Parentname
• membername
• Alias
• DataStorage
• Consolidation
• uDA
• Formula
• Comment
• timeBalance
• timeBalanceSkip
• varreporting
• CurrConv
• CurrConvCategory
FactData
Data loaded to ASosamp.Sample. This is the
same data set as the dataload.txt that comes
with ASosamp.Sample.
• Dimname
• sortID
• Parentname
• membername
• Alias
• DataStorage
• twoPassCalc
• Consolidation
• uDA
• Formula
• Comment
• timeBalance
• timeBalanceSkip
• varreporting
• CurrConv
hParentChild
Dimension load-ready table of a single
dimension's unassigned members,
programmatically populated.
• Parent
• Child
• Alias
LoadStatus
Dimension load process status.
• Application
• Procname
• Action
• Condition
• Datetime
maxLScriptStatus
maxL script process status.
• Scriptname
• Status
• Datetime
