Popular Tags
- OTBI 1,455
- Reporting 1,397
- FDI 1,144
- Analysis and Data Visualization 989
- BI Publisher 865
- Analysis 684
- Oracle Fusion Analytics 597
- Administration 557
- OAC 479
- OBIEE 434
- Analytics 409
- BI Publisher Data Models 359
- Security 297
- HCM 269
- BIP 265
- Answers 265
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Oracle Analytics Cloud 218
- ERP Analytics Content 215
- Data Connectivity 211
- BI Publisher Report Templates 205
- Fusion Data Intelligence 195
- Report Output 184
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
BI Publisher Data Models
Discussion List
-
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 503 views 1 comment 0 points Most recent by Rick Brobbel Oracle Transactional Business Intelligence -
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
-
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
-
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
-
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 91 views 4 comments 0 points Most recent by Gala Meyerovich Oracle Transactional Business Intelligence
-
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 330 views 2 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence
-
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
-
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 232 views 4 comments 0 points Most recent by Ramesh Nakka Oracle Transactional Business Intelligence
-
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
-
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 46 views 2 comments 0 points Most recent by Wendy Ware Oracle Transactional Business Intelligence
-
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 71 views 2 comments 0 points Most recent by Aaron Leggett Oracle Transactional Business Intelligence
-
Using Parent-Child Hierarchy values defined for COA segments in OTBISummary Using Parent-Child Hierarchy values defined for COA segments in OTBI Content We have Parent- child hiearchies for the COA segment values especially for BSV, Natu…GopiKAutomus 201 views 1 comment 0 points Most recent by Arun Raj Oracle Transactional Business Intelligence
-
Excel/Data Model only runs once then I have to close AnalyticsSummary: The help desk was trying to help me with the installation of the BI Publisher Template Builder for Excel and the Oracle ADF 11g Desktop Integration Add-in for E…
-
GET_DURATION function syntax in Release 13Summary We are getting error in Release 13 because of wrong number or types of arguments in call to GET_DURATION' Content We are getting error in Release 13 because of w…Mahesh Ganji-29437 21 views 0 comments 0 points Started by Mahesh Ganji-29437 Oracle Transactional Business Intelligence
-
Dashboard Custom Print and Export design in 12CSummary Any resources that give detailed instructions on how to design a custom print layout? Content Hello, I have stumbled across a 'Custom Print and Export Layouts' f…
-
Is It Possible to Create a BI Report from RSS Feed in Oracle HCM CloudSummary Is It Possible to Create a BI Report from RSS Feed in Oracle HCM Cloud Content Hi Experts, Can we create a BI Report from RSS feed. Any documents/pointers/insigh…AshishERPCloud 31 views 0 comments 0 points Started by AshishERPCloud Oracle Transactional Business Intelligence
-
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 Started by Aaron Leggett Oracle Transactional Business Intelligence
-
data Model ReportContent Hi, How to create Promotion data model report based on promotion employees regards, nivaethakrishiveth 31 views 0 comments 0 points Started by krishiveth Oracle Transactional Business Intelligence
-
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 Started by Amit Shringarpure-21149 Oracle Transactional Business Intelligence