Implementing Financial Dimensions for D3FO - Part 3
Click here to read part 1.
Click here to read part 2.
In the first segment of this series we looked at traditional segmented general ledgers compared to dimensional general ledgers. In part two we looked at some different reasons to chooses to use dimensions or use alternative systems. In this section we are going to specifically explore profitability statements, such as Item/Family/Brand, Customer/Group/Market, Region/Territory, and so on.
Profitability Statements: GL vs. Alternate Systems
- The ability to pre-define values, which prevented erroneous or duplicate data.
- A mechanism for correcting data. Sure, it was more painful than watching Keanu Reeves do Shakespeare, but at least you could do it.
- A lot of control over what was included in the profitability statement. For example, if you wanted a fully allocated P & L using different metrics as the basis for allocating various line items, you could do it. And hey, it wasn’t even as painful as Neo playing Hamlet.
- The General Ledger, either with or without dimensions.
- Sales Analysis Reports – By this I mean tabular or graphical reports that use the financial data from the sales order or invoice line within the report.
- Business Intelligence – On Line Analytical Processing, Power BI, or OLAP, tools.