Check the settings of Member Keys Unique and Member Names Unique properties
in the advanced tab on the level. If this doesn't work, what error are you
seeing during processing?

- Matt Carroll
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Eugene" <shieug123@yahoo.com> wrote in message
news:da0b8ea2.0307220810.554520ea@posting.google.c om...
> Hi,
>
>
> I run into the problem when I learn and practice the dimensional
> modeling. I try to use snowflake schema and my secondary dimentional
> tables (those dimentional tables link to the first level dimensional
> tables but not directly link to the fact table) have many-to-many
> relasionship with the first level dimentional tables, so I have to use
> a link table between those relasionship, but when I do so, the
> processing failed in SQL Server OLAP environment.
>
> Am I doing something wrong here? Or what should be the correct way to
> do that?
>
> Thanks in advance for all the help!
>
>
> Eugene