SIMPLE MDXes for time periods
Couple simple MDXes which might seems to be very simple and with old syntax (with brackets in syntax, that is not required for MSAS 2005).
Looking at those MDXes I may hear that the members or schema of cubes can be improved but the idea it to structure the MDX query as
1. Calculated members
2. rows
3.columns
4. hardcoded where cause
MDX=1+2+3+4
Tags: mdx