2 Replies Latest reply on Apr 6, 2017 7:45 AM by FTisiot

    Bringing in tables from Database

    3427784

      Hello -

       

      I currently have 7 different tables that host documents and its pertaining demographics in Oracle Database. Problem - I'd like to create a union or some sort to concatenate all 7 tables into one so that I can load this into OBIEE to use to generate charts. Is there a way to combine all 7 into one (they all have the same dimensions)?

       

      Best,

      Andrew

        • 1. Re: Bringing in tables from Database
          Gianni Ceresa

          Hi,

          Do you look for a solution in OBIEE or in general in your DB?

          OBIEE can definitely manage your 7 tables and query them all together (defining 7 LTS for your logical table) or you can just "unify" them at the DB level. The simplest way is a view.

          I would avoid an opaque view in OBIEE as that's really hiding logic.

          • 2. Re: Bringing in tables from Database
            FTisiot

            I would avoid doing it with a VIEW in the DB but rater importing all 7 and use OBIEE's fragmentation if there is a way of telling to OBIEE which partition of data is within each table.

            The view option will always query all 7 sources while using fragmentation you'll hit only the fragment with the data you need if you specify the fragment partitioning key