Popular Tags
- Reporting 1,302
- OTBI 1,236
- Analysis and Data Visualization 821
- BI Publisher 692
- FDI 675
- Analysis 627
- 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
- BI Publisher Report Templates 146
- Agents 146
- OAC 139
- Packaging and Licensing 128
Answers
Discussion List
-
Scheduled Report JobsSummary Deails of Scheduled Report Jobs Content Hi Experts, I would like to know is there any seeded report to pull the complete details of scheduled report jobs in BI o…Charan Kollipara 181 views 8 comments 0 points Most recent by Akshay Aiyer 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
-
SQL to Query Report Library - OTBI CatalogSummary Looking for SQL or tables to report a list of all reports, properties and folder location Content Does anyone have a SQL or know the tables that would contain th…Lisa G. 695 views 4 comments 0 points Most recent by Lisa G. 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
-
Report on SocialSummary Need to create a report on Application Social Content Hi, We have a requirement to build reports on Social. Are there any OTBI Subject area or Tables to select f…
-
How to do an average days to approve formula?Content Hi all, I am trying to do an average days formula from a requisition submission date and when it was approved, and then put another column in with the month it w…Doron de Jong-57089 45 views 1 comment 0 points Most recent by aconavay Oracle Transactional Business Intelligence
-
What is catalog folder Extension?Summary Does anyone know the purpose of the empty shared folder Extension in the catalog? Content The folder is empty. A duty role exists for it, BI_EXT_REPORTING_DUTY, …Nathan CCC 31 views 1 comment 0 points Most recent by User_7836 Oracle Transactional Business Intelligence -
Building BOM using analysisSummary How to build a hierarchical BOM analysis showing on-hand quantity and item cost all for components in all levels Content In OBIEE, pre-built analysis "BOM" and "…Jonathan Chan gmg 41 views 2 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence
-
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
-
Help with Formula: most recent offerSummary I need help creating a formula to pull in the most recent offer Content I'm pulling together a list of YTD offers. I am finding records where the candidate has a…Rosenerie Castillo 93 views 7 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence
-
Lost Functionality in OTBI after PB 10.17Summary After taking PB 10.17, we saw that icons did not work in OTBI. Content We test after every monthly patch. What we found was that, after 10.17, we could no longer…Aaron Hager-17476 41 views 1 comment 0 points Most recent by Matthew Carothers-Johnson Oracle Transactional Business Intelligence
-
Reports Run CountContent Is there a way to find out how many times a report was run and who ran it? Like we may have 10 reports and want to find out which is the report that is used the …Neha_Takkar 81 views 2 comments 0 points Most recent by Julian Challenger-Oracle Oracle Transactional Business Intelligence
-
Convert Date FieldSummary Convert from MM/DD/YYYY to YYYY-Qx Content Hello, I have a date field I want to convert. I want to convert that from MM/DD/YYY to "YYYY-Qx". Any thoughts on how …slgott 56 views 2 comments 0 points Most recent by slgott 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
-
Trailing Spaces in OBIEESummary formatting question Content Hello! I am hoping to poll the community regarding some OBIEE formatting i'm trying to accomplish. I have a report where I need to cr…Joy Hanneman-161050 131 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Future Dated ActivitiesSummary Show me only the Opportunities that don't have a future dated activity added Content Hello, I'm struggling to think through how to do this. Here is the business …slgott 43 views 1 comment 0 points Most recent by MaartenDIF Oracle Transactional Business Intelligence
-
how to connect to Bi publisher administer console in fusion 19C?Summary How to access the bi publisher administer console in fusion 19c? Content I have added some roles to my fusion account. But, I cannot see the bi publisher adminis…Geetha Devi 141 views 11 comments 0 points Most recent by Geetha Devi Oracle Transactional Business Intelligence
-
Use ESS to run a BI Publisher job that transmits reports via SFTPSummary Is it possible to use ESS execute a BI Publisher job will transmits reports via SFTP? Content We have built some Custom Reports in BI Publisher that extract data…Juan Miguel Isip-94819 402 views 7 comments 0 points Most recent by rajArun Oracle Transactional Business Intelligence
-
Setting relative dates in a filter for an OTBI AnalysisSummary In an OTBI Analysis is there a way to add into a relative date range into a filter? Content I need an Analysis with a filter to pick up dates within the last wee…Tim Welsh 1.7K views 17 comments 0 points Most recent by Kamran Butt-161785 Oracle Transactional Business Intelligence
-
Security Console TablesContent Hi Everyone Quick question, is there a table that I can query in BIP that will show me the Roles and Roles Description? We have been struggling to assign the rig…Aaron Leggett 184 views 5 comments 0 points Most recent by Karthik Vinodkumar Oracle Transactional Business Intelligence