Skip to Content

JOIN_BY_SQL parameter has no effect on SQL generation for multi queries

Dear Experts,

I am working on a universe which has multiple traps. I have resolved it with multiple contexts but when I see the sql script generated by the query both in IDT and Webi it generates multiple queries/flows.

I have set the Join_by_sql in the universe parameter at the data foundation layer. It is suppose to merge multiple queries into one single querie, creating a union in between the different queries. But setting this parameter has no effect on the SQL generation.

Do I need to set any other options in the universe settings along with setting this parameter? I am working with BO 4.2 SP3 and Oracle 11g.

Following are the screen shots from the systems :

Universe & contexts:

Parameters set at the data foundation layer:

Parameters set at the business layer:

Query in IDT:

Query in WEBI:

Any help in figuring out this behaviour would be appreciated. Thanking you in advance for your response.

Warm Regards,


sc01.png (9.6 kB)
sc02.png (15.1 kB)
sc11.png (12.9 kB)
sc1.png (4.7 kB)
sc2.png (3.8 kB)
sc03.png (4.6 kB)
sc13.png (13.1 kB)
Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Posted on Aug 03, 2019 at 11:42 AM

    Bassam Jamil did you get any solution for this? Please let me know.

    Add comment
    10|10000 characters needed characters exceeded