Welcome to the Oracle Analytics Community

Popular Tags
- OTBI 1,000
- Reporting 858
- Analysis and Data Visualization 671
- Analysis 583
- BI Publisher 538
- Administration 487
- reports 297
- obiee 288
- Oracle Fusion Analytics 287
- FAW 271
- Analyses 240
- BI Publisher Data Models 226
- Developers 220
- Data Connectivity 185
- Data Modelling and Datasets 164
- OBI Answers 153
- security 151
- Report Output 135
- Agents 134
- Packaging and Licensing 124
- Home and Catalog 117
- HCM 115
- ERP Analytics Content 114
- Access and Manage Data 107
- OBIEE Answers 105
Core HR
Discussion List
-
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 12 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 8 views 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 8 views 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 1 view 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 21 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 144 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 31 views 1 comment 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
How to query fusion tables in SQL developerSummary: We have a data model to select the email_address_id from fusion.PER_EMAIL_ADDRESSES but we want to be able to query this table or data from this table (or IRC_C…maria.stanciu 417 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle 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 121 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 45 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 462 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 213 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 111 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 80 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 85 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 65 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 98 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 31 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 62 views 3 comments 0 points Most recent by Peeyush Chandel Oracle Transactional Business Intelligence
-
OTBI CertificationSummary: OTBI Certification Content (required): Since last year we have been using HCM.I have been trying to create some reports in OTBI, however, I see that I need to l…KMore 283 views 5 comments 0 points Most recent by Shashank Verma-Oracle Oracle Transactional Business Intelligence
-
Is there any possibility to get latest job change date in OTBI ReportHi Experts, Good Day!! Can someone please let me know how to get the latest job change date in OTBI Report For Example, one employee Job changed from "AA" to "BB" on 01-…Divya Kollipara 25 views 1 comment 0 points Most recent by Dave.Lazier-Oracle Oracle Transactional Business Intelligence
-
OTBI Report running into error when I add Sum on a column-Sort has no work space in the work directoSummary OTBI Report running into error when I add Sum on a column-Sort has no work space in the work directory. Content Hi, I have an OTBI Report running into error when…Aloka Bhattacharya 86 views 5 comments 0 points Most recent by Amrita Gupta-Oracle 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 41 views 1 comment 0 points Most recent by Bhaskar Konar 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 28 views 1 comment 0 points Most recent by ravikiran goda-Oracle Oracle Transactional Business Intelligence
-
OTBI: Diff of Two dates to get Age is rounded to next highest valueSummary OTBI: Diff of Two dates to get Age is rounded to next highest value Content OTBI: Diff of Two dates to get Age is rounded to next highest value Example: If diffe…Srinivas Challa 264 views 3 comments 0 points Most recent by Matthias Ludewig Oracle Transactional Business Intelligence
-
BI publisher report how can we change the sender display of the email notification?Summary BI publisher report how can we change the sender display of the email notification? Content Hello , We would like in BI Publisher reports to have the ‘FROM’ , th…Revital Mefano 149 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Oracle Transactional Business Intelligence
-
Report on BIP Catalog Folders detailsSummary Report on BIP Catalog Folders details like Roles and Permission etc. Content Dear Team, How to report on BIP Catalog Folders details like Roles and Permission et…Karthik_ks 141 views 9 comments 0 points Most recent by Alok Suraj-Oracle Oracle Transactional Business Intelligence
-
Audit on Data Models in BISummary Need Audit on data models Content Hi Experts, Could any one let me know how to get audit on data models in BI Publisher in Oracle Fusion. Thanks in Advance.Charan Kollipara 71 views 4 comments 0 points Most recent by Robert Fighiroae-Oracle Oracle Transactional Business Intelligence
-
How can I export a list of all active reports we have HCM?Summary I need to have a list of all our reports in HCM BIP (and/or)OTBI Content How can I found out how many reports there are in use at the sys? Who created them, acti…Orit Dekel 66 views 5 comments 0 points Most recent by Christian Berg Oracle Transactional Business Intelligence
-
Filter for terminations in prior calendar weekSummary I'm creating a termination report and trying to show which terminations were in the calendar week (Sunday-Saturday) prior from the week when the report was run C…Karen B 53 views 3 comments 0 points Most recent by Lavanya Reddy Oracle Transactional Business Intelligence