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

OTBI - The specified criteria didn't result in any data. when adding department under workforce mana

Received Response
244
Views
4
Comments
King Jack
King Jack Rank 2 - Community Beginner
in Oracle Transactional Business Intelligence

Content

Hi,

I've added the columns I need from the WORKER folder and the result come back nicely. As soon as I add a column from any other folder, no results are brought back.

I am in the "workforce management - worker assignment real time" subject area

Why is this happening and what can I do to resolve this issue?

Thanks,

JJ

Tagged:

Answers

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

    The RPD is messed up and since it's OTBI you can correct the mistake yourself.

    Open a Service Request

  • RichardChan
    RichardChan Rank 6 - Analytics Lead

    You have a join or level issue in your RPD,

    What granularity are your columns, can you be more specific with what columns are being added. Check you have set up joins between these data items and have set up your levels correctly, if necessary set Fact levels to "Total" level to bring in the data.

    Are you in this situation : https://www.kpipartners.com/blog/bid/83120/What-To-Do-When-OBIEE-Fact-Tables-Do-Not-Join-to-All-Dimension-Tables

    https://greatobi.wordpress.com/2011/06/24/making-dims-facts-work-together/

     

    Richard

  • King Jack
    King Jack Rank 2 - Community Beginner
    • I am in the "workforce management - worker assignment real time" subject area
    • I add person_number from WORKER on its own - brings back everything
    • I add department level 3 from DEPARTMENT > HIERARCHY on its own - brings back everything
    • I bring back both - it brings back nothing
  • [Deleted User]
    [Deleted User] Rank 7 - Analytics Coach

    Yes and that points to an error in the RPF concerning non-conformed dimebsionalities which is why Richard wrote that explanation.

    But since - iirc - you can not change the otbi rod yourself you can bot fix it yourself.

    If you can change the otbi rod then all the better and you can eliminate it.

    Alterntively you can add the following to the analysis in the advanced tab:
    SET VARIABLE ENABLE_DIMENSIONALITY=1;
    But beware - that is a CHEAT and not a fix!