ABSTRACT
To move into the Beta version, we need to back up and fill in some of the components of this general warehouse design that we were able to skip while building the Alpha version. We want the entire design in place for the Beta version so it will remain stable right through to production. To accomplish this, we need to add more capability to some of our dimensions beyond what the Alpha version required as well as establish a capability to initialize the warehouse in such a way that we’ll be able to quickly reinitialize all data structures repeatedly during Beta development and testing. As we move toward a more generalized ETL architecture, we need to explore how capturing specifications in the metadata dimension will determine how data are processed in the warehouse, and we need to understand what that metadata is and how it gets defined by the source data analyst. Specific components to be completed here include:
◾ Expanding the domain of the Unit of Measure (UOM) dimension to include value-specific entries that allow for more control over querying common values that might appear in the Fact table but that can be more efficiently queried as details of the UOM.
