Hi Please review the OTBI help center documentation link https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/25b/faosm/Costing-New-COGS-and-Gross-Margin-Details-Real-Tim-SA-447.html Also, Please review the OTBI subject area lineage Mapping details and identify the database tables/columns To know the OTBI…

Hi Please review the given help center documentation link and review OTBI Audit. Doc ID 2731495.1 : Fusion Applications OTBI: How To Configure And Use Audit For Usage and Performance In OTBI For Fusion SaaS Cloud Customers or KB5355 Fusion Applications OTBI: How To Configure And Use Audit For Usage and Performance In OTBI…

Hi Swapna Can you please Navigate to catalog shared folder of the Dashboard—>Expand Dashboard—>Click on Page—>Click on More option —>Click on Properties—>Take ownership of Items and Sub-Items and click ok Also, Edit the Dashboard—>Click on Dashboard Properties—>Click on Permissions and verify roles attached.

Please create analysis using single subject area column after that add one by one column from second subject area and identify by adding which column duplicate data appears Also, Please review the given OTBI help center documentation link and ensure to include recommended column…

Hi Please create analysis using single subject area column after that add one by one column from second subject area and identify by adding which column duplicate data appears Also, Please review the given OTBI help center documentation link and ensure to include recommended column…

Hi Please review the OTBI help center documentation link and ensure to include required column as specified in Time Reporting section. https://docs.oracle.com/en/cloud/saas/human-resources/24d/faohb/Workforce-Goals--Goal-Alignments-Real-Time-SA-44.html#Description

Hi Please review the details in the given CCC post https://community.oracle.com/customerconnect/discussion/875663/bi-report-multiple-filters-return-no-results-but-when-filters-used-individually-returns-records

Hi Please check the CCC posts https://community.oracle.com/products/oracleanalytics/discussion/26127/can-we-have-one-single-report-which-gives-oda-and-hrhd-analytics-together-in-otbi

Hi Please Edit the analysis—>click on Column Properties of the Measure column—>Click on Data tab—> In the Drop down choose Percentage option and verify the results Also, Please review the help and existing CCC post https://forums.oracle.com/ords/apexds/post/obiee-answers-analysis-with-only-the-grand-totals-2593

Hi create an OTBI analysis or BI Publisher report, include the relevant position and profile data fields, and then export the analysis or report output in a suitable format like Excel, CSV, or PDF. The "Export" feature allows you to choose the output format and download the data

Hi Please log a Service Request. Review the doc "Fusion OTBI - Add Alias Name For Agent Sender Email (Doc ID 2371364.1

Hi Please Edit the analysis column—>Click on Column Properties—>click on Data format—>Choose the Percentage in the drop down and verify the results. Also, Please review the given links and existing CCC posts https://community.oracle.com/products/oracleanalytics/discussion/4154/how-to-create-percent-of-total-in-obiee

Hi Please try to use the cast() function as below Sample Query =========== select cast(result_value as integer) from PAY_RUN_RESULT_VALUES For any further information, Please follow up your query in this post https://community.oracle.com/products/oracleanalytics/categories/otbi

Hi Elena Please review the given help center documentation link and follow the recommendations. https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-design/extended-sql-and-xsl-functions.html#GUID-B39D756A-C54D-4C64-A822-DD2CFFC3A54E

Hi Elena Please review the given help center documentation link and follow the recommendations. https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-design/extended-sql-and-xsl-functions.html#GUID-B39D756A-C54D-4C64-A822-DD2CFFC3A54E

Hi Khalid, Please review the OTBI subject area help center documentation and check the "Time Reporting" section and include the recommend https://docs.oracle.com/en/cloud/saas/procurement/24d/faopb/Supplier-Registration--Supplier-Registration-Real--SA-19.html#Description In the OTBI analysis count of "Supplier Registration…

Hi Please review help center documentation about Briefing book https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/organize-dashboard-pages-briefing-books.html#GUID-4BFD2B52-1B50-4F00-BA63-B554787EFE0E Please check to download the briefing book in MHTML format, click Web Archive (.mht) and open or save the file.Downloaded…

Hi Narendar Please review the given documentation about Sessions variables https://docs.oracle.com/middleware/12211/biee/BIEMG/GUID-42B5091C-F8B4-4E68-95D9-114594F496E9.htm

Hi There is no One-to-One mapping available as Fusion Architecture and Database Entity Relationships are different from that of EBS. However, there are more similarities in table names between Fusion and EBS. You may refer the following links for Fusion Table structures and EBS Table Structures Fusion : EBS :

Hi Amel Please review the given help center documentation link https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/send-email-reports-and-track-deliveries.html#GUID-C5815E71-9348-4C13-BAB6-B5B0C887B3D6 Note: Login with BI Administrator—>Navigate to catalog—>On the left side change the User View to Admin View—>Expand…