Dear Expert,
Could you please confirm how to get the access for Oracle BI EE access. for it's not coming in Drop down.
Thank you!
Please refer the following post
@jsmithA , Hope you got a chance to look at the above answer. If you are still having issues, please feel free to update the post. Thanks
Hi @jsmithA,
Please find below some more explanation which might be useful for the better understanding.
In Oracle Fusion BI Publisher, an Oracle BI EE (OBIEE) data source connects your reports to the underlying data model, often pulling from Subject Areas defined in OTBI, allowing you to leverage existing analytics (like Analyses/Answers) as a data source for BIP reports, simplifying data retrieval by using predefined logic instead of direct SQL, and managing access through BI Publisher's Administration pages. You define these connections via JDBC/JNDI in the Admin console and then select the OTBI analysis or subject area within the BIP Data Model editor to fetch data for your layouts.
Please note: we can't access the fusion database tables using Oracle BI EE data source.
If your requirement is to execute a direct query on a Fusion Database table, need to use the appropriate data source. For ERP, use 'ApplicationDB_FSCM'. Similarly for other modules accordingly.
Hope this help.
Thank you.
Additionally, if you are looking for more info regarding 'Integration of Oracle BI EE with Oracle BI Publisher', please take a look into the following Oracle Document:
https://docs.oracle.com/middleware/12211/biee/BIEUG/GUID-A20301E2-3B22-4284-90FB-2AF861E2E9CD.htm#BIEUG2774
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?
