3.5 Use Report Hierarchical Levels

The BSP BI Reports enable the roll-up and drill-down capability for Forecast Output Results, leveraging all the available levels for the following three Hierarchies:

  • Legal Entity Hierarchy
  • Planning Center Hierarchy
  • Product Hierarchy

The following screenshot displays the three available selections for the aforementioned hierarchies. These are available for all the Report Canvases except for the “Funding Center IS”, where only “Legal Entity Hierarchy” and “Product Hierarchy” are available. This is because Funding Center is always a hypothetical branch, which is created to do all adjustments, which are prevailing under the Planning Center. Therefore, there is no hierarchy available for this Driver, and for “Forecast Set Details”.

Available Hierarchies for the Report Canvases are as follows:

  • Balances
  • Runoff Details
  • Net Interest Margin
  • Ending Rates
  • Average Rates

Figure 3-24 BSP Forecast Analysis Homepage


BSP Forecast Analysis Homepage

No hierarchies are available for the Forecast Set Details Report Canvas.

Figure 3-25 Forecast Set Details


This screen displays all the details of the Forecast Sets.

The following screenshot describes how to select a Hierarchy Level for the “Product Hierarchy”.

Figure 3-26 Selecting Hierarchy Level for the Product Hierarchy


This screenshot describes how to select the Hierarchy Level for the Product Hierarchy.

The following screenshot displays the updated Forecast Output results after the selection of the required Hierarchical Level for the “Product Hierarchy”.

Figure 3-27 Forecast Output Results


This screenshot displays the updated Forecast Output results after the selection of the desired hierarchical Level for the “Product Hierarchy”.

The following screenshot describes how to select a Hierarchy Level for the “Planning Center Hierarchy”.

Figure 3-28 Hierarchy Level for the Planning Center Hierarchy


This screenshot describes how to select a Hierarchy Level for the “Planning Center Hierarchy”.

The following screenshot displays the updated Forecast Output results after the selection of the required Hierarchy Level for the “Planning Center Hierarchy”.

Figure 3-29 Hierarchy Level for the Planning Center Hierarchy


This screenshot displays the updated Forecast Output results after the selection of the desired Hierarchy Level for the “Planning Center Hierarchy”.

The following screenshot describes how to select a Hierarchy Level for the “Legal Entity Hierarchy”.

Figure 3-30 Hierarchy Level for the Legal Entity Hierarchy


This screenshot describes how to select a Hierarchy Level for the “Legal Entity Hierarchy”.

The following screenshot displays the updated Forecast Output Results after the selection of the required Hierarchy Level for the “Legal Entity Hierarchy”.

Figure 3-31 Hierarchy Level for the Legal Entity Hierarchy


This screenshot displays the updated Forecast Output results after the selection of the desired Hierarchy Level for the “Legal Entity Hierarchy”.