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

Popular posts from this blog

Conditional formatting a graph vertical axis in SSRS 2012 charts

Register with Power BI failed

SQL server replication error Cannot find the dbo or user defined function........