BusinessObjects Board

Context not generating seperate SQL

building semantic layer
#1

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)

#2

It may be the case that you haven’t pulled objects into the query which will generate two queries.

If you have measures in both tables, make sure that your Policy measures are from the Policy_Alias table and your Policy dimensions are from the Policy table.