Sorry, I am pretty new in using MS SQL OLAP analysis services. I have
created two shared dimensions in my OLAP database:
1. Fiscal date
2. Order date
I want to use the fiscal date to filter out the order dimension. For
example, if I selected Fiscal Year 2005, Qtr 1, Month Jan; I want the
Order date dimension to show only those dates that fall within that
range. Presently, it is showing all the order date in my cube browser.
Is there a way to create relationship in MS SQL server to link up the
two dimensions. Thanks in advance.

Sonny Wong