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…

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…

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 :…

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…

HI Looks like this is a data conversion issue. Check the column date how the data format is stored in the database table/column accordingly build the SQL in that format and validate the results

Hi Please try to use Sum(Required Quantity) group by Item name https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/edit-formulas-or-calculated-measures.html#GUID-56B8E03F-E6A6-4421-AD81-DDD72B5D68F4

Hi Amel Ahmed Please login into BI Application with BI Admin user—>Navigate to catalog shared folder and search for the Agent from where this email is invoked. Once you find the Agent details. Click on More—>Disable the Agent

Hi Wendy Please review the HCM OTBI subject area lineage mapping details HCMhttps://community.oracle.com/customerconnect/discussion/40249/hcm-otbi-subject-areas-to-database-lineage-mapping-spreadsheet/p1 Filter the data based on the subject area name and identify the Database objects. Job Application - Electronic…