The specified criteria did not result any data

User_S34HA

Hi,

I have 10 OBIEE reports that works fine and show results for users that belongs to BIAutors group.

After some time, when those users execute reports, reports returned a message: The specified criteria did not result any data,

and when we run reports with Administration users we get data for same parameters.

We use relational Oracle table as source for those reports.

Do you have any idea how can I identify where is the problem?

Joel

what have you checked so far? Have you compared the log file for execution of these analyses run as Admin users and the BIAuthor users? Does the query in the nqQuery log file look the same?

You haven't mentioned OBIEE version, OS etc as well...

Gianni Ceresa

Hi,

Logs ...

Look at the generated queries, check if there is some user based security which is applied to the users and not to your admin account, check if it's caching issue etc.

EDIT: well ... Joel is quicker in posting

Joel

[Deleted User]

What no one of my 2 joker friends mentioned:

3802386 wrote:Hi,I have 10 OBIEE reports that works fine and show results for users that belongs to BIAutors group.

^--- Are those really BI Publisher "reports"?! Or are you just using the technological terms wrong and you mean OBI "analyses"?

It's two different technologies. Yes, both technologies process and display data, but you can't call a cow a goat either just because both produce milk.

Gianni Ceresa

You have a copyright on that one Christian, I didn't mention it to not have to owe you any money

Joel

I'll avoid that one as well from now. I don't want any copyright infringements

User_S34HA

Hi ,

I am new with Oracle BI stack so pardon me if I ask some newbie questions

We use Oracle Business Intelligence 11.1.1.6.2 version, OS is Red Hat Enterprise Linux.

When I execute report with administrative user, in Monitor SQL ( on SQL developer) i see query that report sent to database and execution of that query.

But when I execute report with users that do not have administrative rights, I dont see any query that is executing on SQL developer.

Its seems that report does not send, for some reason, any query to SQL Developer (so report does not have any data to present).

Gianni Ceresa

That's why you need to look at the logs of OBIEE, not outside OBIEE. You now need to find out what OBIEE understand and try to do with these analysis (assuming it's an analysis and not a BI Publisher report).

[Deleted User]

3802386 wrote:Hi ,I am new with Oracle BI stack so pardon me if I ask some newbie questionsWe use Oracle Business Intelligence 11.1.1.6.2 version, OS is Red Hat Enterprise Linux.When I execute report with administrative user, in Monitor SQL ( on SQL developer) i see query that report sent to database and execution of that query.But when I execute report with users that do not have administrative rights, I dont see any query that is executing on SQL developer.Its seems that report does not send, for some reason, any query to SQL Developer (so report does not have any data to present).

So are those really reports in BI Publisher or are they analyses?

It's different technologies and hence different log files.

Thomas Dodds

Adding clarification:  you are using SQL Developer to just monitor DB sessions?