Skip to Content
0

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

Jul 10, 2017 at 01:54 PM

51

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Mahboob Mohammed Jul 10, 2017 at 06:14 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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

0

Hi Andrew,

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

Thanks,
Mahboob Mohammed

1