How to Avoid Many to Many Join in Universe

[vemu]

I have to bring data from more than 3 fact tables to show in a report, so my universe is having many to many join between the fact tables.

The problem here is when we send the query to the database it is getting more than a billion records and the query is not returning back.

Is there a way to avoid many to many join in the universe? like having a bridge tables in between the facts.

Any help on this is greatly appreciated

 

[synapsevampire]

I don't use Universes, tending to avoid all proprietary data source layers.

If the data is from 3 fact tables, consider creating a UNION ALL query along these lines:

select 'fact1' datasource, value from table1
UNION ALL
select 'fact2' datasource, value from table2
UNION ALL
select 'fact3' datasource, value from table3

Joining is likely creating row inflation.

-k