Popular Tags
- Reporting 1,296
- OTBI 1,212
- Analysis and Data Visualization 800
- BI Publisher 677
- FDI 654
- Analysis 623
- Administration 502
- Oracle Fusion Analytics 463
- OBIEE 390
- BI Publisher Data Models 283
- Answers 253
- Analyses 247
- Developers 230
- Data Connectivity 196
- Security 194
- Analytics 192
- Data Modelling and Datasets 186
- HCM 184
- Report Output 164
- ERP Analytics Content 155
- Agents 145
- BIP 142
- BI Publisher Report Templates 137
- Packaging and Licensing 128
- Home and Catalog 122
OTBI
Discussion List
-
recruiting - recruiting real time Candidate AttachementHi Experts, I'm trying to fetch candidate attachment files/URLs by using this recruiting - recruiting real time OTBI. Unfortunately, I can't see any attachment files or …Saher 11 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence -
ORA-00939: too many arguments for function error when used substr in SQL Query in DataModelHi, I have created a DataModel using below query : select HZP.PARTY_NAME, HZP.PARTY_NUMBER from HZ_PARTIES HZP where 1=1 AND HZP.PARTY_NAME IN (substr(:P_STRING1,:P_STAR…Shashidhar Goud 54 views 7 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
how to stop send otbi report in emailHi, I Send OTBI Report In email and choose repeat to be daily. I receive the report in email successfully now i want to stop the daily email .Amel_Ahmed_AHG 21 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Oracle Transactional Business Intelligence
-
How to ensure the relevant BU Data Access for OTBI reports?Hello, I assigned the Employee role to a user in order to give access to the reports in Reports and Analytics tab. However, when the user runs the report, all data from …Sinem Ozmen -Oracle 532 views 9 comments 0 points Most recent by Arya Rajan Oracle Transactional Business Intelligence
-
Can you convert field [Recruiting-Recruiting Real Time] from Date to Date & Time in OTBI?We would like the time associated with the job application in the field 'Job Application - Electronic Signature' Can I convert this field to date & time instead? If so, …Wendy G 22 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
3Query or report on ESS request scheduling informationDescription Database views FUSION.ESS_REQUEST_HISTORY as well FUSION.ESS_REQUEST_PROPERTY do not seem to include actual request scheduling information (eg every 2 hours)…
-
OTBI skills proficiency levelHi all, We need to take the gap between the Proficency Rating and the Required Proficency Level for the employees. We are looking for this fields in the OTBI: We are usi…User_DA2EL 33 views 2 comments 0 points Most recent by User_DA2EL Oracle Transactional Business Intelligence
-
Element Entries transpose rows to columnsHello Folks, We are trying to create a OTBI report to show element entry values for multiple input values in a single row. The input values need to be represented as a c…
-
Ago Function not displaying data for Prior Year PeriodsHi, We have created a AGO function in FDI semantic layer using it in OAC Classic view(OTBI). with Fiscal Period as Column Prompt. On selecting Jan-24 as Fiscal Period, C…
-
How to get the correct last update date in the "Workforce Health and Safety Incidents" module?Good morning, some analysis have been developed on the subject area "Environment Health and Safety - Incidents Real Time" to extract the information in delta to feed the…AM HRE 61 views 1 comment 0 points Most recent by Mihaela Predincea-Oracle Oracle Transactional Business Intelligence
-
1OTBI analyses on shipping Real Time Subject Area does not display correct Fulfillment lineFor split lines Fulfillment details are not cauputed correctly. Currently only Shipment lines are captured based on the Shipment Id. On the SR raised SR 3-36563504801, I…
-
oracle fusion pre built BIP reports how to check source of data Modleoracle fusion pre built BIP reports how to check source of data Modle For example : Pre built reports for manufacturing module : Shared Folders/Manufacturing/work Defini…Indra Sardana-Oracle 12 views 3 comments 0 points Most recent by Mihaela Predincea-Oracle Oracle Transactional Business Intelligence
-
How to merge rows if their 2 columns are the same in OTBI Analysis?Hello, I have an analysis where I'd like to merge multiple rows if they share the same value for "Item Description" and "Unit Price". Example: | Item Description | Unit …Rojhat Sinan Balka 54 views 2 comments 0 points Most recent by Rojhat Sinan Balka Oracle Transactional Business Intelligence
-
2How to paste shortcut in OTBI?When trying to paste a shortcut to a report in My Folder, the error Path not found populated. We have the option, and can, create a shortcut to a report in the folder th…
-
Issue with OTBI Subject areasI am trying to add one more subject area to the 'Workforce Career Development - Development Goal Overview Real Time'. I didn't find any proper fact column related to 'Wo…Sai Krishna Chelikani 21 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Oracle Transactional Business Intelligence
-
8OTBI Reports Cannot Be Restricted by Data AccessOrganization Name Prospect Medial Group Description OTBI reports do not take into account data access when displaying results. We need data security to extend into OTBI …
-
How to get list of reports who are using Learning Managerment Real Time subject area.As oracle has replaced Learning Management Real Time subject area with Learning Records Real Time subject area and in future release Learning Management Real Time subjec…Sohel.IN-Oracle 90 views 9 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Rows repeating with different values though it's not available in the Front end under Customer SiteHi, We have developed an OTBI report using Receivables - Customer Real Time and Receivables - Customer Account Site Tax Profile Real Time and it is repeating a single si…Rahul Kumar Gupta.-Oracle 11 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence
-
Displaying the Receipt Date for the Purchase Order in PO Details ReportSummary Displaying the Receipt Date for the Purchase Order in PO Details Report Content Hi , I have PO Details Report with the following fields. PO Number, PO Date, PO S…Dharmendra Jha-160968 1.4K views 12 comments 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence
-
Grouping Columns based on Data like MTD,QTD,YTD in OAC/OTBIHello, We have a requirement to display Data based on the Time Series to group MTD Data Columns under MTD Group Column in OAC/OTBI We can display data by placing columns…