Joins & mapping in LTS - Page 2 — Oracle Analytics

Oracle Analytics Cloud and Server

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

Joins & mapping in LTS

Received Response
21
Views
13
Comments
2»

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    A leading practice in OBIEE is to alias all your tables in the physical layer ... then you can actually have a 'star'; you'd be joining facts but you'd be joining the dimension alias of that table.  While it might seem a case of semantics, it helps to preserve the 'theory' in the diagram.

  • 2973433
    2973433 Rank 3 - Community Apprentice

    Thomas,

    I understand your point, however it's not essential problem in this topic.

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    Hello, if your requirement is to select only select reversals, the redemption partner and transactions relation and only show

    The thing that if I create for example report with columns from Reversals, Redemptions, Redemptionpartner, I would like to use in select only these tables + Transactionsrelations, but instead of this OBI does select with all these tables that are in the picture.



    You have to create an only one LTS for your "transaction measure" logical fact table, and in the LTS add in a join setting all your transaction tables, after it, you should ensure an only one LTS for your dimension tables.