BO4 - Cannot use combined queries when writing report aganist a specific universe

[former_member272336]

Hi,

As an Adminstrator user unable to write a report with combined query aganist a specifc universe (Audit universe).

Can create query fine against it but the add combined query not available for this universe - greyed out

Other universes this is possible for the user to add combbined query.

What property governs the ability to add combined query when writing queries?

Thanks

[Former Member · Accepted solution]

Hi,

In universe parameter for business layer, check the option "Allow use of subqueries" under query options.

[former_member272336 · Accepted solution]

Hi,

Found allow use of union,intersect and minus operators there and checked.

Thanks for advice.