Hi,

We are having problems when running our reports through OTBI Adhoc analysis.

The context of this specific report is a transaction history. The fields that do not return data and are extremely necessary for our business analysis are:

1. Invoice Number

This is a general problem we face at OTBI. We need to know if this field is not available in the Brazil region or how we can access it.

We tried several Accounts Receivable Subject area fields, without success. As you can see in the print, there is no data in this information. However, it is information that we have filled in the ERP.

2. Payment Due Date

We are facing a problem with this field, there is some data that does not reach the OTBI, even though there is information in the ERP like that:

3. Original Transaction Number

This is another example that does not return any data.

We are aware of the limitations of the analyses performed in OTBI, but since this is information that can be easily found in the ERP, as well as other information that returns data correctly,

We need guidance on best practices so that we can successfully extract this report.

There is a way how to we can extract all the fields/columns of a subject area, as well as their FK, so that we can identify which others we can connect information to. Is it possible to extract it like a table via SQL, for example?