Popular Tags
- OTBI 1,454
- Reporting 1,397
- FDI 1,139
- Analysis and Data Visualization 988
- BI Publisher 863
- Analysis 684
- Oracle Fusion Analytics 596
- Administration 555
- OAC 475
- OBIEE 434
- Analytics 408
- BI Publisher Data Models 359
- Security 296
- HCM 269
- BIP 265
- Answers 265
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- ERP Analytics Content 214
- Oracle Analytics Cloud 213
- Data Connectivity 211
- BI Publisher Report Templates 205
- Fusion Data Intelligence 193
- 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
-
Access procurement approval workflows in OTBIHello, Is it possible to access the requisition/order approval workflows to add into an OTBI analysis, the people that a requisition/order is pending to be approved? Thaโฆ -
Webservice or REST API to fetch Data from OTBI ReportWe are trying to get data from seeded OTBI Report through webservice: https://instanceURL/analytics-ws/saw.dll? but getting the following error: GCARFLCS 16โฆ
-
Can we find where an OTBI analysis is used in other items (filter/result of another analysis)We need to make some changes to an OTBI analysis which is used as filter in other analysis/dashboards. Is there any way to find out by which dashboards and analysis thisโฆ -
How match Fusion application and OTBI page theme colourHi, After P2T refresh, we change the Fusion application theme colour for Non-PROD PODs. But, these colour changes do not reflect in the OTBI page. (Reports and Analyticsโฆ
-
How to show reporting currency in OTBI reportNow we have 2 primary ledgers, ledger 1 with ledger currency as HKD, Ledger 2 with ledger currency as SGD. Now we have setup 2 reporting currency in USD for the 2 ledgerโฆ
-
I want to prepare an OTBI report to capture roles and data access informationDear Members, I want to prepare an OTBI report containing the below details: Username Email Job Title Company Manager Name Role Name Role Code Security Context Security โฆ
-
Can we get the table definition or the underlying table definition for a subject areaCan we get the table definition or the underlying table definition for a subject area
-
MCPD on Assignment - get top of stackWe are using the following qualifiers for getting a recent assignment. paam.primary_flag='Y', paam.assignment_type='E', paam.effective_latest_change='Y', paam.assignmentโฆ
-
Need help with OTBI columns on AP invoice dataHi folks, I need to analyze below info from our AP invoices data. No of invoices migrated by period (from legacy system) No of invoices created manually by AP team by peโฆ -
Unable to restrict results with workschedule filters when it is blank or non primaryIssue: There are multiple subject areas combined together to generate results which is embedded in dashboard. A new change has been requested to include employee's worksโฆ
-
Unable to extract current date from current_timestamp for the local timezone in OTBIHi, I have a requirement to report current day sales value. I am trying to leverage CURRENT_TIMESTAMP function as it gives me my local time. But when I try to extract daโฆ
-
Joining two subject areas in fusion SCM OTBINeed to build a dashboard in order to fetch the below information as shown attached. Please let us know how can we achieve the same. Like on hand related information we โฆ
-
Query to get tax reporting code in customer's siteHello community I need help with a query to get the tax reporting code, of a particular tax reporting type code ("XX_AR_DESC"), which is assigned on a customer's site (nโฆ
-
Looking for data dictionary for Oracle Talent Management 23B, specific to Recruiting subject areasHello! We recently implemented Oracle Talent Management 23B and our team is working through understanding the data columns within our 5 Recruiting subject areas: 1) Recrโฆ
-
Restrict User to create OTBI or BIP reportsSummary: Requirement is that Users should not be able to create any OTBI reports from his account. We have already restricted the Permission for the user to access otherโฆ
-
๐๐๐๐ฉ ๐๐ข๐ง๐ค๐ฌ (๐๐๐) ๐ญ๐ก๐ ๐๐จ๐ฆ๐ฉ๐ฅ๐๐ญ๐ ๐จ๐ฏ๐๐ซ๐ฏ๐ข๐๐ฐ (all of them)๐๐ซ๐๐๐ฅ๐ ๐๐ฅ๐จ๐ฎ๐ ๐ ๐ฎ๐ฌ๐ข๐จ๐ง ๐๐ฉ๐ฉ๐ฅ๐ข๐๐๐ญ๐ข๐จ๐ง๐ฌ โ ๐๐๐๐ฉ ๐๐ข๐ง๐ค๐ฌ (๐๐๐) ๐ญ๐ก๐ ๐๐จ๐ฆ๐ฉ๐ฅ๐๐ญ๐ ๐จ๐ฏ๐๐ซ๐ฏ๐ข๐๐ฐ (all of them) We all know that you can create Deep Links from your OTBI / BI Publisher (incl noโฆ
-
Can you get data from data model or report (not analysis) thought web service (XmlViewService) ?Summary: We need to get the data displayed in a data model or report in an web service (for further integrations). The web service is XmlViewService which allows Executeโฆ
-
Does a general Subject Area reference exist anywhere?I know of the existing Subject Area references which list the FAQs and roles that secure that subject area. Is there a more detailed reference that can give me instructiโฆ
-
Is there are way to get the list of reports data and the column details used in reach reportI want the list of reports using XYZ column. We used to get this in Onpremise installation from Catalog, but i am unable to export the list of reports and their path andโฆ
-
I want to place hyperlinks with dynamic values in my BIP reportquestion. I am creating a BIP report and I am facing the below issue. What I'd like to do is have a mechanism that, when clicked, opens another BIP report. If I just wriโฆ