Popular Tags
- OTBI 1,446
- Reporting 1,392
- FDI 1,116
- Analysis and Data Visualization 986
- BI Publisher 854
- Analysis 682
- Oracle Fusion Analytics 585
- Administration 555
- OAC 449
- OBIEE 433
- Analytics 399
- BI Publisher Data Models 356
- Security 293
- HCM 266
- Answers 264
- BIP 263
- Analyses 255
- Developers 245
- Data Modelling and Datasets 228
- Data Connectivity 210
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 192
- Report Output 184
- Fusion Data Intelligence 179
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Customizing Reports
Discussion List
-
Syntax to fetch pending transfer details from Data_cache column in hrc_txn_dataSummary Syntax to fetch pending transfer details from Data_cache column in hrc_txn_data Content Hi, We need to fetch the pending transaction Transfer details like New Lo…NIRMAL KUMAR L 52 views 1 comment 0 points Most recent by User_OWH0W Oracle Transactional Business Intelligence -
List of OTBI inefficient ReportsSummary looking for was to monitor OTBI reports performance and Frequency of use Content Hi All, I am looking for ways to monitor the performance of OTBI Reports in fuss…Fongang 72 views 6 comments 0 points Most recent by AshishERPCloud Oracle Transactional Business Intelligence
-
Referencing Parameters in the Layout Editor FilterSummary Referencing Parameters in the Layout Editor Filter Content Hi, What is the syntax we should use to reference a parameter in the Layout Editor Filter? BR Hany
-
Deferred Termination field in OTBISummary looking on how to determine a deferred termination Content Hello, I have been asked to create a report showing the associates with a deferred termination. When t…Kevin Lee Choon 51 views 3 comments 0 points Most recent by prjohnson Oracle Transactional Business Intelligence
-
The tool 'OracleBIOffice.exe' is not available after R12 upgradeSummary The tool 'OracleBIOffice.exe' is not available after R12 upgrade Content We are not able to install OracleBIOffice.exe tool after R12 upgrade from the EPM Worksp…User_AEMC1 21 views 2 comments 0 points Most recent by Enzo Urbinati Oracle Transactional Business Intelligence
-
Get privilege to issue logical SQL in OTBISummary As a developer i need to "Issue SQL" /analytics/saw.dll?issuerawsql to query using logical sql metadata repository database (rpd) with log level 2 then view log …Nathan CCC 181 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence -
Audit History to access changes made in BIP Data ModelSummary Require table or methods to find out changes done in BIP Data Model Content Hi, We have encountered an issue recently where the data model query were updated by …Samrat Chattapadhyay 545 views 2 comments 0 points Most recent by Joel Acha11111 Oracle Transactional Business Intelligence
-
How to get and SQL for our own OTBI AnalysisSummary SQL for OTBI Analysis Content Hi All, How to get and SQL for our own OTBI Analysis.I know we can get this in the advanced tab but there we cannot see the sub que…Praveen Kumar-146357 93 views 3 comments 0 points Most recent by [Deleted User] Oracle Transactional Business Intelligence
-
Formula to capture last 7 days of dataSummary Formula to capture last 7 days of data Content Hello, We are looking to capture requisition in specific statuses (Approved, To Be Approved, Draft, Sourcing and F…Nicole Hicks 385 views 7 comments 0 points Most recent by Arun Raj Oracle Transactional Business Intelligence
-
Oracle Fusion OTBI Direct Database Query/ReportSummary Querying Oracle Fusion OTBI feature is being deprecated for CLOUD environment from 19A releases Content Creating Reports with Direct Database Query in Oracle Fus…Senthilrajan V 401 views 9 comments 0 points Most recent by Senthilrajan V Oracle Transactional Business Intelligence
-
OTBI Variable Presentation Date Prompt Format DD-MON-YYYYSummary Users need to be able to enter a date in DD-MON-YYYY format at the prompt Content Our date format changed to dd-MON-yyyy (15-MAY-2017), but the only way the repo…Brenda Jacks-49721 282 views 1 comment 0 points Most recent by RichardChan Oracle Transactional Business Intelligence
-
Reporting on Current Payroll Balances for a colleague i.e P60 Rate, Holiday Rates, Court Orders (othSummary Payroll Reports or Fusion pages that display the individual colleagues current Balances Content Hello, Is anybody aware of a method in which we can view a collea…Brad Hughes 12 views 1 comment 0 points Most recent by RyanPatrick Oracle Transactional Business Intelligence
-
Customizing a Seeded Report - Editing the Data Model and using PackagesSummary The Payable Invoice Aging Data Model uses package AP_APXINAGE_XMLP_PKG. I could use instructions on how to interact in SQL with this package. Content I am search…Tim Welsh 447 views 8 comments 0 points Most recent by Arun Raj Oracle Transactional Business Intelligence
-
Provide Link to Candidate Job Submission in OBIEE ReportSummary I am looking for a way to include a link to a candidate's job submission within the TEE OBIEE tool. Content Is there a way to include a link to a candidate's job…Chris Shaver - HEB 42 views 4 comments 0 points Most recent by Chris Shaver - HEB Oracle Transactional Business Intelligence
-
Phone screens completedSummary Looking to add the number of phone screens completed to report Content I have a current report that I am needing to add the number of phone screens that have bee…User_HZJPP 24 views 1 comment 0 points Most recent by Michael Scaduto Oracle Transactional Business Intelligence
-
Case When for date fieldsSummary Case when date is lesser than or equal to another date, THEN "on time", ELSE, "Not on time" Content I'm trying to build a Case statement that shows If one date i…slgott 101 views 2 comments 0 points Most recent by slgott Oracle Transactional Business Intelligence
-
archive unarchive and oracle bi admin roleSummary archive unarchive and oracle bi admin role Content Hi, in Oracle BI is it possible to get archive/unarchive functionality and not be an oracle bi admin? Our tech…Alex Andreadis-70445 582 views 4 comments 0 points Most recent by Alex Andreadis-70445 Oracle Transactional Business Intelligence
-
Complex filters - grouping 3 filters togetherContent I want to create a complex filter which requires grouping 3 filters with another set of filters. I have played around clicking the AND / OR to get the combinatio…Shree Pawar 77 views 6 comments 0 points Most recent by Deb Luisi Oracle Transactional Business Intelligence
-
Candidate Drop off ReportSummary a report that gives details on when a candidate drops off at an application and doesn't complete/submit Content We have been working on building a candidate drop…Iqra Khan 23 views 2 comments 0 points Most recent by Iqra Khan Oracle Transactional Business Intelligence
-
Report Employee Photo in Custom DashboardSummary Is there a way to display an employee photo in a custom dashboard? Content We have a custom Talent Profile dashboard and I am wondering if there is a way to pull…Brenda Jacks-49721 108 views 5 comments 0 points Most recent by Sandor Banfi-52443 Oracle Transactional Business Intelligence