Popular Tags
- OTBI 1,428
- Reporting 1,383
- FDI 1,062
- Analysis and Data Visualization 976
- BI Publisher 840
- Analysis 673
- Oracle Fusion Analytics 577
- Administration 555
- OBIEE 429
- OAC 407
- Analytics 382
- BI Publisher Data Models 346
- Security 288
- Answers 264
- HCM 256
- Analyses 253
- BIP 247
- 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 168
- 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
-
-
I am looking for tutorial where we create Report using 2 subject areas using union all operatorI am looking for tutorial where we create Report using 2 subject areas using union all operator
-
Data Retention / Purging DataAssistance required to begin purging data into HCM for Recruitment, Employee, and Payroll. Please share any working examples or useful information I am a UK customer and…
-
How to get/split output data into multiple files (based on specific column in a analysis output)The output of the analysis needs to be split into multiple excel files based on one specific column for example Project organization and that needs to sent to respective…
-
How can I create a report in OTBI that shows scheduled hours and the deviation from reported hours?I am looking for to generate OTBI report to report reported hours, scheduled hours and scheduled deviation as shown in attached screenshot. Can someone please help to kn…
-
How to Resize the columns in OTBI BI report viewsTried to apply Additional Formatting Options (width, height, etc. fields) and also Column Properties too it doesn't work as expected , is there any other way we can Resi…
-
Java.sql.SQLException: Invalid column indexSummary Errors out with the mesaage Content Hello There, We are using Oracle Financials Cloud and BI Publisher. I have a simple WITH Clause sql construct. On execution i…
-
I can't filter columnHallo i can't filter column or give column conditions in a table. Can you please help me?
-
Default PDF Room Level of XPT FormatAfter exporting PDF format of XPT format report, the report content shows very small in PDF which need to enlarge several times to see the content. Where l can configure…
-
-
Seeded Head Count Reports not workingWe have been trying to run the seeded Head Count reports for our client but none of them have been rendering data. The reports are Head Count, Headcount Activity, Headco…
-
Can Someone help with table and column details for the Manager performance check-in feedback columnHi, we have OTBI report developed for check-in details summary information. As this is hitting performance issues very often and taking very long time to run. we are con…
-
OTBI for Model Profile vs Person Profile Competency Gap AnalysisHello Experts, We have a requirement to pull Person Talent Profile Competencies ratings and Model profile Minimum ratings, I am using Workforce - Person Profile real tim…
-
OTBI Report does not show Person Legislative information DetailsOur business has created few reports where they are capturing personal details of users and it includes person legislative info but in OTBI the data is coming blank for …
-
How to Effective Date a Headcount Report?I have a headcount report in OTBI HCM, that is running from the Worker Assignment Real Time subject area. When it runs, its always latest and greatest. How do I effectiv…
-
BICC Audit LogsHi team, I wanted to find out if there are audit logs for BICC that capture user actions on the UI. For example, when a BICC job is edited, are those actions recorded in…
-
Payroll and Compensation Subject AreasWithin OTBI Reporting, the Payroll and Compensation Subject Areas no longer show any data. On 24C
-
Calculating Percentage in OBIEE ReportSummary Calculating the Percentage of two columns. One column being a calculated field in itself and the other pre-defined field. Content Hello, I am trying to calculate…
-
Recommended frequency to extract the active primary keys/application dataWe are currently using BICC to extract FSCM, CRM, etc. data to build a data warehouse for analytics (one time full load followed by incremental loads). Noticed that BICC…
-
Creating dashboard prompt with custom datamodel and reportHi, I created a report with custom datamodel with 2 prompts. This is how it looks like. Datamodel Datamodel prompts are LOV and SQL query. Report With this, I created a …