Hello,

I have a problem in processing the cube and getting correct values. In one
of my dimension there is Many-To-Many relationship and because of that, the
results are not correct.

Is there any workaround/solution for this situation. I am using SQL Analysis
Services 2000.

Thanks in advance.

Manoj

Unfortunately, No. In SQL Server 2005, we will support many-to-many
dimensions natively, but with 2000, a member can only have one parent. For
simple situations, there are techniques for doing many-to-many in very limit
circumstances. For example if the many-to-many not within the hierarchy, but
between the fact table and the dimension, e.g. if at the leaf level, you can
have two members have the same key, which will have the row double counted.
This only works if the many-to-many is very infrequently because the inner
join will explode the number of rows that AS sees, i.e. it isn't scalable as
a general solution because it has an exponential increase in the number of
rows in the fact table loaded to AS.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Manoj" <Manoj (AT) discussions (DOT) microsoft.com> wrote