Skip to Content
0
Former Member
Jun 23, 2009 at 01:48 PM

Logic Doubling in v7 SQL - Dimension with 3 hierarchies

24 Views

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