Popular Tags
- OTBI 1,373
- Reporting 1,352
- Analysis and Data Visualization 902
- FDI 898
- BI Publisher 794
- Analysis 655
- Administration 543
- Oracle Fusion Analytics 537
- OBIEE 417
- BI Publisher Data Models 328
- Analytics 313
- OAC 278
- Answers 259
- Security 255
- Analyses 251
- Developers 235
- HCM 225
- BIP 218
- Data Modelling and Datasets 210
- Data Connectivity 205
- ERP Analytics Content 193
- Report Output 180
- BI Publisher Report Templates 178
- Agents 148
- Customizing Reports 142
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
-
Max Export into Excel 2007 from OBISummary Wondering what the max export is into Excel 2007 Content Hello, Does anyone know what the max number of rows you can export from OBI into Excel 2007? I have hear… -
Scheduling Reports in OBIEE based on dynamic datesSummary Schedule report delivery on dynamic date parameter. Content Is it possible to schedule a report in OBIEE based on a dynamic date parameter via prompts built into…
-
Building a BO subquery in SQLContent Below mentioned are BO subqueries, need to use them in OBIEE. Can anyone list out anyway to do it..
-
Using Parent-Child Hierarchy values defined for COA segments in OTBISummary Using Parent-Child Hierarchy values defined for COA segments in OTBI Content We have Parent- child hiearchies for the COA segment values especially for BSV, Natu…
-
How do you make columns show distinct values in a table in BI PublisherContent I am creating a report in BI publisher and it shows duplicate values for employee ID's. Employee ID should be a distinct value and should not be returning duplic…
-
Error while running BIP report (0ORA-10260: limit size (1048576) of the PGA heap set by event 10261Content Hi, We are getting an below error while working on BIP report to fetch Person data in HCM module. Any idea what could be the cause..? Thanks! ORA-10260: limit si…
-
Invalid characters error message wne loading csv or excel fileSummary Can't load csv or excel file into BI data model Content Hi, When I try and load either csv file with comma separator or pipe or excel .xls file I get invalid cha…
-
Drill down capability using hyperlinks to the transaction pagesSummary Drill down capability using hyperlinks to the transaction pages Content Hi, I would like to know how we can build an OTBI report with an embedded link (url) that…Raghunathan Narasimhan-21427 52 views 4 comments 0 points Most recent by Raghunathan Narasimhan-21427
-
Convert text field to date to use for calculationContent We have a UDF field which is populated by the candidate on the recruiting side in a form. The input is a DATE. There is no other choice on how to bring in the da…
-
Adding Filters to a BIP reportSummary Adding Filters to a BIP report Content Hi All, How do I add Filters to a BIP report? Regards, Yaniv
-
BIP layout using space as a number grouping separatorSummary We have a request from the business users at our Hungarian branch to show longer salaries as '123 456' in our Compensation Statement (from the Comp Workbench not…
-
How to use session variables to customize a report outputContent Hi, I was wondering if someone has already use session variable to customize the output of a report. I'm currently creating a data model and I would have wanted …
-
Turnover by Ethnicity - Report AssistanceSummary: We are currently running into issues creating a Turnover report by Ethnicity due to how ethnicity is handled in Oracle. This is causing employees to be duplicat…
-
Exist Interview Responses Report Not working for some of countriesSummary: Hi Team, we haveExist Interview Responses Report it was developed on few years back still no issue but now yesterday only one of country working fine but reamin…
-
how to calculate Tenure dynamically (including for a historical date)Summary: I have an active HC report where I included a Tenure field using below formula however it is not good when we try to pull the report for a historical date. I am…
-
How to link Receivables - Customer Real Time and Receivables - Payment Schedules Real Time in OTBISummary: I am wanting to create a report with certain bill-to customer information that is not located within the Receivables - Payment Schedules Real Time subject area,…
-
FTE Breakdown (last year of 2020 and 2021)Summary: I want to make a report showing FTE by worker category, department, legal employer... per end of a period like end of month, end of quarter and end of year. I t…
-
Check Employee's Exit Clearance Details in HCM OTBII need to create a report where an 'Employee's Exit Clearance' status is displayed on the report, post his resignation/termination from the organization. Please share wh…
-
Does Generic soap webservice for BIP Report scheduling support JWT Token AuthenticationSummary:Does Generic soap webservice for BIP Report scheduling support JWT Token Authentication Content (required):Does Generic soap webservice for BIP Report scheduling…
-
Add to briefing book option takes 10-15 Min to load on published Dashboard over homepageSummary: We have created a custom dashboard which contains multiple analysis, when we click on any analysis to Add to briefing books it takes around 10-15 mins to give t…