OTBI
Discussion List
-
Access OTBI Data without Job RolesSummary For OTBI Administrators - Is there a way to access Data as a Super User without getting a specific Job Role assigned?Content Hey Guys, We were checking to see if… -
How do I create a variance Forecast - Actuals in OBIEE for EssbaseSummary: How do I create a variance Forecast - Actuals in OBIEE for Essbase where the Forcast and budget are row based as the Scenario dimension dictates whether the val…RichardChan 2 views 2 comments 0 points Most recent by Bharath Raghupathi-Oracle Reporting and Analytics for ERP -
oracle report to google sheet directlyis there any way to connect oracle BI and OTBI reports with online google sheet or offline excel file ? ThanksSandeep Nihalani 11 views 2 comments 0 points Most recent by Melissa G Reporting and Analytics for ERP
-
BI Publisher Output File NameSummary BI Publisher output file name Suffixes Template/Layout NameContent BI Publisher report output file from Oracle Fusion cloud suffixes the Template/Layout name at …Senthilrajan V 51 views 12 comments 2 points Most recent by Ravi Tilekar Reporting and Analytics for ERP -
Vacation and Delegation Rules reportSummary: Hi All, We have a requirement to create the below report for Vacation and Delegation rules in the application. Say when Line Manager is going on Holiday and he …Dharmendra Jha 21 views 3 comments 0 points Most recent by Stephen_J Reporting and Analytics for ERP
-
How to show 0 value instead of null value in a calculated formula column in OTBI report?Summary: How to show zero value instead of null value in a calculated formula column in OTBI report Content (required): I have a column 'Variance' which has value that i…Abhishek Shukla 12 views 3 comments 0 points Most recent by Rebecca Walker Reporting and Analytics for ERP -
Table for ESS Job scheduleSummary What is the table name in Oracle Cloud which stores the Schedule of an ESS JobContent Is there a table name or query which I can use for fetching the frequency, …Shubhojit Purkait 46 views 8 comments 0 points Most recent by User_M940T Reporting and Analytics for ERP
-
OTBI-Report-Supplier Portal - Invoice Real Time-Roles RequieredSummary: OTBI-Report-Supplier Portal - Invoice Real Time-Roles Requiered Content (required): Hello The following document state the role required to run the Supplier Por…Cesar Saveedra 21 views 3 comments 0 points Most recent by Cesar Saveedra Reporting and Analytics for ERP
-
How do i make a report which i created via OTBI available to be submitted via Scheduled processesHow do i make a report which i created via OTBI available to be submitted via Scheduled processes ? Version (include the version you are using, if applicable): 22A (11.1…
-
BI - Seeded and Custom Folders Mirroring Each Other?!Summary: We are experiencing several custom template issues and have noticed that our Custom and Seeded Folders are mirroring each other without human intervention. Cont… -
DFF not available in Subject area even after running the specified processSummary: We have created an OTBI report for Projects using Project Cost - Actual Real Time subject area and it includes a couple of DFFs. This report was migrated from o…Abhishek Shukla 5 views 3 comments 0 points Most recent by Abhishek Shukla Reporting and Analytics for ERP
-
Viewing USD AmountSummary Viewing USD AmountContent Hi, We have many companies in different countries that have different currency. We designed an pivot table using OTBI for Purchase Orde…Eren Göktepe-155015 20 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Create a report that shows invoice data on day it was loaded?Summary: Hi everyone. I am curious if there is a way to create a report that allows me to collect data from an invoice on the day it was created. Such as Problem Type. I… -
PO Spend Analysis in one currency (USD or Ledger Currency)Summary: PO Spend Analysis in one currency (USD or Ledger Currency) Content (required): We are using Oracle provided Analysis: PO Spend by Top Category We found that the…
-
What tables hold the project costs expenditure batch workflow details for creator and approverSummary:Does anyone know if this information can be reported on using BI Publisher or OTBI to view the approval workflow for project cost expenditure batches? This infor…
-
Restrict OTBI report data(using subject area) to logged in userSummary How to restrict OTBI report data(using subject area) to logged in user. Currently it shows all data. Data access given at Business Unit level for the role.Conten… -
What is Difference Between Secured and Unsecured Assignment Manager Folders in Workforce ManagementSummary: What is Difference Between Secured and Unsecured Assignment Manager Folders in Workforce Management - Worker Assignment Real Time Content (required): What is Di…Vijay Gorania 1 view 2 comments 0 points Most recent by Vijay Gorania Reporting and Analytics for ERP
-
Invoices Report acccessSummary: creating have created a report using Payables Invoices - Transactions Real Time and Payables Invoices - Installments Real Time Content (required): creating have…
-
OBIEE / OTBI Pivot Table Calculated % VarianceSummary: Need the equivalent of ABS in pivot table calculated column Content (required): In a pivot table presentation; - I have a calculated column; Variance which is e…AngelOftheNorth 13 views 2 comments 0 points Most recent by AngelOftheNorth Reporting and Analytics for ERP
-
Tax Registration from Supplier Address out of Supplier Real Time OTBISummary Looking for Supplier's Tax Registration Linked to AddressContent I'm building a supplier report inside the Supplier - Supplier Real Time subject area and attempt…Conrad the Supplicant 25 views 3 comments 2 points Most recent by Vikas Kanodia Reporting and Analytics for ERP -
How to get action link to pass parameter to 'Is Prompted' column when source column is calculated?Summary: Content (required): In Fusion Financials subject area; "General Ledger - Balances Real Time" I have been following the white paper to develop a dashboard based …AngelOftheNorth 2 views 1 comment 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP
-
Do analyses run with Agents log to "OTBI Usage Real Time" subject area?Summary: Do analyses run with Agents log to "OTBI Usage Real Time" subject area? Content (required): Version (include the version you are using, if applicable): Code Sni…Andrew_Schmitz 2 views 2 comments 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP
-
Folder/Report Last Modified DateHI Team, After a refresh/upgrade/patch getting applied does the folder last modified date change for each folder. We could see some folders have different last modified …Swapnil Kashid 1 view 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Projects-Labor distribution Cost analysis is missing exception information for error rowsSummary: Projects-Labor distribution Cost analysis is missing exception information for error rows Content (required): We have analysis built on Projects-Labor distribut…Mona Mantry 2 views 1 comment 0 points Most recent by Mike Bartoletti-Oracle Reporting and Analytics for ERP -
Is it possible to have manual input option with LOV menu?Summary: Researching the ability to manually input bulk values while keeping LOV search functions. Content (required): When you open the search box for dropdown paramete…
-
How to check Agent HistorySummary: How to check Agent History Content (required): As JOb history in BI shows executions of BI reports, do we have similar place to see executions of Agents ? Versi… -
How are you managing OTBI AgentsSummary: We have some analysis/dashboards that we want to schedule and send out as specific times using agents. Question is there any best practices around the managemen…amy hardtke 2 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
GL Segment Level security and OTBI Subject areasSummary: We have a requirement to secure data down to a legal entity/cost center level for dashboard built in OTBI with the GL Transactions real time subject area. How b…
-
OTBI analysis opens directly without showing prompt when opened from the reports and analytics pageHi team, Facing an issue where an OTBI analysis opens without showing any prompt from the reports and analytics page ( it's added to favourites ) but when opened by navi…
-
GL Segment Level security and OTBI Subject areasSummary: We have a requirement to secure data down to a legal entity/cost center level for dashboard built in OTBI with the GL Transactions real time subject area. How b…