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

Obiee 12c creating analysis

Received Response
1
Views
2
Comments
mia101
mia101 Rank 1 - Community Starter
edited Aug 13, 2024 5:51PM in Oracle Analytics Cloud and Server

Hi ,

I am new to obiee and  having trouble creating an analysis based of a dimensional database. I have one table that holds all the column row values I want to match to the total number of employees that fit that category.

ie : the field Description has the following data in it

grad degree ,

undergrad degree,

some college,

highschool diploma,

ged,

n/a

what I want to do is be able to do is display the total number people in each of  these categories , by comparing them to a field in my fact table.In sql I can easily count the rows of employee id numbers where the category key is equal to that of the description field to figure out  the  total , but I am not sure how to do it in oracle.

In essence I want to be able to group the data based on each row in the  description column.

Thank you in advance.

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Hi Mia,

    group by is what OBIEE does as standard to all dimension fields, all you need is a suitable Fact measure like 'Count of People' and you are there, but unable as I am to see your subject area I cannot be more specific...

  • Gianni Ceresa
    Gianni Ceresa Mod

    You are talking about creating an analysis but in the same time describe tables and database structure and talk about SQL.

    Do you have a pre-built RPD and so you can only build analysis on top of it? You have to create the RPD first and then the analysis?

    It's a bit unclear what you exactly expect ...

    As Robert said, OBIEE does "group by" all the time as that's the default behaviour when you model things and define your measures. Your "total number of people" is generally achieved by a COUNT DISTINCT aggregation the employee ID, and as dimensions you have all your attributes you can group by and count employees by.

    So if you explain a bit more what's your situation and what you expect from us you will get a better answer