select Dim1.column1, avg(a.measuer1), avg(b.measure2), min(a.test_date), max(a.test_date), min(b.test_date), max(b.test_date), count(*)
from Fact_Table1 a, Fact_Table2 b
where a.hd_num = b.hd_num
and a.final_test = 'Y'
and b.final_test = 'Y'
group by Dim1.column1
When i try to do the abouve query, BO Full client is generating two queries. I tried to use Conmine queries but not getting the required results.
Could somebody explain that Any action to be done in the universe or there any way to resolve in Full Client.
[edited, used bbc formatting using the CODE option - Andreas]
select Dim1.column1, avg(a.measuer1), avg(b.measure2), count(*)
from Fact_Table1 a, Fact_Table2 b, Dim1
where a.Dim1_column2= b.Dim1_column2
group by Dim1.column1
Fact_Table1 and Fact_Table2 are joined to Dim1 by Dim1.Key1
[Used CODE formatting, please use the formatting options when you post - Andreas]
Prob1: BO is genrating two queries, as soon as I select measures from two fact tables
prob2: I want to have details of common items (Column in Dimension)between two Fact tables.