Popular Tags
- Reporting 1,302
- OTBI 1,238
- Analysis and Data Visualization 822
- BI Publisher 692
- FDI 675
- Analysis 628
- Administration 517
- Oracle Fusion Analytics 481
- OBIEE 393
- BI Publisher Data Models 290
- Answers 253
- Analyses 248
- Developers 231
- Analytics 211
- Security 208
- Data Connectivity 198
- Data Modelling and Datasets 189
- HCM 188
- ERP Analytics Content 169
- Report Output 165
- BIP 157
- Agents 147
- BI Publisher Report Templates 146
- OAC 139
- Packaging and Licensing 128
Customizing Reports
Discussion List
-
Custom PO Print - Text Attachment Content on BI Publisher ReportSummary We are creating a custom report where we need to display the Content of Text attachment for a Purchase Order. This information is not being stored in seeded Docu…Rahul L 311 views 2 comments 0 points Most recent by Robert Fighiroae-Oracle Oracle Transactional Business Intelligence -
User Time-Zone in BI Publisher Excel TemplateSummary User Time-Zone Management in Bi Publisher Content Hi, I am creating a report which has to extract a field which is managed with TIMESTAMP. Since this report shou…Alberto Romani-Oracle 217 views 3 comments 0 points Most recent by Robert Fighiroae-Oracle Oracle Transactional Business Intelligence
-
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 71 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 53 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 user650055 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 152 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 406 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 89 views 3 comments 0 points Most recent by Christian Berg -Oracle 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 258 views 7 comments 0 points Most recent by rajArun 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 363 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 275 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 11 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 365 views 8 comments 0 points Most recent by rajArun 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 41 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 21 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 91 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 453 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 71 views 6 comments 0 points Most recent by User_8TDVH Oracle Transactional Business Intelligence