Posted by Rajesh Setty on Wednesday, December 15, 2010
Hi,
In SSAS 2005 MDX we have Range function. This function is very good for any data which is sequential and good for some in some scenario like Date range.
Unfortunately we can't use the same for Amount data like >=50 and <=100. When you have such requirement, I would suggest using Exists function instead of Range operation. In addition using Exists will help using same hierarchy twice once for Min and second for Max.
Will update this post soon with more details.
Keep reading,
Raj
Tags:
alternative to mdx range operator
