Unfortunately, these two crucial dimensions almost never conform to operational dimensions such as customer, product, service, or facility. This leads to a characteristic but unavoidable business user frustration that the “GL doesn't tie to my operational reports.” It is best to gently explain this to the business users in the interview process, rather than promising to fix it because this is a deep seated issue in the underlying data.
- Chapter 7: Accounting
- from The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition
- Publisher: John Wiley & Sons
- Released: July 2013
Share this highlighthttp://www.safaribooksonline.com/a/the-data-warehouse/4888295/