8.9.2.10 Transfer Pricing Stratification Report

Table 8-105 Transfer Pricing Stratification Report

Report Name	TP Stratification Report TP Stratification Report Graph - Modified
Description	This report allows users to view a stratification of transfer pricing results (TP results are accumulated into tranches).
Dashboards Prompts	Prompt - AsOfDate As of Date Prompt - Product Product Name Prompt - OrgUnit Org Unit Prompt - Entity Legal Entity Prompt - Currency Currency Name Prompt - Product Type Product Type
Report Criteria	"Dim Product"."Product Name Level19", "Dim Product"."Product Name", ("Fact Account Summary"."Record Count"), "Fact Account Summary"."Average Book Balance", "Fact Account Summary"."Average Book Balance value", "Fact Account Summary"."Weighted Average All In TP Rate", "Fact Account Summary"."Weighted Average Basis Risk Rate", "Fact Account Summary"."Weighted Average Current 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 TP Rate" CASE WHEN cast( ( CASE WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."All In TP Rate" END) as char) = '0' THEN '>0 and <=1' WHEN cast( ( CASE WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."All In TP Rate" END) as char) = '1' THEN '>1 and <=2' WHEN cast( ( CASE WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."All In TP Rate" END) as char) = '2' THEN '>2 and <=3' WHEN cast( ( CASE WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."All In TP Rate" END) as char) = '3' THEN '>3 and <=4' WHEN cast( ( CASE WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."All In TP Rate" END) as char) = '4' THEN '>4 and <=5' WHEN cast( ( CASE WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."All In TP Rate" END) as char) = '5' THEN '>5 and <=6' WHEN cast( ( CASE WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."All In TP Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."All In TP Rate" END) as char) = '6' THEN '>6 and <=7' ELSE 'All Other Rates' END Add CASE WHEN cast( ( CASE WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Basis Risk Rate" END) as char) = '0' THEN '>0 and <=1' WHEN cast( ( CASE WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Basis Risk Rate" END) as char) = '1' THEN '>1 and <=2' WHEN cast( ( CASE WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Basis Risk Rate" END) as char) = '2' THEN '>2 and <=3' WHEN cast( ( CASE WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Basis Risk Rate" END) as char) = '3' THEN '>3 and <=4' WHEN cast( ( CASE WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary". "Basis Risk Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Basis Risk Rate" END) as char) = '4' THEN '>4 and <=5' WHEN cast( ( CASE WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Basis Risk Rate" END) as char) = '5' THEN '>5 and <=6' WHEN cast( ( CASE WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Basis Risk Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Basis Risk Rate" END) as char) = '6' THEN '>6 and <=7' ELSE 'All Other Rates' END CASE WHEN cast( (CASE WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Current Net Rate" END) as char) = '0' THEN '>0 and <=1' WHEN cast( (CASE WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Current Net Rate" END) as char) = '1' THEN '>1 and <=2' WHEN cast( (CASE WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Current Net Rate" END) as char) = '2' THEN '>2 and <=3' WHEN cast( (CASE WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Current Net Rate" END) as char) = '3' THEN '>3 and <=4' WHEN cast((CASE WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary". "Current Net Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Current Net Rate" END) as char) = '4' THEN '>4 and <=5' WHEN cast( (CASE WHEN "Fact Account Summary"."Current Net Rate" "Current Net Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary".BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Current Net Rate" END) as char) = '5' THEN '>5 and <=6' WHEN cast( (CASE WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Current Net Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Current Net Rate" END) as char) = '6' THEN '>6 and <=7' ELSE 'All Other Rates' END Add CASE WHEN cast((CASE WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Liquidity Premium Rate" END) as char) = '0' THEN '>0 and <=1' WHEN cast((CASE WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Liquidity Premium Rate" END) as char) = '1' THEN '>1 and <=2' WHEN cast((CASE WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Liquidity Premium Rate" END) as char)='2' THEN '>2 and <=3' WHEN cast((CASE WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Liquidity Premium Rate" END) as char) = '3' THEN '>3 and <=4' WHEN cast((CASE WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Liquidity Premium Rate" END) as char) = '4' THEN '>4 and <=5' WHEN cast((CASE WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 5.0 AND 6.0 THEN WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Liquidity Premium Rate" END) as char) = '5' THEN '>5 and <=6' WHEN cast((CASE WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Liquidity Premium Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Liquidity Premium Rate" END) as char) = '6' THEN '>6 and <=7' ELSE 'All Other Rates' END CASE WHEN cast( ( CASE WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Other Adjustments rate" END) as char) = '0' THEN '>0 and <=1' WHEN cast( ( CASE WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Other Adjustments rate" END) as char) = '1' THEN '>1 and <=2' WHEN cast( ( CASE WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Other Adjustments rate" END) as char) = '2' THEN '>2 and <=3' WHEN cast( ( CASE WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Other Adjustments rate" END) as char) = '3' THEN '>3 and <=4' WHEN cast( ( CASE WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 3.0 AND 4.0 THEN 3.0 Add WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Other Adjustments rate" END) as char) = '4' THEN '>4 and <=5' WHEN cast( ( CASE WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Other Adjustments rate" END) as char) = '5' THEN '>5 and <=6' WHEN cast( ( CASE WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Other Adjustments rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Other Adjustments rate" END) as char) = '6' THEN '>6 and <=7' ELSE 'All Other Rates' END, CASE WHEN cast( ( CASE WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Pricing Incentive Rate" END) as char) = '0' THEN '>0 and <=1' WHEN cast( ( CASE WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Pricing Incentive Rate" END) as char) = '1' THEN '>1 and <=2' WHEN cast( ( CASE WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Pricing Incentive Rate" END) as char) = '2' THEN '>2 and <=3' WHEN cast( ( CASE WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Pricing Incentive Rate" END) as char) = '3' THEN '>3 and <=4' WHEN cast( ( CASE WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Pricing Incentive Rate" END) as char) = '4' THEN '>4 and <=5' WHEN cast( ( CASE WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Pricing Incentive Rate" END) as char) = '5' THEN '>5 and <=6' WHEN cast( ( CASE WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Pricing Incentive Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Pricing Incentive Rate" END) as char) = '6' THEN '>6 and <=7' ELSE 'All Other Rates' END CASE WHEN cast( ( CASE WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Transfer Rate" END) as char) = '0' THEN '>0 and <=1' WHEN cast( ( CASE WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Transfer Rate" END) as char) = '1' THEN '>1 and <=2' WHEN cast( ( CASE WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Transfer Rate" END) as char) = '2' THEN '>2 and <=3' WHEN cast( ( CASE WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Transfer Rate" END) as char) = '3' THEN '>3 and <=4' WHEN cast( ( CASE WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Transfer Rate" END) as char) = '4' THEN '>4 and <=5' WHEN cast( ( CASE WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Transfer Rate" END) as char) = '5' THEN '>5 and <=6' WHEN cast( ( CASE WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 0.0 AND 1.0 THEN 0.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 1.0 AND 2.0 THEN 1.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 2.0 AND 3.0 THEN 2.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 3.0 AND 4.0 THEN 3.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 4.0 AND 5.0 THEN 4.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 5.0 AND 6.0 THEN 5.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 6.0 AND 7.0 THEN 6.0 WHEN "Fact Account Summary"."Transfer Rate" BETWEEN 7.0 AND 8.0 THEN 7.0 ELSE "Fact Account Summary"."Transfer Rate" END) as char) = '6' THEN '>6 and <=7' ELSE 'All Other Rates' END "Dim Product"."Account Type" IN (100, 200, 300, 400)
Compound Layout	Title Pivot Table View Selector Pivot Table (2) Pivot Table (3) Pivot Table (4) Pivot Table (5) Pivot Table (6) Pivot Table (7)