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
-
BIP Report created from OTBI AnalysisSummary Passing parameters to BIP Report created from OTBI Analysis Content How do we pass input parameters to BIP Report created from OTBI analysis? -
Need Primary Key: BICC FscmTopModelAM.DooTopAM.FulfillLineSummary Need Primary Key: BICC FscmTopModelAM.DooTopAM.FulfillLine Content We are relying on BICC to send data to the UCM, where it is picked up by another process and u…
-
How to extract the information of fusion approval groups via report or web-serviceSummary read approval groups information and extract to be used outside SaaS Content We have managed to develop approval groups in SaaS like the attached document, And s…
-
Syntax to fetch pending transfer details from Data_cache column in hrc_txn_dataSummary Syntax to fetch pending transfer details from Data_cache column in hrc_txn_data Content Hi, We need to fetch the pending transaction Transfer details like New Lo…
-
How to display count(new customer account opened) from lasy year's month-to-date in analysisSummary How to display the amount of new customer account opened in last year's month-to-date, together with this year's month-to-date data Content Hello Oracle Communit…
-
How to create a prompt, Year-Month format, in analysis while not having a "Month" dimension?Summary The goal is to enable end users to look at an analysis by year-month periods (ex. YYYY-MM, 2020-01), but "Month" dimension is not available within the subject ar…
-
Administration & Recruiting ReportingSummary I need to union report on these two environments Content I have gone through the other postings and from what I can see, I believe this is not possible, but want…
-
Publish Agent for SubscriptionSummary I need to know the limits of the functionality Content I used several OTBI Agents to deliver some OTBI Analysis to users. To avoid them to create their own agent…
-
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…
-
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…
-
Hidden fields in OTBISummary Need to find fields selected as 'Hide' as system default in column properties Content We have recently had an issue where one of our users has hidden a couple fi…
-
Need a SQL query to list all the scheduled OTBI Analsis and dashboardsSummary We need to review and track all the OTBI reports that are scheduled via agents Content Having the ability to query this out helps us understand who all have sche…
-
Extract first sets of integer from entriesSummary How to extract the first sets of integer from entries in "New Calculated Measure" Content Hello Oracle Community, In "New Calculated Measure" in Analysis, how ca…
-
call a procedure on oracle bi publisher 12cSummary oracle bi publisher add Global-Level Element by PL/SQL Content Hello all, How to call a procedure that return multiple parameters on oracle bi publisher data mod…
-
Rows overcounting in AnalysisSummary How to only count the number of rows showing in an analysis Content Hello Oracle communities, When I attempt to display the total number of rows shown in an anal…
-
Hide Set at Default button under column propertiesSummary Hiding Set as default button under column properties in an Analysis Content Is it possible to hide the 'Set as Default' button under the column properties in an …
-
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…
-
Error when using TODATE(REVENUE, YEAR) Oracle SQL functionSummary TODATE function resulted in error, what are possible alternatives to get the needed results? Content Hello Oracle Community, The below error (per enclosed 2 scre…
-
How can I export a list of all active reports we have HCM?Summary I need to have a list of all our reports in HCM BIP (and/or)OTBI Content How can I found out how many reports there are in use at the sys? Who created them, acti…
-
Sort drop-down list descendingly in Table Prompts in AnalysisSummary How to sort drop-down list descendingly in Table Prompts in Analysis Content In OBIEE Analysis, how can table prompts value (per enclosed screenshot) be set to s…