The autoexist feature used by MDX queries sent to an Analysis Services or Power Pivot data models can have different behaviors depending on the normalization level. This article describes these differences and provides best practices to avoid unwanted results.  Read more

DateTool is a special dimension containing regular members that act as calculated members similar to those generated by the Time Intelligence Wizard, without some of the limitations of the Time Intelligence Wizard.   Free download