I have a cube I'm building where one dimension has a many-to-many
relationship with the source data. This is resulting in duplication of
data in the cube when I DON'T specify that dimension in a query. How
can I work around this? I'm fairly new to AS, and am probably just
missing a way to do this..I hope.

Thanks,
Darren

unfortunatly, AS2000 has a bad support for many to many relations.
while AS2005 is really excellent for this job!

but there is solutions to solve the issue.
you can create 2 cubes, 1 with the duplicated information, the second
without the dimension which generate the duplicated information.
create a virtual cube and create calculated measures.
then add some IIF clause, if the user ask for the dimension, then use a
measure from the duplicated cube if the user doesn't ask for this dimension,
then return the measure of the second cube.


<darren (AT) ecentral (DOT) com> wrote