Popular Tags
- OTBI 1,488
- Reporting 1,413
- FDI 1,223
- Fusion AI Data Platform 1,045
- Analysis and Data Visualization 1,013
- BI Publisher 883
- Analysis 695
- Oracle Fusion Analytics 622
- Administration 558
- OAC 557
- OBIEE 440
- Fusion HCM Analytics 433
- Analytics 433
- Fusion ERP Analytics 424
- BI Publisher Data Models 363
- Security 310
- HCM 292
- BIP 271
- Answers 267
- Oracle Analytics Cloud 261
- Analyses 257
- Developers 248
- Data Modelling and Datasets 235
- Fusion Data Intelligence 222
- ERP Analytics Content 219
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
BI Publisher Data Models
Discussion List
-
1Unable to create more columns in BIP reportsDescription BIP reports are not supporting more than 63 columns through .rft templates Use Case and Business Need BIP reports are not supporting more than 63 columns thr…User_AEMC1 33 views 2 comments 1 point Most recent by User_AEMC1 Oracle Transactional Business Intelligence Idea Lab -
Access Denied for user to path..Summary Access Denied for user to path.. Content Hi, I'm a super user and have high level of security, but in the Report when I select Admin View and look at specific us…AbulKhair 507 views 1 comment 0 points Most recent by Rick Brobbel Oracle Transactional Business Intelligence Forum
-
How to calculate subtotal of sectionSummary trying to get subtotal of section but it includes all data Content Any suggestions on how to get the subtotals added to this report? Example below, want totals f…Michelle Slobig Rotsolk 331 views 1 comment 0 points Most recent by Manoj Madhavan Oracle Transactional Business Intelligence Forum
-
Syntax to converting 24 hour time format to 12 hour format in sqlSummary Syntax to converting 24 hour time format to 12 hour format in sql Content Hi, Anyone know the SQL syntax to convert 24 hour time format(eg. 18:00 for 6:00 PM) to…NIRMAL KUMAR L 1.4K views 1 comment 0 points Most recent by Manoj.Gupta Oracle Transactional Business Intelligence Forum
-
External Data SourcesContent Hi All We are creating a bespoke application to complement Oracle Fusion. This application takes information from Oracle, processes it and then feeds it back int…Aaron Leggett 81 views 2 comments 0 points Most recent by Brett-28437 Oracle Transactional Business Intelligence Forum
-
Extracting Project Team Member Start DatesContent Hello How can I extract the the Person, Project Role and Start Date from OTBI or BI Publisher? I have found several subject areas where some of the information i…Aaron Leggett 11 views 0 comments 0 points Most recent by Aaron Leggett Oracle Transactional Business Intelligence Forum
-
1Fetching resignation reason in which the resignation status is both in approved and not approved staDescription Fetching resignation reason in which the resignation status is both in approved and not approved status Use Case and Business Need Hi All, I tried to create …NIRMAL KUMAR L 2 views 0 comments 1 point Most recent by NIRMAL KUMAR L Oracle Transactional Business Intelligence Idea Lab
-
How to assign BI Administrator role in R12?Summary How to assign BI Administrator role in R12? Content In R11 I was able to assign BI Administrator role in APM. Without this role users are not able to archive/una…Gala Meyerovich 101 views 4 comments 0 points Most recent by Gala Meyerovich Oracle Transactional Business Intelligence Forum
-
Calculate Yesterday date based on CURRENT_DATE variableSummary Calculate Yesterday date based on CURRENT_DATE variable Content Hello, how do I could calcolate obtain yesterday date based on current_date field in an OTBI anal…Giuseppe 1234 322 views 2 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence Forum
-
2Assignment Changes Report - OTBIDescription Assignment Changes Report - OTBI Use Case and Business Need Hi All, We have a requirement to create a report. The columns are mentioned below: 1. Person numb…NIRMAL KUMAR L 31 views 2 comments 2 points Most recent by NIRMAL KUMAR L Oracle Transactional Business Intelligence Idea Lab
-
1Fetching Personal and work email in same OTBI reportDescription Fetching Personal and work email in same OTBI report Use Case and Business Need Hi Experts, How to fetch both personal email and work email in a single OTBI/…NIRMAL KUMAR L 462 views 13 comments 1 point Most recent by RichardChan Oracle Transactional Business Intelligence Idea Lab
-
Audit Report for Bank DetailsSummary Audit Report for Bank Details - Pulls all updates on employees bank details Content how do I create a audit report for employees bank details. This needs to show…Peter Kirwan 41 views 1 comment 1 point Most recent by Ruzwan Akram Oracle Transactional Business Intelligence Forum
-
report on user account details - Role NamesSummary SQL for reporting on employees roles Content Can someone see how to stop the multiple rows from returning in below SQL? select "PER_USERS"."USERNAME" as "USERNAM…Peter Kirwan 233 views 4 comments 0 points Most recent by Ramesh Nakka Oracle Transactional Business Intelligence Forum
-
1Add Competency Goal UDFs as reportable in OBIEEDescription Employee Goal UDFs are already reportable in OBIEE, why not the Competency Goal UDFs ? We use these sepcific fields to extract training needs and comments fr…Support Taleo 1 view 0 comments 1 point Most recent by Support Taleo Oracle Transactional Business Intelligence Idea Lab
-
data Model ReportContent Hi, How to create Promotion data model report based on promotion employees regards, nivaethakrishiveth 31 views 0 comments 0 points Most recent by krishiveth Oracle Transactional Business Intelligence Forum
-
Help with my SQL CodeSummary Help with my SQL Code Content I am trying to create a BIP Report to show Document Payslips pdf uploaded for each employee (with HDL) which covers the Tables like…Ruzwan Akram 121 views 1 comment 0 points Most recent by Ruzwan Akram Oracle Transactional Business Intelligence Forum
-
Using Subject Area for Report: "Unable to retrieve metadata from data model"Summary Attempting to use Subject Area "Payables Payments - Payment History Real Time" in an OBI report which I have used before. Now I get error when I attempt to edit …Wendy Ware 51 views 2 comments 0 points Most recent by Wendy Ware Oracle Transactional Business Intelligence Forum
-
How to stop employees viewing reports in 'Custom'?Content Hi We're having some trouble with report access. We're testing our reports and came across an issue where accounts with just the employee role can run reports co…Aaron Leggett 74 views 2 comments 0 points Most recent by Aaron Leggett Oracle Transactional Business Intelligence Forum
-
1Creating fields that show snapshots of status' at a point in the pastDescription fields that can show a picture snapshot of a very specific time(day) in the past history of the data Use Case and Business Need If you are using a concurrent…Donald Breton 1 view 0 comments 1 point Most recent by Donald Breton Oracle Transactional Business Intelligence Idea Lab
-
Trending reports in Fusion HCMSummary Can we create trending reports in Fusion HCM Content I require to create turnover reports in Fusion HCM with data trending over the period of time. For eg, if I …Amit Shringarpure-21149 31 views 0 comments 0 points Most recent by Amit Shringarpure-21149 Oracle Transactional Business Intelligence Forum