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 270
- Analyses 240
- BI Publisher Data Models 226
- Developers 220
- Data Connectivity 185
- Data Modelling and Datasets 164
- OBI Answers 153
- security 150
- 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
Customizing Reports
Discussion List
-
How To Find Advanced Custom Object Subject Area In OBIEESummary How To Find Advanced Custom Object Subject Area In OBIEE Content Hi, Where do I find the Advanced Custom Object Subject Area in OBIEE? I need to find Custom Obje…edpalomo 45 views 2 comments 0 points Most recent by edpalomo Oracle Transactional Business Intelligence
-
Presentation Variable Prompt causes Error on Results tab, but not in Open linkSummary AsOfDate prompt causes errors OPR4ONWY:U9IM8TAC:OI2DL65P Content I added the follow prefix to my analysis: SET VARIABLE PARAM_EFFECTIVE_DATE='@{AsOfDate}'; Then …Brenda Jacks-49721 142 views 8 comments 0 points Most recent by CB Oracle Transactional Business Intelligence
-
BI Publisher Excel TemplateContent Hi All, We have a nested table and beacause of this we are receiving this row mark in front of the data Printing and Stationery" rowMark="2 Does anyone know how …Kunal Daya-76859 25 views 2 comments 0 points Most recent by _IshanAgarwal Oracle Transactional Business Intelligence
-
Wrap Text in MHTML formatSummary Wrap Text in MHTML format Content Hi All, While selecting mhtml as a default template, i am not able to wrap text few columns such as description column. User wa…VAIDIA 41 views 1 comment 0 points Most recent by SantoshKumarBhairi Oracle Transactional Business Intelligence
-
OTBI performance recommendations paper (2679006.1) is available on MOS PortalSummary OTBI performance recommendations V2 doc is intended for OTBI system integrators, BI report developers and admins. It covers advanced performance tuning technique…Pavel Buynitsky-Oracle 92 views 4 comments 0 points Most recent by Pavel Buynitsky-Oracle Oracle Transactional Business Intelligence
-
How to version OBIEE report output sent to webcenter content serverSummary OBIEE reports are scheduled to send to WCC but getting "file already exists" Content We have several scheduled reports in OBIEE that are configured to send to th…John Stinnett 95 views 5 comments 0 points Most recent by Christian Berg Oracle Transactional Business Intelligence
-
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 142 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 109 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 46 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 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 25 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 57 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 …User_O1YC5 144 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 37 views 3 comments 0 points Most recent by Christian Berg 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 116 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 239 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 78 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 15 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 106 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 45 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 26 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 48 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 186 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 65 views 6 comments 0 points Most recent by User_8TDVH 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 21 views 2 comments 0 points Most recent by Iqra Khan Oracle Transactional Business Intelligence
-
Extracting all Columns from BIP Query without creating layout?Content Hi Guys I have to extract all the columns from 11 different tables for our finances guys to sift through and see what data they want. Some of these tables have 1…Aaron Leggett 55 views 2 comments 0 points Most recent by Manoj Madhavan 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 67 views 5 comments 0 points Most recent by Sandor Banfi-52443 Oracle Transactional Business Intelligence
-
Conditional FormattingSummary Conitional Formatting is not working properly Content I have created a report to help our teams identify at risk background checks. The report uses OBI condition…Tristan Hindes-55332 27 views 2 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence