This week’s video makes an outlandish prediction: that in the future companies will not have general ledgers, but instead use the increased compute capacities available from today’s ubiquitous computers to maintain much more granular ledgers, which have the GL perspective embedded in them. With all my experience with enterprise-wide financial reporting systems, I recognize how radical this idea is. And it’s not just the demise … Continue reading Outlandish Prediction: Demise of the G/L
Often discussions with others result in going back to the basic principle I talked about the relationship of the Data Warehouse to the General Ledger. That discussion focused on activity, the thing that creates journal entries. Today’s video builds on that but focuses on the balances. In the operational source systems, we typically make balances of some kind. Can one can accumulate all the balances … Continue reading Do Sub-Ledger Balances Add Up to GL Balances?
Objective One day in June 2020 I was encouraged to start a new POC. In simple terms, the idea was to read an XML file containing the processing specification for a z/OS tool, GenevaERS, and attempt to translate that into another language and file format. The target language was undefined; it might range from COBOL to Java to Scala to something else. It was an … Continue reading Fail Fast POC: Choosing and IDE and Language
On a large project one time a CFO had heard something about troubles in the project developing from using a “fully normalized data model” and asked me what that meant, and why it created problems. I had an idea of how to explain it in a simple way that would make sense to anyone who has worked with multiple tabs of a spreadsheet. Scope of … Continue reading Data Models Matter in Financial Reporting
A couple of years ago a friend was continuing to try to help Risk and Finance effectively coordinate their use of data, and asked me how would I get started on helping them. I noted that the fundamental problem in some instances is the imprecision of our language. We use a single term which actually refers to different things to different people. Solving this problem … Continue reading Metric Engine Step-Up: A Swimming Pool Example