Versions Compared

Key

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

This waterfall The Waterfall template comes, as all the other templates, fully standard with the library of templates within the CXO-Cockpit. The reports, built within  Reports built with the Waterfall template , are used to analyze the variance between two periods Periods or categories Categories for an account.Please, see Account.  See an example below:

Image RemovedImage Added

  1. The waterfall Waterfall shows the positive or negative contribution of a region an Entity or any analytical dimension member to the deviation variance between budget Budget and actual Actual for an accountAccount. This can be a change between categories any Categories within a month but also or a change over a time period (i.e. variance)range of time periods. When you click on one of the red or green bars behind a product you can choose to drill down or to show detail. When you choose to show details the bar charts on the right show the details for that product. When you choose to drill down the bar charts on the right will also show the details for that product and the waterfall will drill down one level in the entity hierarchybars 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 Profit account Sales 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 graph from a base member perspective or from an aggregated perspective.
  3. You can select compared categories, by using a pick list
  4. With this button you can switch between regular view and zoom. The Regular view shows the waterfall from zero to the highest value and zoom shows the area where the actual variance is4).
  5. The top right bar trend chart shows the account Account (1A4) 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.
  7. This is a selected list where the user can create the waterfall for.