Optimized Sales Mart Data Structures- New School of Thought
Typical 2 years Sales Data Mart contains detail and aggregates in order to support time traverse metrics like 4 Week Shipments, 13 Week Shipments and so on...
The typical dimensional or normalized data structure marts creates more challenges from processing as well as data delivery stand point. In spite of managing varied level of aggregates and pre-calculated metrics, evolving/changing business queries often access detail fact and that does not provides expected performance covering 360 dice-n-slice
Is there any other school of thought to model data structures in order to optimize multi-terabyte analytic on Sales data mart, and does cover time traverse KPI's with an ease of data processing and delivery?