Oracle Business Intelligence Applications Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Business Intelligence Applications Forum

Categories

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

OBIEE Measure & Joins Required?

Received Response
41
Views
4
Comments
G.Adashek
G.Adashek Rank 3 - Community Apprentice
in Oracle Business Intelligence Applications Forum

I have a set of tables that 1) do not have any logical join(s) 2) do not have a measure.

What should I do for the combination of these 2 as I attempt to create a new Subject Area?

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Well ...

    You must define a measure somewhere as the BMM must be a perfect star, so there must be a measure and dimensions linked to it.

  • G.Adashek
    G.Adashek Rank 3 - Community Apprentice

    Okay, since I don't have anything that is a natural fit, I will just go ahead and pick 1 and see what happens.

  • Gianni Ceresa
    Gianni Ceresa Mod

    You can also just add a count on one of the keys and that is your measure.

    In your tables there must be something countable or that can be aggregated, if you don't have anything you can't really do analysis but just reporting on your data.

  • G.Adashek
    G.Adashek Rank 3 - Community Apprentice

    Ah, yes. Thank you, I will try that!