I haven&#x27;t actually built a cube myself, but I support a few right now.  My boss, who built ours, always refers me to Ralph Kimball&#x27;s &quot;The Microsoft Data Warehouse Toolkit&quot; (you mentioned Oracle, so maybe there are synonymous toolsets out there)<p>I know you said you&#x27;re aware of Ralph Kimball, but the first ~100 pages are broken into 1) Defining the Business Requirements and 2) Designing the Business Process Dimensional Model.  It&#x27;s really helped me wrap my head around the original design of the Facts and Dimensions as they relate to the business.