Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

OBIEE Issue

41
Views
6
Comments
Manisha Singh
Manisha Singh Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

Summary

Report giving blank values for few columns when adding second subject area.

Content

I need to create report to pull performance rating given by manager. Right now i am using : Workforce Management - Performance Rating Real Time subject area. I need to get email id also for an employee so had added second subject area : Workforce Management - Person Real Time. But once i have added second subject area and checking results then few columns like Position Name , Job code , Department Name etc are coming blank. I have checked the dimensionality box in advanced tab also.

Please someone advice whether am i missing something.

Tagged:

Comments

  • Wade Wilson
    Wade Wilson Rank 4 - Community Specialist

    Hey Manisha - have you added a fact from each subject area?

    facts.png

  • Manisha Singh
    Manisha Singh Rank 1 - Community Starter

    Hi Wade , Yes I have added fact from each subject area.

    Also i observed that i am getting more number of records after adding second subject area.

  • Wade Wilson
    Wade Wilson Rank 4 - Community Specialist

    Manisha, I've had this happen once before. I rebuilt the analytic and it started to work again. Or you can create a copy of your current analytic and remove fields until it starts working again (to find the offending field).

    If you added Person Email, you may need to filter on Email type as well.

  • [Deleted User]
    [Deleted User] Rank 7 - Analytics Coach

    Sorry to chip in, but that kind of  behaviour  points to serious issues with the underlieing model and should be corrected at the source of the issue.

    Just "playing with" the analyses is questionable at best since not everybody will check the numbers because they - rightfully - assume that the system is supposed to deliver correct numbers.

    It's "Analytics" and not "guess the number".

  • Wade Wilson
    Wade Wilson Rank 4 - Community Specialist

    Yup - the subject areas are riddled with issues and instability. In some cases, by the time my SRs are created and an OWC is ready, it just starts magically working. We've been replacing with SQL reports where possible.

  • Chandra Yerra
    Chandra Yerra Rank 3 - Community Apprentice

    Things to consider when the report is build with more then one subject areas:

    1. You should have common dimension in all the subject areas
    2. Add Measure/Fact from each subject area on the report
    3. In case of unrelated dimensions, apply the "Dimensionality" hint on the OTBI analysis
    4. You should consider the possible grain levels of the different Subject areas