EnterpriseDW_SSAS
 Fact Gl Transactions (Student_Financials Measure Group)
  Properties
Property Value
Name Fact Gl Transactions
ID Fact Gl Transactions
Measure Group Type Regular
Description
Created Timestamp Tuesday, January 28, 2014 9:54 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 Thursday, March 09, 2017 11:01 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 BudgetAmount if it is positive
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 Commitment Amount if it is positive
Fact Gl Transactions Count
Integer
Count of individual 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