Oracle Transactional Business Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Creating Subject Area / Presentation Table on other required Physical Table

1
Views
0
Comments
User_KIM9L
User_KIM9L Rank 3 - Community Apprentice

Organization Name

Johnsons

Description

We have a requirement to show the Adjustment History details for Project Expentiture Item and the table "PJC_EXPEND_ITEM_ADJ_ACTS" which stores the details is not being used any Subject Area.
Also, we require the data stored in "PJF_OBJ_STATUS_CHANGES" TABLE in OTBI report.

It would be very helpful if we can add these and other tables in some Subject Area to fetch the deatils in OTBI report.

Use Case and Business Need

We have a requirement to show the Adjustment History details for Project Expentiture Item and the table "PJC_EXPEND_ITEM_ADJ_ACTS" which stores the details is not being used any Subject Area.
Also, we require the data stored in "PJF_OBJ_STATUS_CHANGES" TABLE in OTBI report.

It would be very helpful if we can add these and other tables in some Subject Area to fetch the deatils in OTBI report.

Original Idea Number: cb62cd57a8

1
1 votes

Submitted · Last Updated