8.9.2.6 Funding Center Time

Table 8-101 Funding Center Time

Report Name Funding Center Time
Description This report allows users to see Funding Center income, Weighted Average Transfer Rates or Average Balances over time.
Dashboards Prompts

Prompt - Date Range

  • Calendar From Date
  • Calendar To Date

Prompt - OrgUnit

(Funding Centre) - 1

  • Org Unit

Prompt - TP Rate Type

  • Rate/Charge Credit Amount
Report Criteria

"Dim Product"."Product Name Level19",

"Dim Product"."Product Name",

"Dim Calendar"."Year",

"Dim Calendar"."Month",

FILTER("Fact Ledger Stat"."Value" USING ("Financial Elements"."Financial Element Identifier" = 140)),

case when '@{TPRateType}'='Rate' then (FILTER("Fact Ledger Stat"."Value" USING ("Financial Elements"."Financial Element Identifier" = 170))) else (FILTER("Fact Ledger Stat"."Value" USING ("Financial Elements"."Financial Element Identifier" = 450))) end

Conditions "Dim Product"."Account Type" IN (100, 200, 300, 400)
Compound Layout

Title

Pivot Table (4)