Popular Tags
- OTBI 1,429
- Reporting 1,383
- FDI 1,064
- Analysis and Data Visualization 976
- BI Publisher 840
- Analysis 673
- Oracle Fusion Analytics 577
- Administration 555
- OBIEE 429
- OAC 409
- Analytics 383
- BI Publisher Data Models 346
- Security 288
- Answers 264
- HCM 256
- Analyses 253
- BIP 248
- Developers 243
- Data Modelling and Datasets 223
- Data Connectivity 208
- ERP Analytics Content 205
- BI Publisher Report Templates 201
- Report Output 183
- Oracle Analytics Cloud 169
- Customizing Reports 156
Welcome to the Oracle Transactional Business Intelligence Community Forum!
Whether you're a seasoned user or just starting your journey with OTBI, the solution for transactional reporting in Fusion Apps, this forum is your go-to for questions and discussions. Connect with experts, seek advice, share insights, and post product recommendations in the Idea Lab.
If you're new to OTBI, visit our Doc Library and OTBI Resources pages for more details and answers to common questions - links to these and more are available in the Knowledge Base: https://community.oracle.com/products/oracleanalytics/kb/articles/62-resources-for-oracle-transactional-business-intelligence-otbi
For OTBI inquiries on subject areas and use cases, please direct your questions to one of our OTBI pillar forums (HCM, ERP, SCM, Sales, Field Service) on Customer Connect to receive tailored assistance.
Whether you're a seasoned user or just starting your journey with OTBI, the solution for transactional reporting in Fusion Apps, this forum is your go-to for questions and discussions. Connect with experts, seek advice, share insights, and post product recommendations in the Idea Lab.
If you're new to OTBI, visit our Doc Library and OTBI Resources pages for more details and answers to common questions - links to these and more are available in the Knowledge Base: https://community.oracle.com/products/oracleanalytics/kb/articles/62-resources-for-oracle-transactional-business-intelligence-otbi
For OTBI inquiries on subject areas and use cases, please direct your questions to one of our OTBI pillar forums (HCM, ERP, SCM, Sales, Field Service) on Customer Connect to receive tailored assistance.
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle Transactional Business Intelligence
Discussion List
-
How to override NULL values with existing valuesSummary How to override null value with values from another column in OBIEE Analysis Content When building an analysis in OBIEE, what would be the code to enter into the… -
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…
-
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, … -
Suspended job reportSummary Suspended job report Content Hi, I have a question about using a BIP job report: I have a job report that is scheduled to be sent every night if the day before s…
-
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 "…
-
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…
-
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…
-
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…
-
Link OTBI Summary Report to BIP Detail ReportContent Hi all - we have a request to link report A to report B. Report A will be like a summary report - name, manager, person #, job title. Report B will have signific…
-
Feasibility of having SQL Developer Connection to Oracle HCM Cloud Enviornment?Summary Feasibility of having SQL Developer Connection to Oracle HCM Cloud Enviornment? Content Hi Experts, I hope that most of you who have worked on an On-Premise syst…
-
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 …
-
Sharing OTBI AnalysesSummary Need guidance on how to share OTBI templates with other internal users Content Hi all! I am new to Fusion and OTBI. I have searched Oracle Support and the Librar…
-
BI Publisher, First Time Setup, Report ServerSummary I cannot find a clear guide to where I get the report server URL. Content The URL I tried it with is: https://podurl.fa.us2.oraclecloud.com:9704/xmlpserver/ I've…
-
Custom BI Webcat Reporting DutySummary Trying to hide seeded reporting folders and understand the updated options within 19D Content We are keen to have the option to hide seeded folders from users. C…
-
BI Publisher CSV files or Reading from Content Server sourceSummary Reading files on the Content Server in BI Publisher Content Hello, I'm trying to create a report in BI Publisher that will read an external file as a data source…
-
Custom Sort - BIP PivotContent Hi - I have a pivot table I am using through BIP and I need to apply a custom sort to it. I added an Order By to the DM, but it's not applying that to the pivot,…
-
Excel report is grey and no data is visibleSummary When generating an Excel with BI Publisher the file is grey and no data is visible. Content After generating an Excel file with the BI Publisher the sheet is gre…
-
Need inputs to find who created/deleted the folder in Reports and AnalyticsContent Hi All, We have different custom folders in Reports and Analytics side. Is there any way to find who created/deleted the folder or Data model or Report? We need …
-
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 …
-
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…