How to add a new columns in OTBI subject area?

Hello123

Hi Team,

How do we add a new column in the OTBI subject area not present in the existing model?

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/61606#Comment_61606

Currently, it is system limitation. If any of the base table attribute is not available, you can create an idea to bring it in the subject area. Only solution is to create a BIP report in this case.

You can create multiple SA reports with conditions. Please check below document for details on cross subject area report pre-requisites.

Fusion Applications OTBI: Guidelines for creating cross subject area analyses in Oracle Transactional BI (Doc ID 1567672.1)

Thanks.

Dimple-Nagesh-Support-Oracle

Hello @Hello123,

Are you talking about custom fields created in UI, in that case you can find them under Object Dimension.Extension Folders.
For eg: Custom Fields from Account, are available under Account → Account Extension Folders.

But if you want to edit the existing report and add new columns, then locate the reporth path → edit the report → click on criteria Tab → Now add the required fields → Save the report → Test the flow .

Let me know the results.

Thanks,
Dimple N

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/24003/how-to-add-a-new-columns-in-otbi-subject-area

If you are talking about Fusion SaaS subject areas, you can't really add any new columns in that. Oracle delivers the columns in a subject area. Only possibility is to have DFF attributes. Once you create a DFF, you can run a process and it will appear in subject area.

Thanks.

Dimple-Nagesh-Support-Oracle

Correct Mandeep,

You can also review on how to create Custom Subject Area to report on Custom Object and its attributes, here is the document on BEST Practices :

Oracle Engagement Cloud (Sales and Service): Best Practices for BI Extensibility and Using Custom Subject Areas (Doc ID 2348001.1)
Also here is doc shows what fields are available for reporting from application : Oracle Sales Cloud Analytics: What Are Available Fields In BI Answers Subject Area (Object Extensions) ? (Doc ID 1507843.1)

Though it is mentioned as Sales and Service, its common across application.

Kindly go through them, review and update me if that helps.

Thanks,
Dimple N

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/61599#Comment_61599

Thanks Dimple. But can you share a document which shows step by step guide to create a custom subject area in Fusion SaaS.?

Thanks.

Dimple-Nagesh-Support-Oracle

Hey Mandeep,

Sure, please review this step-by-step guide with screenshots on How to create Custom Subject Area with worked examples on below :
1. Creating and Viewing a Report for the Custom Subject Area
2. Creating Custom Fields for a Standard Object: Explained
3. Adding Custom Fields Using CRM Application Composer
4. Reporting on the Created Custom Fields
5.Extensibility and Reporting : Example
6. Creating Custom Subject Area and reporting

https://docs.oracle.com/cd/E36909_01/fusionapps.1111/e20388/F1071036AN20A30.htm

Hope this helps.

Thanks,
Dimple N

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/61601#Comment_61601

Thanks Dimple. I have gone through the documentation and only CRM/ERP/SCM are supported and HCM is not supported. But again, it doesn't help on adding a new column in existing SA instead of creating a completely custom SA.

Thanks.

Dimple-Nagesh-Support-Oracle

Hi Mandeep,

Did you try editing the existing CSA and adding the column from Application composer ?
What type of columns did you try adding ? and can you share the steps taken to publish?
Was the column not available after the CSA published with Ok Status? Does the republish the CSA fails ? or what is the exact issue faced?
And you are able to view the column in SUI ?

Also you can provide the username of the user trying to publish the CSA, exact date and time, name of the CSA to check further.
I recommend to raise a Service Request with us with these details.

Thanks,
Dimple N

Hello123

Let me explain in detail.

In this subject area "Workforce Management - Checklist Real Time" I need to add one column from "per_allocated_tasks.completion_date".
Some of the columns already available in the subject area are related to this "per_allocated_tasks". table.

What is the process I need to follow to bring that additional column into this subject area? I need a detailed step-by-step process.

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/61604#Comment_61604

Hi,

As mentioned in my earlier post, it is not possible to extend the seeded subject area. You can't bring any additional columns from base tables into this SA.

Thanks.

Hello123

https://community.oracle.com/products/oracleanalytics/discussion/comment/61605#Comment_61605

Actual End date and completion Date data do not match the data. this is just given an example. How can I fulfill user requirements when any additional attributes are present in the fusion tables?

Is it possible to bring the columns from one subject area to another subject area like HR Action Name and Action Reason from the

"Workforce Management - Worker Assignment Event Real time" to

"Workforce Management - Work Relationship Real time"