• Nish, if thats the case, why not use a Hybrid Query(Mix of MDX and SQL)

    See this: http://www.sqlservergeeks.com/blogs/suhas/personal/545/sql-mdx-in-one-apartment-hybrid-query

    Raunak J