8.9.2.8 Transfer Pricing Account Summary Report

Table 8-103 Transfer Pricing Account Summary Report

Report Name	TP Account Summary Report
Description	This report allows users to see an overview of the account level TP information. A variant of the TP Margin Super report allowing further drill down to Account Detail Report.
Dashboards Prompts	Prompt – AsOfDate (TP Account Summary) As of Date Prompt - Product (TP Account Summary) Product Name Prompt - Customer (TP Account Summary) Customer Name Prompt - Account Number (TP Account Summary) Account Number Prompt - Account Officer (TP Account Summary) Account Officer Prompt - OrgUnit (TP Account Summary) Org Unit Prompt - Entity (TP Account Summary) Legal Entity Prompt - Currency (TP Account Summary) Currency Prompt - Product Type (TP Account Summary) Product Type Prompt - Idnumber Identity Number
Report Criteria	"Dim Account"."Account Number", "Fact Account Summary"."Weighted Average Basis Risk Rate", "Fact Account Summary"."Weighted Average Liquidity Premium Rate", "Fact Account Summary"."Weighted Average Other Adjustments Rate", "Fact Account Summary"."Weighted Average Pricing Incentive Rate", "Fact Account Summary"."Weighted Average Current Rate", "Fact Account Summary"."Weighted Average TP Rate", "Fact Account Summary"."Average Book Balance", "Fact Account Summary"."EOP Balance", "Fact Account Summary"."Weighted Average All In TP Rate", CASE WHEN "Dim Product"."Account Type" in (100,200) Then ("Fact Account Summary"."Weighted Average Current Rate"- "Fact Account Summary"."Weighted Average All In TP Rate") else Case when "Dim Product"."Account Type" in (300,400) then ("Fact Account Summary"."Weighted Average All In TP Rate"-"Fact Account Summary"."Weighted Average Current Rate") end end, "Dim Product"."Product Name", "Dim Product"."Product Name Level19", "Dim Product"."Account Type"
Conditions	"Dim Product"."Account Type" IN (100, 200, 300, 400)
Compound Layout	Title Pivot Table