JOIN_BY_SQL parameter has no effect on SQL generation for multi queries

[bassam]

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,

Bassam

[denis_konovalov]

I have removed tags that are irrelevant to your question. Please select more careful.

[deshmukh]

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