Showing results for 
Search instead for 
Did you mean: 

Reorder table joins after FROM

0 Kudos

Hello everyone,

I am looking for some solution or advice, if I can reorder tables joins in FROM clause at generated SQL query. I made an universe with Information Design Tool, and at the WEBi report level in BO, SQL query is generated with right outer joins and table after FROM clause is dimensional table (small one). I would like to reorder the tables, put at first fact table and then join dimensional tables.

I found some advices at this forum, some for Universe Design Tool, some doesnt work (etc set Business Layer parameter reverse_table_weight=Yes). I guess, this advices are obsolete.

Would someone have an advice?

Thanks in advance


Accepted Solutions (0)

Answers (0)