Report Portal

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

Read more...

Tags: mdx

 

2007-2015 VidasSoft Systems Inc.