I'm having a problem with logic doubling at a client where I have a dimension with 3 hierarchies in v7 SQL 2008. When I try to run logic off a property in this dimension, base members in all 3 hierarchies are doubling, whereas base members in only two hierarchies are not. I've tried using *Membersets, *Select, and *XDIM_Memberset statements to stop the values from doubling, but I'm not having success.
Any ideas? Has anyone else seen this?
Thank you,
Grant