Hi All,
We have a custom OTBI report that in which we want to add some date prompts, Can anyone guide me how to add date prompt from advance sql?
How we refer parameter from advance sql query to OTBI prompts?
Hi Sushant
Please try the below
In the Criteria tab—>Select the required date column—>Click on Filter—>select the check box "Convert this filter to SQL"—>In the Advance SQL text box enter the SQL as per your requirement and save the analysis.
Refer to the given help centre documentation link
https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/edit-filters-columns.html
Agenda Presentation: EPM Integrator connectors and Salesforce CRM Connector. Join us to learn more about the EPM Integrator connectors and Salesforce CRM Connector in Oracle FDI. We will explore the enhanced capabilities of the EPM integrator connectors and how you can load data from EPM modules to FDI to deliver a…
Team, We have a requirement to select below PVOs HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfileItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfilePVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentTypePVO Do we have any documentation around these?
We have a requirement of enabling OTBI report in Purchase Requisition Redwood page similar to classic UI.How can that be done?
Where can I find the calculated time breakdowns in HWM_TM_REC? I am using Oracle BI publisher SQL.
We have a Talent Community Pool configured with Organization and Job Family criteria. Some candidates were added to the pool, but we are unable to determine which specific criterion they matched. Is there a report, analysis subject area, audit history, or backend table that shows the attribute values that resulted in a…
