SQL Server 2008 SP1 SSAS: Changed behavior of Ignore Unrelated Dimensions
sql server 2008 sp1 ssas: changed behavior of ignore unrelated dimensions
it's behavior of ignore unrelated dimensions has changed since sp1.
with 2005 , 2008 rtm behavior expected. example:
measuregroup dimensions product , customer , measure sales filtering on customer, product , other dimensions region gives following set:
product customer sales
a w 20
a x 10
b y 20
c x 15
measuregroup b dimension customer (and others) , measure #visits filtering on customer gives following set, product=[product].[product].[all]:
product customer #visits
all v 1
all x 2
all z 3
before sp1 complete set of customers v, w, x, y, z
but since sp1 looks customers matches filtering of measure group returned in result set of measure group b. in case x. complete set of customers now: w, x, y??????????
is bug? think so, or has changed?
i don't have example based on adventure. hope description adequate enough.
frank van zuilen
we're using sp1 , i've not seen changes due the ignoredunrelateddimensions property. behavior critical since we're calculating hmo utilization (claims , member enrollment) , claims has significant increase in number of dimensions (most major being facility , procedure). yet each share core dimensions, member, time, geographical location, plan, etc. i'd have thought have heard screaming if there major issue. can verify issue adventureworks?
SQL Server > SQL Server Analysis Services
Comments
Post a Comment