1. User Guide
  2. Overview of ALM BI Dashboards and Reports
  3. Funds Transfer Pricing Reports
  4. Fund Transfer Pricing Reports
  5. Zero Transfer Pricing Rate Report

8.9.2.11 Zero Transfer Pricing Rate Report

Table 8-106 Zero Transfer Pricing Rate Report

Report Name Zero TP Rate Report
Description This report allows users to see records with zero or missing transfer rates by product. Hyperlinks on Product lead to instrument level detail reports.
Dashboards Prompts

Prompt - AsOfDate

  • As of Date

Prompt - Product

  • Product Name

Prompt - OrgUnit

  • Org Unit

Prompt - Entity

  • Legal Entity

Prompt - Rate Type

  • Rate Type

Prompt - Currency

  • Currency Name

Prompt - Product Type

  • Product Type
Conditions < None >
Compound Layout

Title

Table
Report Criteria

"Dim Product"."Product Name""Dim Product"."Product Name",sum(case when (case when ASCII('@{RateType}{Base}') =ASCII('Base') then "Fact Account Summary"."Transfer Rate" else "Fact Account Summary"."All In Transfer Rate" end) is null then "Fact Account Summary"."Record Count" end by "Dim Product"."Product Name"),sum(case when (case when ASCII('@{RateType}{Base}') =ASCII('Base') then "Fact Account Summary"."Transfer Rate" else "Fact Account Summary"."All In Transfer Rate" end ) is null then "Fact Account Summary"."Average Book Balance" end by "Dim Product"."Product Name"),sum(case when (case when ASCII('@{RateType}{Base}') =ASCII('Base') then "Fact Account Summary"."Transfer Rate" else "Fact Account Summary"."All In Transfer Rate" end) = 0 then "Fact Account Summary"."Record Count" end by "Dim Product"."Product Name"),sum(case when (case when ASCII('@{RateType}{Base}') =ASCII('Base') then "Fact Account Summary"."Transfer Rate" else "Fact Account Summary"."All In Transfer Rate" end ) = 0 then "Fact Account Summary"."Average Book Balance" end by "Dim Product"."Product Name")

,sum("Fact Account Summary"."Record Count" by "Dim Product"."Product Name"),sum("Fact Account Summary"."Average Book Balance" by "Dim Product"."Product Name"),(sum(case when (case when ASCII('@{RateType}{Base}') =ASCII('Base') then "Fact Account Summary"."Transfer Rate" else "Fact Account Summary"."All In TP Rate" end) = 0 then "Fact Account Summary"."Record Count" end by "Dim Product"."Product Name")/sum("Fact Account Summary"."Record Count" by "Dim Product"."Product Name"))*100,(sum(case when (case when ASCII('@{RateType}{Base}') =ASCII('Base') then "Fact Account Summary"."Transfer Rate" else "Fact Account Summary"."All In TP Rate" end ) = 0 then "Fact Account Summary"."Average Book Balance" end by "Dim Product"."Product Name")/sum("Fact Account Summary"."Average Book Balance" by "Dim Product"."Product Name"))*100,sum(case when (case when ASCII('@{RateType}{Base}') =ASCII('Base') then "Fact Account Summary"."Transfer Rate" else "Fact Account Summary"."All In Transfer Rate" end) is null then "Fact Account Summary"."Record Count" end by "Dim Product"."Product Name") * 100/sum("Fact Account Summary"."Record Count" by "Dim Product"."Product Name"),sum(case when (case when ASCII('@{RateType}{Base}') =ASCII('Base') then "Fact Account Summary"."Transfer Rate" else "Fact Account Summary"."All In Transfer Rate" end ) is null then "Fact Account Summary"."Average Book Balance" end by "Dim Product"."Product Name") * 100/sum("Fact Account Summary"."Average Book Balance" by "Dim Product"."Product Name")
Conditions < None >
Compound Layout

Title

Table