Oracle Transactional Business Intelligence

Popular Tags
- OTBI 949
- Reporting 844
- Analysis and Data Visualization 647
- Analysis 572
- BI Publisher 506
- Administration 499
- obiee 282
- reports 282
- Oracle Fusion Analytics 240
- Analyses 237
- Developers 223
- BI Publisher Data Models 213
- FAW 212
- Data Connectivity 184
- Data Modelling and Datasets 160
- OBI Answers 150
- security 143
- Report Output 133
- Agents 130
- Packaging and Licensing 124
- Home and Catalog 116
- ERP Analytics Content 109
- HCM 105
- OBIEE Answers 102
- Access and Manage Data 102
Oracle Transactional Business Intelligence
Discussion List
-
Open source fonts to replace Monotype fonts in 24AWith the 24A release, open source fonts will replace the Monotype fonts currently available in BI Publisher and OTBI. For details on this replacement, see Open-Source Fo…
-
OTBI - Tables for 'Output & Delivery' Data from BurstingCan anyone please provide the database tables where the OTBI 'Output & Delivery' data is stored? We have a requirement to monitor and audit this data to confirm email of…
-
Need to remove the NULL option value from OTBI dependent promptWhen we creating dependent prompt using "limit by" option in the OTBI prompt, NULL value gets appended in the list of values. If user is running with NULL parameter repo…
-
Which table can store the BIP report permission details in oracle fusion hcm cloud?Which table can store the BIP report permission details in oracle fusion hcm cloud?
-
Accrual rate- plan balance APIHow we get the actual accrual rate in plan balance API response payload. https://xxxx-xxxx.oraclecloud.com:443/hcmRestApi/resources/latest/planBalances?orderBy=balanceAs…
-
-
How can I get "And" instead of "Or" to work with the same column?Summary: I have a sales team member column. Each team member respresents a different function on the team. Example: Primary and Overlay. I want to create a report that s…
-
Can we pull the filters used in OTBI Analysis?Hi We are searching for the feasibility/way to pull the filters used in the OTBI Analysis thru BI report or any other way. Please find the screenshot. Regards, Aruna Aou…
-
BI Publisher Excel - How to get multiple horizontal repeating groups working?Content Hello There, I would like to know how can I get the below output using BI Publisher for Excel. I have three groups in the xml file. G_1 -> G_2 -> G_3 Below expec…
-
Combining Project cost (Subject area) with General Ledger - Journals Real TimeHas anyone ever successfully created an OTBI report with Project - Costing Real Time and General Ledger - Journals Real time? Having some issues with the values. Thanks
-
Hi, wanted to know if in W2 form we have any box id, if yes in which table it gets stored?I wanted information on if we have any box ids for W2 forms? If there are any such ids, in which table do they get stored?
-
Hide the factory catalog Objects in OTBIDear All, We would like to Hide the factory catalog which comes as part of Cloud ERP Implementation. We have implemented these modules i.e. Finance,SCM,PPM. In this rega…
-
How do I display Years in drop down list without the decimals?When I set the default to show as the current year it doesn't show with the decimals (second screenshot), but when I go to select the other values they display with deci…
-
OTBI: Find the number of Working/Business Days between two dates and exclude Public HolidaysSummary OTBI: Requirement to find the number of Working/Business Days between two dates, therefore the calculation must exclude days that fall on Weekends or Public Holi…
-
How to consolidate several rows in one line in OTBI Pivot table?Hi All, Thank you in advance for your assistance. I have a query regarding the OTBI report I was working on for asset depreciation. I was wondering if it is possible to …
-
How to add a calculated column in OTBI Pivot Table ?Hi All, Thank you in advance for your help and support. I have a query regarding the OTBI pivot table. I was wondering if there is a way to add a calculated column to th…
-
BI Publisher desktop Not working with Office 365I installed BI Publisher desktop 32bit and 64 bit on office 365, but both are not working, I am unable to see BIP Addin in office tool Bar, I tried to to enable the AddI…
-
Pivot Table in RTF - BI ReportHello I have pivot table report and that works fine. I have to add a url (in another xml tag) to be hyperlink of the across field of the pivot. I tried following but it …
-
Password Protect Scheduled OTBI Excel AnalysisSummary Question on whether it's possible to add a password to OTBI output Content Hi, I'm looking to add a password to the output produced by OTBI Analysis (excel forma…
-
Bursting output file name character limitContent Hi, I have defined Bursting Output file name in the query as below- LegalEntityName || BusinessUnitName || 'Report' || To_CHAR(SYSDATE,'YYYYMONDDHH24MISS','NLS_D…
-
Option to get the Permissions associated with BI reportsWe have noticed that few of our BI reports have permissions which are incorrect and we would want to anlyze all the BI reports and their permissions to correct the same.…
-
Table Location of To/From Dates for Talent RatingsI am looking to find the the save table location for the To/From dates for the Talent Rating module. This is for a BI publisher report using a Data Model. The associated…
-
How to add sql query to OTBI filterI want to create an OTBI analysis that gives data between last 7 days. I tried creating a filter using SQL expression but it doesnt work. Can someone pls help with the r…
-
Where to find access and visibility information within the learning subject areasHello, we need to develop, within the learning module, two infolets relating to the editions to which managers can enroll their subordinates, and the editions to which p…
-
-
What's the column name for Requisition Number under Inventory Transfer Order Real Time subject area?I'm creating an OTBI report to pull open interorganization transfer orders and link the Requisition number from source org. These details are showing in 'Manage Transfer…
-
Coverage gaps and Normal vs Extract PVOIn extract type of PVOs, we observe that some columns are missing when scheduling using BICC. To get exact functionality of normal PVO, we need to use Multiple Extract P…
-
Notice on Deprecated PVOs in BICCCIn our solution we use normal PVOs and Extract PVOs, we observe that document available for Extract kind of PVOs . We load data by scheduling in BICCC. Can we continue t…
-
How to convert PO ordered amount in USD (Conversion type as SPOT)We are creating an analysis using 'Procurement-Procure to Pay Real Time' where we need to convert and display PO amount in USD. Using the conversion tyoe as SPOT. I coul…
-
When BIP report has an output of excel, how to adjust the cell size to fit the contents?Hello Oracle Gurus, Request your assistance. When creating the excel template, I normally increase the size of the cell. But sometimes there is data larger than expected…
-
Report for scheduled ProcessSummary Required Report to pull details of Scheduled Processes Content Hi Experts, I would like to know is there any seeded report or query available to pull the details…