Popular Tags
- OTBI 1,364
- Reporting 1,352
- Analysis and Data Visualization 898
- FDI 883
- BI Publisher 788
- Analysis 654
- Administration 542
- Oracle Fusion Analytics 535
- OBIEE 415
- BI Publisher Data Models 323
- Analytics 309
- OAC 270
- Answers 259
- Security 253
- Analyses 251
- Developers 234
- HCM 219
- BIP 213
- Data Modelling and Datasets 208
- Data Connectivity 205
- ERP Analytics Content 192
- Report Output 179
- BI Publisher Report Templates 178
- Agents 148
- Customizing Reports 141
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Analyses
Discussion List
-
how to remove HTML markup from columns of an OTBI reportSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Abhishek Bagh 272 views 3 comments 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence -
how to compare Person Number with Manager Number fieldSummary: I would want to apply a condition to know if Colleague is present in Manager Name field or not. How do we compare the Person Number field with Manager Person Nu…Abhishek Bagh 51 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Oracle Transactional Business Intelligence
-
When we creating the otbi report that time showing as UI but some times showing dff nameSummary: Hi Team, when we create the OTBI report that columns shown as as per ui but in some time showing as dff name directly in report. details.docx PFA Thanks, Ajay C…AjayKumar Maddipati 71 views 2 comments 0 points Most recent by AjayKumar Maddipati Oracle Transactional Business Intelligence
-
Pie Chart does not return all itemsSummary: Table results not displayed in Pie Chart Content (required): We have a table that is ranked and everything ranked above 10 is grouped under the reason name 'Oth…Dawn Cawston - CPS 81 views 6 comments 0 points Most recent by Amrita Gupta-Oracle Oracle Transactional Business Intelligence
-
oracle cloud HCM OTBI Dynamic File Name and TitleSummary: Output File naming :-YYYY-MM-DD – [Business Unit] – [Last Name], [First Name} [Incident Event Type] Title: Safety Incident Report for [Incident Number] [Inciden…Surya -Oracle 174 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence
-
OTBI Report with two subject areas that are not connectedSummary: I am trying to build a report that provides information on intercompany invoicing with details of the time entries, comments and costs associated with it. I am …ravinat 213 views 3 comments 0 points Most recent by ravinat Oracle Transactional Business Intelligence
-
How to create a flag field to know if a colleague is a Manager or not in OTBI report directly?Summary: In addition, wanted to understand if there's any in-built field present which can let us know whether listed Supervisor is in Active or Inactive status. If ther…Abhishek Bagh 242 views 6 comments 0 points Most recent by Abhishek Bagh Oracle Transactional Business Intelligence
-
Recruiting: How to create a report to show the list of Offer approversSummary: Hi All, There have been many issues in 22B regarding (Recruiting) Offer approvals getting stuck, or not working the way they should be. It was just recently fix…Jessie Gee 41 views 2 comments 0 points Most recent by Jessie Gee Oracle Transactional Business Intelligence
-
In OTBI report each employee have getting two rows but businees need only one row?Summary: Hi Team, when i set order as per bussiness requiremnt i taken and suppress the columns then when i export into csv or excel and with out usiing formatted option…AjayKumar Maddipati 556 views 6 comments 0 points Most recent by Amrita Gupta-Oracle Oracle Transactional Business Intelligence
-
May I know subject area for talent ratings.Summary: I already taken person profile real time but we unable to find out rating source column from . Talent rating in ZZC to be cleared out.JPG Content (required): Ve…AjayKumar Maddipati 41 views 2 comments 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence
-
OTBI: Getting Error: exceeded configured maximum number of allowed output rowsSummary: Have created an OTBI analysis on "Sourcing: Supplier Awards real time". It has a couple of graphs and tables. But when running for a Negotiation with around 250…Ashu Raj-Oracle 237 views 6 comments 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence
-
Which Subject Area to Use When Generating Personal Information DetailsSummary: We want to generate the personal information details created by different users on the system, but can't find the exact subject area that has those information.…Chukwuemeka Aniukwu 31 views 4 comments 0 points Most recent by Chukwuemeka Aniukwu Oracle Transactional Business Intelligence
-
Employee salary details not able to view through Compensation - Salary Details Real Time Subject AreSummary: We are trying to create a OTBI report for Employee assignment details with Salary details using Compensation - Salary Details Real Time % Assignment Real Time S…Srinivas Sakinala 286 views 3 comments 0 points Most recent by Srinivas Sakinala Oracle Transactional Business Intelligence
-
Absence Leave Amount & Payroll Element NameContent Good Day, We have been tasked to create a report where anyone who has booked less than a full days leave is highlighted. This in its self is very easy and achiev…Clifford-Barrington Trett 71 views 3 comments 0 points Most recent by Peeyush Chandel Oracle Transactional Business Intelligence
-
how to write a condition When a employee get the direct reports for first timeSummary: Content (required): Retrive the data of the first time managers into a OTBI report Example : suppose an employee doesn't have any direct reports on yesterday(27…Satyabrata Nanda 41 views 3 comments 1 point Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
Issues in HC & FTE measuresSummary: Creating an analysis with several subject areas (six) with an incorrect output Content (required): Hello, I am creating a new analysis based on different subjec…Virginia M. Calvi 41 views 2 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
Need to find Proficiency Level in Workforce Performance - Performance Rating Real TimeSummary: We are in the process of implementing Competency Assessments and are building out some reports in our test environment. We were able to find Target Proficiency …Anna Sherwin 11 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence
-
Is there a way to add calculated row in the pivot table (OTBI Analysis)Summary: Is there a way to add calculated row in the pivot table (OTBI Analysis) Content (required): I am trying to create an analysis like below using pivot table funct…Dharmendra Shukla 153 views 4 comments 0 points Most recent by Sahil Makhiza Oracle Transactional Business Intelligence
-
How do we create a role to view OTBI analysis for a user that doesnt have transactional access?Summary: We have users that dont work with AR, but we want them to be able to open OTBI analysis made with AR subject areas. We tried creating a Financials role with the…IIGC 166 views 3 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
How to link Receivables - Customer Real Time and Receivables - Payment Schedules Real Time in OTBISummary: I am wanting to create a report with certain bill-to customer information that is not located within the Receivables - Payment Schedules Real Time subject area,…Georgina Sawyer 41 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Oracle Transactional Business Intelligence