Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This Waterfall template comes, as all the other templates, fully standard with the library of templates within the CXO-Cockpit.

The reportsReport, built within with the Waterfall template , are used to analyze the variance between two periods Periods or categories Categories for an accountAccount.

Please, see See an example below:

  1. The waterfall Waterfall shows the positive or negative contribution of a region an Entity or any analytical dimension member to the variance between budget Budget and actual Actual for an accountAccount. This can be a change between any categories Categories within a month or a change over a range of time periods. When you click on one of the red, yellow or green bars the waterfall will drill down one level in the member hierarchy if available and show details for that member in the bar charts on the right. In this example we are looking at the Net Sales account Account that you can select and change via using a pick list (1A).
  2. With this button you can choose whether you view the data in the waterfall Waterfall graph from a base member perspective Base Member perspective (lowest level in hierarchy) or from an aggregated Direct Member perspective (in this example the children of Entity - Comma Communications Inc.).
  3. You can select compared categoriesCategories, by using a pick list
  4. With this button you can switch between regular Regular view and zoomZoom View. The Regular view shows the waterfall Waterfall with X-axis from zero to the highest value and zoom shows Zoom highlights the area where the actual variance is.
  5. The top right bar trend chart shows the account Account (1A) for the dimension dimensions in the POV in two categories Categories for the current and previous 5 months. You can look for further details by clicking on any bar behind an account in the waterfall and choose show detail or drill down. The displayed categories Categories can be changed in the business Report settings.
  6. The bar chart in the right bottom bottom right trend chart shows the varianceVariance. You can choose between variance Variance in percentages and absolute values or percent.