That option is used when you have the need to query measures from multiple fact tables; it will create a SELECT for the measures in each fact table. It was discussed here. It also is used to help solve Fan Traps, but in that case all measures must have SQL aggregate functions applied (it won’t work if the SELECT doesn’t generate a GROUP BY).
charlie (BOB member since 2002-08-20)