I need execute following join in OBIEE:
SELECT a.percent, b.dollars, b.year
FROM table1 a
inner JOIN table2 b
ON a.id = b.id and a.year = b.year
where a.id = '0001'
- I have added two Logical Table Sources and connected them: a.id = b.id in physical layer. That join working well.
- But, I need also another join: a.year = b.year, that's the problem how I do that, should I use some group by -feature or complex join? Or any other ideas?
You need to pull the year column in criteria and set the filter by some value if you have proper design you get the output.
Group by clause BI take care of it for you based on columns selected but make sure you got aggregations for percentage and dollars in bmm