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
Prompt - OrgUnit (Funding Centre) - 1
Prompt - TP Rate Type
|
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) |