Is OBIEE capability to handle 32 Union sql — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Is OBIEE capability to handle 32 Union sql

Received Response
11
Views
3
Comments
Vamsi Rampalli
Vamsi Rampalli Rank 4 - Community Specialist
edited Aug 13, 2024 5:48PM in Oracle Analytics Cloud and Server

Hi All ,

I have requirement in my project that need to create a report based on 32 union sql.

Is OBIEE capability to handle 32 Union sql ?

Please let me know.

Thanks ,

Bharath

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Never reached 32 but once created one with 20 on 11g, so my suspicion is yes it can, and I have not seen any documented limits on number of unions.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    a) That's not a "requirement", that's pasting a SQL for which the actual "requirement" has never been looked at

    b) Have you tried it? Why ask rather than clicking it together and seeing whether it works? Takes about as long as write this post.

  • Vamsi Rampalli
    Vamsi Rampalli Rank 4 - Community Specialist

    Thanks for your reply.

    I haven't tried yet. This request has been dropped from my client.