OTBI Not getting records

Nilesh Kulkarni

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

[Deleted User]

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.

Nilesh Kulkarni

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?

Nilesh Kulkarni

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?

Thomas Dodds

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.

[Deleted User]

Thomas beet me to it. You need to comprehend what's going on underneath.