Context not generating seperate SQL

Need help figuring out why 2 seperate sqls are not being created. I have a 3 tables.
Claims
Policy
Policy_Alias

Claims is linked to Policy. Policy linked to Policy_Alias.

I have created 2 context.

1 - Claims to Policy — enabled. Policy to Policy_Alias disabled.
2 - Policy to Policy_Alias enabled. Claims to Policy disabled.

When I use the objects/measure from Claims and Policy_Alias, I should 2 sperated quries, correct.

For some reason I don’t. I have made sure that option ‘Use Multiple SQL Statement for each Context’ is checked.


kpiracha (BOB member since 2011-03-23)