Popular Tags
- OTBI 1,380
- Reporting 1,355
- Analysis and Data Visualization 917
- FDI 917
- BI Publisher 803
- Analysis 657
- Administration 544
- Oracle Fusion Analytics 539
- OBIEE 418
- BI Publisher Data Models 331
- Analytics 320
- OAC 293
- Answers 260
- Security 257
- Analyses 252
- Developers 235
- HCM 229
- BIP 224
- Data Modelling and Datasets 212
- Data Connectivity 204
- ERP Analytics Content 193
- BI Publisher Report Templates 181
- Report Output 179
- Agents 149
- Customizing Reports 143
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Core HR
Discussion List
-
Which FAW table stores indirect Reportees data?I am looking for a table/column in FAW that stores the data for indirect reportees of a manager. dwc_manager_dn_dh_tbl table stores the data for direct reportees only (i…Dinky Dudeja 61 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Oracle Fusion Data Intelligence -
Usage of PVOs GLOBALPERSONPVOVIEWALL and PERSONDETAILSPVOVIEWALLWe are building a BICC extract to extract person and their assignment data, wanted to understand when should we use GLOBALPERSONPVOVIEWALL and PERSONDETAILSPVOVIEWALSR_CC 41 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence -
1How to update the service date field with a new custom name in the format of the date.Hi, How to set up a new custom field name in the service date area using the date format. Please find the reference image Thanks in advance Regards Bhargav PrasadBhargav Prasad 11 views 0 comments 1 point Started by Bhargav Prasad Oracle Analytics Cloud and Server Idea Lab
-
Calculated Field in OTBI PromptSummary: Wish to have Calculated field in OTBI prompt. I want to have 3 prompts based on the given table data below: Assignment Last Update Date Grade Change Flag Grade …Pradnya_Pampatwar 1 view 0 comments 0 points Started by Pradnya_Pampatwar Oracle Transactional Business Intelligence
-
1To have different person number sequence as per legal entities.Below is list of legal entity and their sequence of person number requirement that should be followed automatically when employee is hired into that Legal entity LE1: 52…Darshan12345 1 view 0 comments 1 point Started by Darshan12345 Oracle Analytics Cloud and Server Idea Lab
-
2Journey Task search can be added with Sort By option on Journey TaskDescription : Journey Task on search can be added with Sort By option on Journey Task Use case and Business Need : When Performers using Journey and want to search Task,…User_XUB7Q 12 views 0 comments 2 points Started by User_XUB7Q Oracle Analytics Cloud and Server Idea Lab -
Open a Drill Down report in same page in DashboardHi Team, We are using a dashboard for performance documents in Oracle Fusion OTBI. Within this dashboard, there is an attached analysis featuring a Pie chart that displa…User_46FMZ 166 views 1 comment 0 points Most recent by Rich Merkel Oracle Transactional Business Intelligence
-
Report for vacant positions and open job requisitionsSummary: Hi, I was wondering if anyone has a report that shows active vacant positions with active open job requisitions? We are looking to pull: * Active position curre…Eva Elks Herrmannsen 339 views 1 comment 0 points Most recent by KatieH Oracle Transactional Business Intelligence
-
In BI Report we getting dupicate recordsHI Team, we have exist interview status report but few days onwords we getting dupliacte reocrds nearly 700plus. how can shorted out the issue ? Thanks, AjayAjayKumar Maddipati 182 views 1 comment 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
we have developed new OTBI report but when we Export analysis issue is occuringSummary: Hi Team, when we Export analysis > data > excel we get each row have person number, name some columns coming each row. and we export another way like Export ana…AjayKumar Maddipati 172 views 5 comments 0 points Most recent by Amrita Gupta-Oracle Oracle Transactional Business Intelligence
-
Any one help Skills ReportSummary: Hi Team, we need skills report in Bi or OTBI Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets…AjayKumar Maddipati 41 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence
-
how to put a Countif in a unique field in an OTBI reportSummary: In my report, I have Person Number field which is unique, however the report has some duplicate entries. I only need to understand how do I get a count to see h…Abhishek Bagh 1.2K views 8 comments 0 points Most recent by Amrita Gupta-Oracle Oracle Transactional Business Intelligence
-
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 472 views 5 comments 0 points Most recent by Yves Chassein Oracle Transactional Business Intelligence
-
when i taken manger number and name from manager folder then company level coming mulitiple numberSummary: Hi Team, when i taken manger number and name from manager folder then company level coming mulitiple numbers for each mangers . How can i rectify the issue. PFA…AjayKumar Maddipati 131 views 7 comments 0 points Most recent by AjayKumar Maddipati 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 141 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
-
when I using matrix manger columns list I'm unable to find Top manger type mail IdSummary: Hi Team, I'm using worker assignemnet real time subject area in that we need to fecth the performnace manger name , number and email so we are filetr out from t…AjayKumar Maddipati 61 views 4 comments 0 points Most recent by Julian Challenger-Oracle 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 42 views 2 comments 0 points Most recent by Jessie Gee 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