Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 233 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OTBI Not getting records
In BI I Created OTBI report for that I selected Work force management document of record real time subject area where multiple folders are there under that subject area, Consider following situation
1) suppose I selected column(person number,display name) which are under 'worker' folder then I am getting rows which showing person numbers and display names after selecting result tab.
2) now along with above column I selected document name which is present under 'document of record detail folder', now output should come like person number display name and document type.
But I am getting following error
| No Results | |
| The specified criteria didn't result in any data |
Answers
-
3331303 wrote:But I am getting following errorNo Results The specified criteria didn't result in any data
That's not an "error". That means precisely what it says: There was no data pulled up for your current query. Again: not an error.
You'll need to properly investigate within the confines of what's possible in OTBI.
0 -
Yes it is not error thank you for answer but i have one more doubt,
In BI if we create data model and if we wrote query by joining two tables hr_documents_of_record and per_all_people_f with person_id we can get document_type for particular person_number.
But here by selecting 'Work force management document of record real time subject area' why it is not return any row?
0 -
Could you please reply for this,
Yes it is not error thank you for answer but i have one more doubt,
In BI if we create data model and if we wrote query by joining two tables hr_documents_of_record and per_all_people_f with person_id we can get document_type for particular person_number.
But here by selecting 'Work force management document of record real time subject area' why it is not return any row?
0 -
You are using the pre-built model ... so you need to understand the pre-built model so you know why you aren't getting results when you expect them. You can write SQL and get data back - so that's all good ... now you need to study the joins and conditions in the physical and logical model for the pre-built. You need to see the logical and physical SQL that's being generated from those models.
0 -
Thomas beet me to it. You need to comprehend what's going on underneath.
0