Popular Tags
- OTBI 1,448
- Reporting 1,394
- FDI 1,123
- Analysis and Data Visualization 988
- BI Publisher 856
- Analysis 682
- Oracle Fusion Analytics 591
- Administration 555
- OAC 454
- OBIEE 433
- Analytics 403
- BI Publisher Data Models 356
- Security 293
- HCM 268
- BIP 264
- Answers 264
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Data Connectivity 210
- ERP Analytics Content 210
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 197
- Fusion Data Intelligence 187
- Report Output 184
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
-
Fetching last manager name and number for the terminated employees in sqlSummary Fetching last manager name and number for the terminated employees in sql Content Hi, Anyone know how to fetch the manager name for the terminated employees? For… -
Data model with parameter with "Select all"Summary Data model with parameter with "Select all" Content Hi, we created a data model based on several analisys and we want to add a parameter which filters by Employe…
-
Restricting access to OTBI Subject area and data elements within a subject areaSummary How do we restrict subject area access to a user through security role? Content Subject area access is driven by duty roles. A duty role 'Workforce Transaction A…
-
Time in role reportSummary I need to create a time in role report Content I need to create a time in role report. In our old system we had a calc which said minimum Effective Date for Empl…
-
Dashboard ReportSummary Dashboard Report Content Hi all, Can we able to make the Dashboard and Report width size equally while we are using 2 layouts? I have highlighted in yellow color…
-
Bursting ReportSummary A report on Probation which bursts out to Line Managers Content is there any example reports which look at Probation Period? Also sample reports for Bursting?
-
Access Denied for user to path..Summary Access Denied for user to path.. Content Hi, I'm a super user and have high level of security, but in the Report when I select Admin View and look at specific us…
-
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…
-
How to calculate subtotal of sectionSummary trying to get subtotal of section but it includes all data Content Any suggestions on how to get the subtotals added to this report? Example below, want totals f…
-
Syntax to converting 24 hour time format to 12 hour format in sqlSummary Syntax to converting 24 hour time format to 12 hour format in sql Content Hi, Anyone know the SQL syntax to convert 24 hour time format(eg. 18:00 for 6:00 PM) to…
-
Missing Name Infomration in Subject AreaSummary Cannot find field for Preferred Name, Employee Salutation, etc Content I cannot find the following fields in the worker or any other subject area. Preferred Name…
-
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…
-
Delivered Analytics on system usageContent Hello, I am part of another go-live of Cloud HR Core, different company. Does Oracle now provide any OBTI reporting regarding system usage to capture adoption/us…
-
Adding Totals to Stacked Bar GraphsSummary Looking for a best practice for adding a bar total to a stacked bar graph Content Has anyone found a way to add a total to a stacked bar graph?
-
HCM OTBI Reporting Challenge with User FoldersSummary Unable to see all user folders in Admin View Content In OTBI, our team is unable to see the entire listing of the User folders. Sometimes, they are visible, but …
-
InitCap without EvaluateSummary Trying to arrive at "normal" case for names without Evaluate function Content Names in our system are entered inconsistently and the goal is to be consistent wit…
-
External Data SourcesContent Hi All We are creating a bespoke application to complement Oracle Fusion. This application takes information from Oracle, processes it and then feeds it back int…
-
Exporting report in CSV adds extra space to fieldSummary CSV report adds a space to a field, which doesnt happen when report is exported via Excel. Content Hi, I have one report which is automatically scheduled to be s…
-
How to assign BI Administrator role in R12?Summary How to assign BI Administrator role in R12? Content In R11 I was able to assign BI Administrator role in APM. Without this role users are not able to archive/una…
-
Adding two measures not workingSummary Adding two measures not working Content I have a report where we are trying to add two measures together with a simple formula X + Y. This does not work within t…