Oracle Business Intelligence Applications

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

Categories

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

AOR users are not able to view the results of LOGICAL SQL otbi report - getting No Results

Received Response
24
Views
4
Comments
Rama123-Oracle
Rama123-Oracle Rank 2 - Community Beginner
edited Jan 31, 2025 5:21AM in Oracle Business Intelligence Applications

Hi Experts,

AOR users are not getting any results it says

No Results

the specified criteria didn't result any data etc..

image.png

Where as the persons who have BI Admin role are able to access the report, please suggest how to debug this. thanks in advance..

below subject areas are used:

Recruiting - Recruiting Real Time, Workforce Management - Worker Assignment Real Time

Tagged:

Answers

  • Bhaskar Konar
    Bhaskar Konar Rank 8 - Analytics Strategist
    https://community.oracle.com/products/oracleanalytics/discussion/24470/aor-users-are-not-able-to-view-the-results-of-logical-sql-otbi-report-getting-no-results

    Hi @Rama123-Oracle,

    It might be the issue with Role. Can you please check if those users have correct roles to see data for the Subject Areas that you mentioned.

    Also you can check if the users are getting data from those subject areas or not by creating a simple analysis from respective SAs.

    Hope this help.

    Cheers,

  • Rama123-Oracle
    Rama123-Oracle Rank 2 - Community Beginner
    edited Jan 31, 2025 7:41AM

    thanks for quick response basker, they are able to access those two subject areas and the sample report from those two subject areas in the same folder. however after adding logical SQL by joining those two subject areas, they are not seeing results in report. me and others are able to view the results without any issue. any help would be greatly appreciated..

    If we use the logical SQL, will the same subject area security works? it breaks anything on security of SA? Please suggest..

  • Bhaskar Konar
    Bhaskar Konar Rank 8 - Analytics Strategist
    https://community.oracle.com/products/oracleanalytics/discussion/comment/63371#Comment_63371

    Hi @Rama123-Oracle,

    It's bit strange.

    As per my knowledge, Logical SQL follow the same security as Subject Area.

    Can you please compare the session queries? execute the report by your user id and track the session query then ask the user to execute the same report and track the session query. (both user should have same roles if there is difference in roles please assign / remove to see if there's any change)

    Now compare both queries to see if it is getting generated same or not and what are the differences like any security filter etc. due to role.

    Hope this help.

    Cheers,

  • Gianni Ceresa
    Gianni Ceresa Mod

    @Rama123-Oracle , your users are able to see the analysis, but it simply doesn't have any data to show (it's different than not being able to see it).

    If you, with different roles, have results when opening the same analysis (assuming same prompts/filters if any), it's probably because of some row-level security jumping in. Check the logs for you and for one of the user with the issue.

    The logs will tell you what LSQL is generated, it could be the exact same one, and then look at the physical SQL, and there you could see that extra conditions are injected into the query returning no data. That could be row-level security or some other role-based filter in the model.

    But everything should be visible in your logs when comparing an execution returning data and one returning no data.