Oracle Communities

Oracle Analytics and AI

Child Item

Missing Field in Checklist Real Time Subject Area.

I am currently developing an analysis from a journey that leverages questionnaires. In each question, we provide the ability to add "Additional Comments". However, after pulling every field from the subject area, I have found "Additional Comments" isn't represented. That was further reenforced by questions here. My question: Is it possible if I have the table and field name to pull a field from the database itself into the analysis?

Find more posts tagged with

Accepted answers

RVohra

Hello, OTBI SA is restricted to whatever data elements are exposed in the delivered subject areas. You can’t reference base table fields or write SQL to fetch them in the OTBI front-end.

Hope it helps!

All comments

RVohra

Hello, OTBI SA is restricted to whatever data elements are exposed in the delivered subject areas. You can’t reference base table fields or write SQL to fetch them in the OTBI front-end.

Hope it helps!

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/27362/missing-field-in-checklist-real-time-subject-area

Hi @VictorAts,

Welcome to the Oracle Analytics Community!

Quick Question: How does the 'Additional Comments' field been configured in your application? Is it a DFF?

Thank you!

Bhaskar Konar

Hi @VictorAts,

If it is a DFF, it can be brought to the OTBI subject areas.

Please find below a high level steps that needed to be done For the DFF's to be available in OTBI.

While creating DFF segment, make BI enabled checkbox yes for the segment.
Deploy DFF.
Run the "Import Oracle Fusion Data Extensions For Transactional Business Intelligence" process from scheduled process area.

Hope this help.

Thank you.

Bhaskar Konar

Hi @VictorAts,

Please take a look into the following Oracle note for more details.

https://support.oracle.com/knowledge/Oracle%20Cloud/2151160_1.html

Hope this help.

Thank you.