The main purpose of stored view is to replace “heavy” designed web reports and give a user a certain guideline on how to achieve his goals. Stored views can be used for two major groups of requirements – informative reports and planning reports. The first ones are used to analyze existing financial figures, while the second ones aim to plan Budget, Forecast, and Mid Term Plan. Both reports have the same structure for different cubes and can be set up according to the same construction principles. The stored views are extensively used in Integrated Financial Planning Model. The views have the same layout and offer a limited possibility of modifying them by selecting different variables, such as Legal Entity, Time Period, Account Number, etc. The following Views are available in the model:
Every cube has its own views subdivided into two groups – Reporting of Actuals and Planning of Forecast, Budget, and Mid Term Plan.
Reporting of Actuals
Actual, Actual YTD and KPI Report
Description
The reports show the overview of the Total Group Level in Group Currency for the current month of the year (e.g., 2021-06), respectively current Month_YTD period (e.g., 2021-06_YTD). The figures are compared to the previous year and the latest available forecast.
Header fields
For header fields, a single base or consolidated element can be selected.
| Field | Description | Implementation |
| Month / Month_YTD | Reporting period, referring to the latest available Actual figures, e.g., 2021-06 or 2021-06_YTD. Pay attention that the other KPIs from the report should be available for the same period. | Subset “Year-Month” is used |
| Legal Entity | Reporting Legal Entity or Group of Entities | |
| Partner Entity | Related Partner Entity or Group of Entities | |
| Currency | Group Currency should be selected | |
| Cost Center | One or group of cost centers | |
| Version | The most up to date forecast version actual figures are compared to | Subset “Forecasts” is used |
View body
| Columns / Rows | Description | Implementation |
| PY / PY YTD | Last year’s figures for the selected period |
Version: Previous Year Cost Center_measure: Adjusted Balance Sheet_measure or Profit Center_measure: Adjusted and Posted |
| BU / BU YTD | Budget figures for the selected period |
Version: Budget Measure Dimension: Input |
| Forecast / Forecast YTD | Forecast figures for the selected period and forecast version |
Version: ${"Version"} Measure Dimension: Input |
| AC / AC YTD | Actual figures for the selected period |
Version: Actual Cost Center_measure: Adjusted Balance Sheet_measure or Profit Center_measure: Adjusted and Posted |
| ∆PY% / ∆PY YTD% | Deviation compared to the previous reporting year in % | (['AC']-['PY']) / ['PY'] |
| ∆BU% / ∆BU YTD% | Deviation compared to budget in % | (['AC']-['BU']) / ['BU'] |
| ∆Forecast% / ∆ForecastYTD% | Deviation compared to the selected forecast in % | (['AC']-['Forecast']) / ['Forecast'] |
| Account Dimension | Hierarchy of account elements or just selected KPIs (e.g., for the KPIs view) |
Legal Entity Breakdown
The report shows the incomes and expenses on the account and legal entity level. The user can select between different versions.
Header fields
For header fields, a single base or consolidated element can be selected.
| Field | Description | Implementation |
| Month | Reporting year or month | Subset “Year-Month” is used |
| Partner Entity | Related Partner Entity or Group of Entities, here the top consolidated element should be shown for the complete image | |
| Currency | Group Currency should be selected to see all related figures | |
| Cost Center | For the complete overview, “All Cost Centers” are to be selected | |
| Version | Any available version |
View Body
| Columns | Description | Implementation |
| Legal Entity | Legal Entities Hierarchy including the top element | |
| Cost Center | Cost Center Hierarchy |
Time Series and Times Series Monthly
The reports show the overview for seven years (on a yearly or monthly base, starting two years before a selected year and showing the figures for the budget and the following two years. The Forecast version shows the latest available forecast. The user can see the over years development of the figures and check the budget and mid-term planning. The overview is shown at the account number level.
Header fields
For header fields, a single base or consolidated element can be selected.
| Field | Description | Implementation |
| Month | Reporting year, e.g., 2022. Pay attention to selecting the time period to have comparable figures in all versions. | Subset “Years” is used |
| Legal Entity | Reporting Legal Entity or Group of Entities | |
| Partner Entity | Related Partner Entity or Group of Entities | |
| Currency | Group Currency should be selected to see all related figures | |
| Cost Center | One or more cost centers | |
| Version | The most up-to-date forecast version the figures are compared with. |
View body
| Columns / Rows | Description | Implementation |
| PY-2 | Figures of three years ago, e.g., when 2022 is selected, PY-2 shows 2019 figures |
Month: The value of the “Previous Year” Attribute of three years before actual Version: Actual Cost Center_measure: Adjusted Balance Sheet_measure or Profit Center_measure: Adjusted and Posted |
| PY-1 | Figures of two years ago, e.g., when 2022 is selected, PY-1 shows 2020 figures |
Month: The value of the “Previous Year” Attribute of two years before actual Version: Actual Cost Center_measure: Adjusted Balance Sheet_measure or Profit Center_measure: Adjusted and Posted |
| PY | Previous Year, e.g. when 2022 is selected, PY shows 2021 figures |
Month: The value of the “Previous Year” Attribute of a year before actual Version: Actual Cost Center_measure: Adjusted Balance Sheet_measure or Profit Center_measure: Adjusted and Posted |
| FC | Forecast figures for the selected period and forecast version |
Month: ${"Month"} Version: ${"Version"} Measure Dimension: Input |
| BU next year | Budgeted figures for the next year, e.g., when 2022 is selected, BU figures for 2023 are shown |
Month: The value of the “Next Year” attribute of the selected actual Month Version: Budget Measure Dimension: Input |
| PL Next Year+1 | Next year, e.g., when 2022 is selected, 2023 mid-term plan figures are shown |
Month: The value of the “Next Year” attribute of the next year Version: Mid-Term Planning Cost Center_measure: Adjusted Balance Sheet_measure or Profit Center_measure: Adjusted and Posted |
| PL Next Year + 2 | Next but one year, e.g., when 2022 is selected, 2024 mid-term plan figures are shown |
Month: The value of the “Next Year” attribute of the next but one year Version: Mid-Term Planning Cost Center_measure: Adjusted Balance Sheet_measure or Profit Center_measure: Adjusted and Posted |
| Cost Type Dimension | Hierarchy of elements |
Balance Sheet Cube Reporting Views
Additionally, the following reporting views are based on the Balance Sheet cube.
Header fields
For header fields, a single base or consolidated element can be selected.
| Field | Description | Implementation |
| Version | Forecast version actual figures are compared to | Subset “Forecasts” is used |
| Month | The reporting period refers to the latest available Actual figures, e.g., 2021-06 or 2021-06_YTD. Pay attention that the other KPIs from the report should be available for the same period of time. | Subset “Year-Month” is used |
| Legal Entity | Reporting Legal Entity or Group of Entities | |
| Partner Entity | Related Partner Entity or Group of Entities | |
| Currency | Group Currency should be selected to see all related figures |
View body
| Columns / Rows | Description | Implementation |
| PY (hidden) | Previous Year, e.g., when 2022 is selected, PY shows 2021 figures |
Month: ${Month"} Version: Previous Year Balance Sheet_measure: Adjusted and Posted Transaction Type: T999 |
| BU (hidden) | Budget figures for the selected period |
Month: ${Month"} Version: Budget Balance Sheet_measure: Input Transaction Type: T999 |
| Forecast (hidden) | Forecast figures for the selected period and forecast version |
Month: ${“Month"} Version: ${“Version”} Balance Sheet_measure: Input Transaction Type: T000 |
| AC Additions | Actual additions for the selected period |
Month: 2021-06 Version: Actual Balance Sheet_measure: Adjusted and Posted Transaction Type: T202 |
| ∆PY% | Deviations compared to previous year | (['AC Additions']-['PY']) / ['PY'] |
| ∆BU% | Deviations compared to budget | (['AC Additions']-['BU']) / ['BU'] |
| ∆Forecast% | Deviations compared to forecast | (['AC Additions']-['Forecast']) / ['Forecast'] |
Input Screens
Budget, Budget Monthly, Forecast, Forecast Monthly, Mid-Term Planning
These screens allow inputting planning figures for the different time periods (YTG for Forecast Planning, next years for Budget, and Mid-Term Planning) and comparing them to other relevant KPIs, such as Budget, Forecast, or previous years.
The aim of planning views is to offer the user the possibility to input figures on the base level (e.g., per Legal Entity). You might require some knowledge of splashing rules in some cases. You can learn more about splashing here Splashing Overview (jedox.com).
For Version - “Forecast 6+6” is selected because it’s the latest forecast version available in sample data.
If you use input screens on a yearly base, you need to select the planning year. The input figures will be saved to the element <YYYY>-~, where <YYYY> is the selected year.
If you want to plan on a yearly basis, select “Forecast,” “Budget,” or Mid-Term Planning. If you want to plan on a monthly basis, switch to “Forecast Monthly” or “Budget Monthly.”
The exception is the Input Screens based on the Cash Flow Cube. Here most cells are calculated by rules, therefore user inputs do not make sense on the default input element “Input”. For the Cash Flow Cube, ALL views are Reporting views.
Forecast, Forecast Monthly
Header fields
For header fields, a single base or consolidated element can be selected.
| Field | Description | Implementation |
| Version | The forecast to be planned should be selected, e.g., “Forecast 6+6”. | Subset “Forecasts” is used |
| Month | Planning period selected as a whole year. The inputs are splashed and saved to the selected period | Subset “Years” is used |
| Legal Entity | Legal Entity to be planned on | |
| Partner Entity | Usually, ~ is used | |
| Currency | Local Currency (LC) | |
| Cost Center | Base Cost Center where the figures are going to be planned on |
View body
| Columns / Rows | Description | Implementation |
| BU | Budget figures as of a selected year |
Month: ${“Month"} Version: Budget Measure Dimension: Input |
| FC / FC Monthly | Forecast figures as of selected year as a year figure or on a monthly base |
Month: Selected year or months of the selected year Version: ${"Version"} Measure Dimension: Input |
| FC YTD | Available actual figures |
Month: YTD time of the selected Month Measure Dimension: Input |
| FC YTG | Figures for the rest of the selected year |
Month: YTG time of the selected Month Version: ${"Version"} Measure Dimension: Input |
| ∆BU% | Deviation compared to budget | (['FC']-['BU']) / ['BU'] |
Budget, Budget Monthly
Header fields
For header fields, a single base or consolidated element can be selected.
| Field | Description | Implementation |
| Version | The filter “Version” defines the forecast version, budget or mid-term plan are compared to. | Subset “Forecasts” is used |
| Month | Planning period selected as a whole year. In case of “Forecast, Budget or Mid-Term Planning” Screens, the inputs are splashed to the months of the year. Be aware that the forecast is shown for the previous year. | Subset “Years” is used |
| Legal Entity | Legal Entity to be planned on | |
| Partner Entity | Usually, ~ is used | |
| Currency | Local Currency (LC) | |
| Cost Center | Base Cost Center where the figures are going to be planned on |
View body
| Columns / Rows | Description | Implementation |
| PY | Figures as of two years before budget |
Month: The value of the “Previous Year” Attribute of a year before selected Month Version: Actual Cost Center_measure: Adjusted Balance Sheet_measure or Profit Center_measure: Adjusted and Posted |
| FC | Forecast showing the most up to date forecast version from the previous year |
Month: The value of the “Previous Year” Attribute of selected Month Version: ${"Version"} Measure Dimension: Input |
| ∆PY% | Deviation compared to forecast | (['FC']-['PY']) / ['PY'] |
| BU Year Entry (as a whole figure or monthly) | Yearly budget figures are to be input in this column. The values are saved under YYYY-~ element. Monthly budget figures will be saved on a monthly base |
Month: ${"Month"}-~ Version: Budget Measure Dimension: Input |
| ∆FC% | Deviation compared to budget | (['Budget Year Entry']-['FC']) / ['FC'] |
| Comment | You can comment your input |
Month: ${Month"} Version: ${"Version"} Cost Center_measure: Comment |
Mid-Term Planning
Header fields
For header fields, a single base or consolidated element can be selected.
| Field | Description | Implementation |
| Version | The filter “Version” defines the forecast version, budget, or mid-term plan are compared to. | Subset “Forecasts” is used |
| Month | The first planning year of the mid-term plan. | Subset “Years” is used |
| Legal Entity | Base Legal Entity to be planned on, e.g., 11 | |
| Partner Entity | Usually, ~ is used | |
| Currency | Local Currency (LC) | |
| Cost Center | Base Cost Center where the figures are going to be planned on, e.g., 111100-Management |
View body
| Columns / Rows | Description | Implementation |
| PY | Previous year |
Month: ${"Month"} Version: Previous Year Cost Center_measure: Adjusted Balance Sheet_measure or Profit Center_measure: Adjusted and Posted |
| FC | Forecast showing the most up to date forecast version from the previous year |
Month: ${"Month"} Version: ${"Version"} Measure Dimension: Input |
| Next Year | The first year for Mid-Term Planning, input figure |
Month: The value of the “Next Year” attribute as of selected Month Version: Mid-Term Planning Measure Dimension: Input |
| Next Year+1 | The second year for Mid-Term Planing, input figure |
Month: The value of the “Next Year” attribute of the next year Version: Mid-Term Planning Measure Dimension: Input |
| Next Year+2 | The third year for Mid-Term Planning, input figure |
Month: The value of the “Next Year” Attribute of the next but one year Version: Mid-Term Planning Measure Dimension: Input |
| ∆FC% | Deviation between forecast and previous year’s figures in % | (['FC']-['PY']) / ['PY'] |
| ∆Next Year YOY% | Deviation between forecast and the first planning year | (['Next Year']-['FC']) / ['FC'] |
| ∆Next Year+1 YOY% | Deviation between the first and the second planning year | (['Next Year+1']-['Next Year']) / ['Next Year'] |
| ∆Next Year+2 YOY% | Deviation between the second and the third planning year | (['Next Year+2']-['Next Year+1']) / ['Next Year+1'] |
| Comment | You can comment your input |
Month: ${"Month"} Version: ${"Version"} Cost Center_measure: Comment |
Updated September 12, 2024