Oracle Analytics and AI

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

Hi Experts,

AOR users are not getting any results it says

No Results

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

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

Find more posts tagged with

Reporting

BI Publisher

BI Publisher Data Models

OTBI

Accepted answers

All comments

Bhaskar Konar

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

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

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

@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.