Popular Tags
- OTBI 1,387
- Reporting 1,360
- Analysis and Data Visualization 921
- FDI 921
- BI Publisher 805
- Analysis 658
- Administration 545
- Oracle Fusion Analytics 541
- OBIEE 418
- BI Publisher Data Models 331
- Analytics 323
- OAC 299
- Answers 260
- Security 257
- Analyses 252
- Developers 238
- HCM 230
- BIP 225
- Data Modelling and Datasets 212
- Data Connectivity 205
- ERP Analytics Content 193
- BI Publisher Report Templates 182
- Report Output 181
- Agents 151
- Customizing Reports 145
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
OTBI
Discussion List
-
Why does the table edit page return results but the results page error?Summary: I have created a case when clause in my OTBI report which should return a column of show or group based on the criteria. When I see it in the table edit view, i…Dawn Cawston - CPS 21 views 1 comment 0 points Most recent by Amrita Gupta-Oracle Oracle Transactional Business Intelligence -
R13 21D Financials OTBI database mapping with ViewObjectsSummary: Where can we find R13 21D Financials OTBI database mapping with ViewObjects? Content: Where can we find R13 21D Financials OTBI database mapping with ViewObject…A.JOSH 325 views 7 comments 0 points Most recent by A.JOSH Oracle Transactional Business Intelligence
-
Export OTBI to CSV includes excluded columnsSummary: How do we ensure that OTBI reports exported into CSV, do not include the excluded columns. Content (required): Currently I have a learn report that I have filte…Dawn Cawston - CPS 47 views 1 comment 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
No. of rows in the CSV output file of ESS job in Oracle CloudSummary: Hi, We are seeing the below error in the CSV output file of an ESS job in the Oracle Cloud. Flatten data truncated due to MaxRows=2000000 has been reached. Is t…User_MN9VB 121 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence
-
Issue Combining Multiple SAs - blank fieldsSummary: Issue with combining two SAs: Workforce Management - Worker Assignment Real Time & Recruiting - Recruiting Real Time Trying to put a flex field from Recruiting …Andrew Mc 21 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Oracle Transactional Business Intelligence
-
Performance Tile Filter not producing correct resultsSummary: I am trying to produce a measure for number of maternity cases currently in progress where the visa permit type has not been entered (is null). It produces resu…Mark Stoker 71 views 5 comments 0 points Most recent by Mark Stoker Oracle Transactional Business Intelligence
-
Users are unable to create new Analysis Reports in the Transactional Business Intelligence windowSummary: Content (required): Users are not able to see any option in the "New" tab in Transactional Business Intelligence window to create OTBI reports (Analysis/Data Mo…Dian Minshan 51 views 4 comments 0 points Most recent by Dian Minshan Oracle Transactional Business Intelligence
-
Is there a way to limit OTBI Dashboard Prompt values based on securityHello, Is there a way to limit/restrict the OTBI Dashboard Prompt values based on security / data roles assigned to current user ? We are seeing that the analysis, when …A.JOSH 655 views 8 comments 0 points Most recent by A.JOSH Oracle Transactional Business Intelligence
-
Convert varchar to date datatype in OTBISummary: Hi All, I am looking for To_date function to convert from varchar to date datatype in OTBI but To_date function is not available. Content (required): Is it poss…Surya Anbazhagan 1.1K views 6 comments 0 points Most recent by A.JOSH Oracle Transactional Business Intelligence
-
How to generate Dynamic Password Protected BIP report output?Summary How to generate Dynamic Password Protected BIP report output? Content Hi All, I have written a post on How to generate Dynamic Password Protected BIP report outp…Rajeev Nayan 311 views 1 comment 1 point Most recent by A.JOSH Oracle Transactional Business Intelligence
-
Is there a way to find what reports/anaylsis are set up for Bursting?Summary Is there a way to find what reports/anaylsis are set up for Bursting? Content Hello I need to find out what reports/analysis have been created and set to burst o…Helen Thomas-53877 92 views 6 comments 0 points Most recent by Raghavan p-Oracle Oracle Transactional Business Intelligence
-
Can Available Credit Limit For A Customer be Performed in OTBI?Summary: Can Available Credit Limit For A Customer be Performed in OTBI? Content (required): How can we check Open Credit Limit for a customer account in OTBI Report Do …Stephen Johnson-Oracle 51 views 1 comment 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Help with an OTBI or SQL query to produce a list of all job codes with Grade informationSummary: Hi All, I am hoping someone can help me - I have been struggling with a report request for a while now and I didn't think it was going to be this hard Our busin…PamS 1.9K views 16 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence
-
Does anyone have any suggestions to help me fix this issue?Summary: Dashboard performance issue Content (required):Pivots populate within seconds within the analyses report. However, running through the dashboard it can take up …Donna Fazio 21 views 1 comment 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Briefing Book is not updated if we change the filter condition of AnalysisSummary: I have created a updateble briefing book based on an analysis, later we updated the analysis using filter condition as per requirement, but Briefing Book is not…Shubham Singh 41 views 4 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
How to remove timezone from OTBI PromptHi, I have created OTBI analysis using custom SQL.I have taken the following Subject area Learning Management real Time , Person Real Time , Learning Records real time. …Praveen_Chouhan 604 views 1 comment 0 points Most recent by Pulkit Kumar Jain Oracle Transactional Business Intelligence
-
Approval date not extractedSummary: Content (required): Hello everybody, In editing a report concerning various information about a job requisition. We needed to extract the "Approval Date" of a j…Gerardo Peluso 21 views 1 comment 0 points Most recent by ravikiran goda-Oracle Oracle Transactional Business Intelligence
-
Reports performance issueSummary: Report ending up with exception "oracle.xdo.template.ProcessCancelledException: FOBlock was cancelled after 0 seconds" Content (required): How to improve report…Azfar128 128 views 1 comment 0 points Most recent by ravikiran goda-Oracle Oracle Transactional Business Intelligence
-
Workforce Management - Checklist Real Time doesn't contain Pending WorkersSummary: I need to report on those colleagues who haven't completed a certain checklist task prior to employment which would mean reporting on Pending workers. However a…MattW 31 views 1 comment 0 points Most recent by ravikiran goda-Oracle Oracle Transactional Business Intelligence
-
Changing date format to remove comma - OTBI ReportSummary: Been working on an Absence Calendar for a Dashboard and the prompt for Year dislays as '202,0'. Is there a way to change the format so it displays as '2020'. Co…User_DKPSX 694 views 4 comments 0 points Most recent by User_DKPSX Oracle Transactional Business Intelligence