The reports build on this template are used to analyze the relation between three accounts within an analytical analytic or entity dimension. The screenshot below shows an example of a report built based on this template. If we look at the total revenue of Phone Computers and PDA’s Networking, we can detect that it has achieved exceeded the target as set in budget, but it has been achieved by selling higher numbers at a lower price per product.
What is viewed in this example?
- The portfolio shows a breakdown of the top member of a (analytical) dimension into its direct descendants for the selected member of any analytical dimension selected in the POV. You can select reference categories, by using a pick list (1A).
- The top bar chart on the right shows the account specified on the Y Axis of 1 (units soldSales Growth %) for the selected descendant in the graph for the current and the last five six months.
- The middle bar chart on the right shows the account specified on the X Axis of 1 (price per unitGross Margin %) for the selected descendant in the graph for the current and the last five six months.
- The bar chart on the bottom right shows the account specified on the Z Axis of 1 (total revenue Gross Margin in millions) for the selected descendant in the graph for the current and the last five monthssix.