Hi Team,
How do we add a new column in the OTBI subject area not present in the existing model?
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.
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
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.
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
Thanks Dimple. But can you share a document which shows step by step guide to create a custom subject area in Fusion SaaS.?
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
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.
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
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.
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.
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"
Is there a log that can be checked on our side that might help with the issue. I've submitted an SR, however it is currently being bounced around between different areas. Could not establish connection. oracle.xdo.delivery.ssh2.SSHMessageException: Error in decrypting message Current thought is that this is an issue with…
Hello, I'm trying my hand at creating some KPI's and Dashboard Visualizations for the Recruiting Activity Center (RAC) per the following documentation: Flexible Reporting in Redwood Dashboards Redwood Experience: Recruiting Dashboard When I add a session variable to my OTBI reports, I correctly see a value of 0 in my…
'Facility Name' exists in the Recruiting - Recruiting Real Time multiple times with varying usage. Job Requistion -> Job Requisition - Additional Details -> Facility Name Job Requistion -> Location -> Facility Name Is there any reason why these two Facility Names would not exist in the Recruiting - Real Time Events subject…
We are encountering issues with our OTBI dashboards where there is no option to export to Excel. This seems to be a new issue after the latest update to 26B. I made a change to the report layout (moved one analysis into its own section), and now I cannot export the page. As you can see in my attached photos, the export…
we have a requirement to fetch Worker Historic information like Current Job Title Previous Job Title Previous Department New Department Previous Manager New Manager Previous Location New Location which subject area stores this information in the OTBI?
