Popular Tags
- OTBI 1,401
- Reporting 1,365
- FDI 961
- Analysis and Data Visualization 953
- BI Publisher 816
- Analysis 663
- Administration 553
- Oracle Fusion Analytics 543
- OBIEE 421
- Analytics 342
- OAC 336
- BI Publisher Data Models 335
- Security 271
- Answers 261
- Analyses 253
- Developers 240
- HCM 237
- BIP 232
- Data Modelling and Datasets 218
- Data Connectivity 205
- ERP Analytics Content 199
- BI Publisher Report Templates 184
- Report Output 180
- Agents 151
- Customizing Reports 146
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Analyses
Discussion List
-
OTBI Analysis - Getting DFF meaning instead of the valueContent Hi, I am developing an OTBI analysis that deals with several DFF from Oracle HCM Cloud. These DFF have value sets that get values from lookups loaded into the sy…Tmolina-Oracle 485 views 5 comments 0 points Most recent by Yves Chassein Oracle Transactional Business Intelligence -
Which Subject area & folder to use to extract Manager Hierarchy fields (upto level 10) correctly?Summary: 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 144 views 4 comments 0 points Most recent by Abhishek Bagh Oracle Transactional Business Intelligence
-
is it possible to compare Person Number (Colleague) with Manager Person Number (Supervisor)?Summary: Can we compare Person Number with Manager Person Number dynamically (for all records in a report) to analyze if listed Supervisor is actively present in Person …Abhishek Bagh 81 views 4 comments 0 points Most recent by Abhishek Bagh Oracle Transactional Business Intelligence
-
OTBI Dashboard Record Count MismatchHi Team, We have built a dashboard and that has a record count to count the number of rows. We could see the record count shows different numbers for people with differe…Swapnil Kashid 353 views 7 comments 0 points Most recent by Swapnil Kashid Oracle Transactional Business Intelligence -
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 308 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 181 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 220 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 252 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 583 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 251 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 281 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 42 views 2 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence