Ordering of Tables within a search query (SAP BO IDT)

[Former Member]

Hi I have a a query which joins 3 tables and another table using full outer join. however I need to change the order of the tables as being generated by BO. I know that the table order is being generated using the max row count is there a way to override this other than custom sql?

[mhmohammed]

Hi Andrew,

Can you work with the parameter in Universe, Boundary_weight_table? 1st and 3rd (from last) parameters in this blog.
https://blogs.sap.com/2014/05/14/universe-optimization-techniques/

Thanks,
Mahboob Mohammed

[Former Member]

Hi Mahboob,
We are using IDT 4.1 to manage our universe and the article you mentioned i think refers to previous versions as i didn't find the properties mentioned there.

Thanks
Andrew

[mhmohammed]

Hi Andrew,

That parameter still exists, you'll have to find and add it as in the pic.

Thanks,
Mahboob Mohammed