Hi Andreas,
Thanks. You are right. When i take the measure group by (avg), BO is creating Join queries insead of Synchronisation queries.
Validating the data now (whether it gave the measures for common dimension items or not)
Before when i tried basic measure (fact columns only, not group by) Bo generated Synchronisation Queries. Is there way to use basic measures?
ravik (BOB member since 2004-06-02)