Table of Contents Table of Contents Title and Copyright Information 1 Get Help 1.1 Get Help in the Applications 1.1.1 Additional Resources 1.2 Learn About Accessibility 1.3 Get Support 1.4 Get Training 1.5 Join Our Community 1.6 Share Your Feedback 1.7 Before You Begin 2 Introduction 3 Access Business Intelligence (BI) Reports 4 Preparing Data using SQL Query Browser 5 Raw Data Analysis 5.1 Staging Instrument Data 5.1.1 Assets 5.1.2 Liabilities 5.1.3 Derivative Contracts 5.1.4 Fee Based Services 5.1.5 Loan Commitments 5.1.6 Off Balance Sheet Items 5.1.7 Ledger - Instruments 5.2 Staging Instrument Supplementary Data 5.2.1 Account Index History 5.2.2 Account Rate Tiers 5.2.3 Embedded Options Schedule 5.2.4 Payment Schedule 5.3 Staging Ledger Data 5.3.1 Management Ledger 5.3.2 Management Ledger01 5.3.3 Management Ledger02 5.3.4 Management Ledger03 5.3.5 Management Ledger04 5.3.6 Management Ledger05 5.4 Staging Transaction Summary Data 5.4.1 Asset Transaction Summary 5.4.2 Liabilities Transaction Summary 5.4.3 Fee Based Services Transaction Summary 5.4.4 Off Balance Sheet Transaction Summary 5.5 Processing Instrument Data 5.5.1 Assets 5.5.2 Liabilities 5.5.3 Derivative Contracts 5.5.4 Fee Based Services 5.5.5 Loan Commitments 5.5.6 Off Balance Sheet Items 5.5.7 Ledger - Instruments 5.6 Processing Instrument Supplementary Data 5.6.1 Account Index History 5.6.2 Account Rate Tiers 5.6.3 Embedded Options Schedule 5.6.4 Payment Schedule 5.7 Processing Ledger Data 5.7.1 Management Ledger 5.7.2 Management Ledger01 5.7.3 Management Ledger02 5.7.4 Management Ledger03 5.7.5 Management Ledger04 5.7.6 Management Ledger05 5.8 Processing Transaction Summary Data 5.8.1 Asset Transaction Summary 5.8.2 Liabilities Transaction Summary 5.8.3 Fee Based Services Transaction Summary 5.8.4 Off Balance Sheet Transaction Summary 6 Data Insights 6.1 PFT Data Insights 6.1.1 Report Common Filters 6.1.2 Report Data Action 6.1.3 “1 - Incomes & Expenses” 6.1.4 “2 – Non-Interest Incomes” 6.1.4.1 “2.a – Fees” 6.1.4.2 “2.b - Charges and Commissions” 6.1.5 “3 - Non Interest Expenses” 6.1.5.1 “3.a - Other Non Interest Expenses” 6.1.6 “4 - Customer Account Details” 7 Processing Analytics 7.1 Allocation Performance Analysis 7.1.1 Multi-Period Analysis 7.1.2 Single Period Analysis 8 Processed Data Insights 8.1 Ad-hoc Data Analysis 8.1.1 Report Filters 8.1.2 Report Hierarchies 8.1.3 Ad-hoc Analysis 8.2 Financial Statements Analysis 8.2.1 Report Filters 8.2.2 Report Hierarchies 8.2.3 Report Data Action 8.2.4 Financial Statements - Outliers 8.2.4.1 Working with Financial Statement Reporting Lines 8.2.4.2 Use Case Flow for Outliers Analysis 8.2.5 Financial Statements - Trends 8.2.6 Financial Statements - Detail 8.2.7 Financial Statements - Org Units & Products