Hi Please review the given OTBI LIneage mapping documentation link details.https://community.oracle.com HCM ===== https://community.oracle.com/customerconnect/discussion/40249/hcm-otbi-subject-areas-to-database-lineage-mapping-spreadsheet/p1 SCM ====…

Hi Menna Allah Please use "customize" option before making any customization on the seeded report/template. Also ensure to keep all custom contents inside /shared/custom folder. Refer to the given documentation Fusion Applications BI Publisher : How Should We Create New BI Publisher Reports or Customize Existing Seeded BI…

Hi Rojhat Sinan Balka Can you please try the below Login into BI application with BI Admin user—>Navigate to catalog shared folder of the OTBI analysis report—>Click on Edit—>Click on Criteria—>Navigate to catalog column(Item Description)—>Click on Properties—>Click on column format tab—>select Suppress option and click ok…

Hi Please review the given help centre documentation links and do the security setup as per your requirement https://docs.oracle.com/en/cloud/saas/human-resources/23d/ochus/business-intelligence-roles.html#s20044632 How to Add the BI Administrator Role to a user in Release 12. (Doc ID 2238277.1)

Hi Anjan Please review the help center documentation about TIMESTAMPADD https://docs.oracle.com/en/cloud/saas/taleo-enterprise/22a/otbou/c-datetimefunctions.html#id20131114135318992

Hi Patrick Please review the given documentation it might be helpful https://docs.oracle.com/en/cloud/saas/otbi/otbi-admin/localize-catalog-captions.html#GUID-963B460D-51B2-4292-9522-A3AA3908F42E

Hi Bursting will split the data based on the split by Key hence output file contains only the data fetched as per the split key value not the parameter value.

Hi Patrick Please review the given help center documentation link about BIP Translation. https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-design/what-can-i-translate-publisher.html#GUID-9959B5D5-3350-41D9-8580-11178228FDEB

HI Please review the given documentation link about the Pivot table in OTBI https://docs.oracle.com/cd/E12096_01/books/AnyUser/PivotView.html

Hi Please review the given help center documentation link about Null values in Views https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/suppress-null-values-views.html Also, To try hide the column please try the below Edit the Pivot table view—>Click on Column Properties—>Hide the column as per your requirement.

Hi Thank you for the details. Please try the below for group by clause Example:sum("Procurement - Purchasing Real Time"."Purchase Order Header Detail"."Purchase Order Amount" BY "Procurement - Purchasing Real Time"."Supplier Profile"."Supplier Name")

Hi Please provide us the below details for our review a) catalog using the archive option b) NQSQuery.log of the report. Follow the below steps Doc ID 2225909.1 Fusion Applications: How to Get nqquery Using Manage Session

Hi Dharma Database timezone in UTC hence data is filtering in UTC format. Database timezone cannot be changed. Thanks & Regards Rajasekhar

Hi Dharma Database timezone in UTC hence data is filtering in UTC format. Database timezone cannot be changed. Thanks & Regards Rajasekhar

Hi Dharma Database timezone in UTC hence data is filtering in UTC format. Database timezone cannot be changed. Thanks & Regards Rajasekhar

Hi Please review the given cross-subject area guidelines. https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/combine-subject-areas-analyses.html#GUID-8B9DF9B1-20E3-4F88-8EEE-0714EF6E2F63 When the report build with more than one subject areas, things to consider You should have a common dimension in all the subject areas…

Hi David From NQSQuery.log, Please review the physical Query generated for the Prompt and review the logic used.

Hi David Glad to know the issue is resolved. Thanks & Regards Rajasekhar

Hi Upload a screenshot with detailed navigation steps that shows the details.

Hi Sandhya Please add ESS Administrator & ESS Monitor roles to the user. After that Run the ESS Scheduled process: Import User and Role Application Security Data" to reflect the changes. Then logout and re-login and validate the results.