AS2K does not support structures like this. However you can in AS2K5. This
is one of our core new features.

Signature
Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
> We have a db with the following schema:
>
[quoted text clipped - 34 lines]
> What possibilities do we have using SSAS to achieve the equivalent of the
> sql statement mentioned above
Ron - 11 Oct 2005 00:21 GMT
Dave,
I am trying this on 2005.
Ron
> AS2K does not support structures like this. However you can in AS2K5. This
> is one of our core new features.
[quoted text clipped - 36 lines]
> > What possibilities do we have using SSAS to achieve the equivalent of the
> > sql statement mentioned above
Darren Gosbell - 11 Oct 2005 01:59 GMT
Couldn't you create a view that joins the AB and BC tables giving you
vwAC and then use that to join A to C in a standard many-to-many
reationship?

Signature
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell
> Dave,
>
[quoted text clipped - 33 lines]
> > >
> > > Issuess with SSAS:
Ron - 26 Oct 2005 17:40 GMT
Thank you. Your solution gave the desired effect.
> Couldn't you create a view that joins the AB and BC tables giving you
> vwAC and then use that to join A to C in a standard many-to-many
[quoted text clipped - 37 lines]
> > > >
> > > > Issuess with SSAS: