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

Join two dimesion tables in OBIEE?

Received Response
102
Views
9
Comments
DollyG
DollyG Rank 5 - Community Champion
edited Aug 13, 2024 5:52PM in Oracle Analytics Cloud and Server

Hi,

I have a requirement where I have 3 dimensions, 2 dimensions are present in 1 table and the remaining dimension table in another table. (2 different dimension tables).

I have a Fact Table that needs to be joined to these dimension tables to plot the analysis.

Can anyone please tell me how to join these two dimension tables with my fact table?

Thanks,

Dolly

Answers

  • Martin van Donselaar
    Martin van Donselaar Rank 6 - Analytics Lead

    Can you please elaborate on your problem?  Hard to give a meaningful answer without any details.

  • Gianni Ceresa
    Gianni Ceresa Mod

    +1 Martin

    You have 1 physical table containing 2 dimensions? Why would you design it like that, in a DB you hardly pay based on the number of tables, so just give your 2 dimensions their own tables

    But it all depends on how this thing is linked to your fact ...

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

    And a huge +1 to Gianni:

    Two dimensions in the same table?! What kind of dimensions are those? Unless you are simply talking about roleplaying dimensions this is something which doesn't make much sense to begin with as it will cause you quite some problems with basically zero advantages. Literally: there is zero advantage in having two dimensions in the same table.

  • DollyG
    DollyG Rank 5 - Community Champion

    I think I was not able to ask my question properly. But, I am able to resolve my issue.

    Thanks a lot everyone for replying!

  • Martin van Donselaar
    Martin van Donselaar Rank 6 - Analytics Lead

    So were you talking about roleplaying dimensions as Christian suggested?

    And if so you solved this by creating aliases hopefully.

    Please update so that others may benefit as well.

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

    Please post your solution for the benefit of other users.

    This is a forum built on participation. Taking and giving.

  • DollyG
    DollyG Rank 5 - Community Champion

    Hi All,

    Actually my requirement was something like:

    Customer products ----> Customers ------> Sales

    Where Customer products and customers are Dimension Tables and Sales is a Fact Table.

    I was not able to join Customer Products and Customers. Then I created the above mentioned structure in physical layer. Then in BMM layer, rather then dragging (Customer Products and Customers) tables, I achieved it by using 2 LTS.

    Thanks

  • Martin van Donselaar
    Martin van Donselaar Rank 6 - Analytics Lead

    That doesn't seem right at all actually.

    As soon as you drag a column from Customer Product in your analysis your figures will explode as (i assume) customers have more than one product.

    What are you trying to achieve, by this i mean what is your functional requirement.

    -Are you trying to create a analysis of sales on Customer Products?

    -Do you want to show a list of Customers and the products that they have?

    - ...

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

    Beaten by Martin. That's just plain wrong.