How to Use MDX Dimension Formulas
In SQL 2000, AS does not recognize the separate dimensions as a single dimension when considering dimension formulas. In SQL 2005, AS does recognize the separation as a single dimension but consider formulas by hierarchy. These differences have created the need for this document.