Circular Joins in Yellowfin
Currently we have 5 dimension table and 50 fact tables.
Each fact table needs to join with the 5 dimension tables. In our model we already applying the workaround by creating alias, by creating join filters where we have to create less alias. In our case we have many fact tables so for each fact we are having to create an alias for each dimension table.
So If Yellowfin were to provide something where we can join this 5 dimension table with the different fact tables like d1.t1 = f1.t1, d2.t2 = f1.t2, d3.t3 = f1.t3, d1.t1 = f2.t1, d2.t2 = f2.t2, d3.t3 = f2.t3 and in case which ever object we drag then that associated join will come into the query.