EnterpriseDW_SSAS
 Fact Gl Transactions (Executive_Integrated_Financials Measure Group)
  Properties
Property Value
Name Fact Gl Transactions
ID Fact Gl Transactions
Measure Group Type Regular
Description
Created Timestamp Wednesday, August 28, 2013 10:25 AM
Aggregation Prefix
Data Aggregation DataAndCacheAggregatable
Estimated Rows 6936989
Estimated Size 696957758
Ignore Unrelated Dimensions True
Is Linked False
Is Loaded True
Last Processed Thursday, March 09, 2017 2:43 PM
Last Schema Update Tuesday, January 28, 2014 9:54 AM
Processing Mode Regular
Processing Priority 0
State Processed
Storage Location
Storage Mode Molap
  Measures
Measure Name
ID
Data Type
Description
Actuals Amount
Double
The amount on the journal line if the journal type is not BT, EN or CO..
Actuals Amount Credit
Double
The Actuals Amount if it was negative without a sign. Journal types such as AP, CC, JE, PR.
Actuals Amount Debit
Double
The Actuals Amount if it is positive. Journal types such as AP, CC, JE, PR.
Budget Amount
Double
The amount on the journal line if the journal typ e is BT=Budget Transfer.
Budget Amount Credit
Double
The Budget Amount if it was negative without a sign.
Budget Amount Debit
Double
The BudgetAmount if it is positive.
Commitment Amount
Double
The amount on the journal line if the journal type is CO=Commitment.
Commitment Amount Credit
Double
The Commitment Amount if it was negative without a sign.
Commitment Amount Debit
Double
The Commitment Amount if it is positive.
Encumbrance Amount
Double
The amount on the journal line if the journal type is EN=Encumbrance.
Encumbrance Amount Credit
Double
The Encumbrance Amount if it was negative without a sign.
Encumbrance Amount Debit
Double
The Encumbrance Amount if it is positive.
Fact Gl Transactions Count
Integer
Indication of the number of Gl Transactions.
Journal Amount
Double
The amount on the journal line.
Journal Amount Credit
Double
The Journal Amount if it was negative without a sign.
Journal Amount Debit
Double
The Journal Amount if it is positive.
Powered by BI Documenter