I have one fact table which record every year's finance data, example, total revenue and collect date
I want to compare two or three or ... year's data in one table.
If I use SQL, I will join the table column year and set alias name.
select a.total_revenue, b.total_revenue
from fct_fi a, fct_fi b
where a.year = (b.year + 1) and a.item = b.item
But In Business Object Desktop Intelligent, I only can build up two query, but I don't know how to let the two query produce releationship like the SQL descript.
Can any one help?
New in Business object