evaluation of ranges between date dimensions (calculations)

hi chaps,

i need compare 2 role playing date dimensions within calculation.

i have dimension [order date] , dimension [product active]. both are linked same measure group contains orders, order date directly , product active dimension attribute of product.

in order evaluate "an order" order date needs compared product active date.

in sql terms order date <= product active date.

what best performant solution compare such 2 dates (maybe there generic article discusses >= , between etc between dates)

---

business intelligence professional

you can use filter function , compare on keys.

http://www.ssas-info.com/analysis-services-faq/27-mdx/76-how-compare-members-from-different-dimensions-that-have-the-same-key-values

you can use 

[].[].currentmember.membervalue <= [].[].currentmember.membervalue within filter function 

some example of filter having here

http://www.databasejournal.com/features/mssql/article.php/3662721/mdx-clauses-and-keywords-use-having-to-filter-an-axis.htm

 

---

vinu

SQL Server  >  SQL Server Analysis Services