Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
The specified criteria did not result any data
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?
Answers
-
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...
0 -
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
0 -
0
-
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.
0 -
You have a copyright on that one Christian, I didn't mention it to not have to owe you any money
0 -
I'll avoid that one as well from now. I don't want any copyright infringements
0 -
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).
0 -
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).
0 -
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.
0 -
Adding clarification: you are using SQL Developer to just monitor DB sessions?
0
