OBIEE Answers
Discussion List
-
Seeking Assistance Querying for Basic Transactional MetricsSummary How to get counts of journal lines, invoices, and payments per month?Content I'm hoping someone can give me a head start on how to query for the following transa… -
New OTBI Help Landing PageSummary Introducing a brand-new OTBI Help Landing PageContent This e-mail is sent by Oracle OTBI product management. Starting with Release 13.18.10, a brand-new OTBI Hel…User720640-Oracle 71 views 0 comments 5 points Most recent by User720640-Oracle Reporting and Analytics for SCM -
New OTBI Help Landing PageSummary Introducing a brand-new OTBI Help Landing PageContent This e-mail is sent by Oracle OTBI product management. Starting with Release 13.18.10, a brand-new OTBI Hel…User720640-Oracle 75 views 0 comments 6 points Most recent by User720640-Oracle Reporting and Analytics for ERP -
Restrict Data in OTBI Based on Specific RoleSummary Is it possible to create role based restrictions on data within OTBI?Content In Cloud ERP, I can create data access sets and value set security rules and assign …Daniel Willmott 243 views 1 comment 1 point Most recent by User_2025-01-29-23-00-32-611 Reporting and Analytics for ERP -
Transaction time in the report and in Payables Application are differentSummary Transaction time in the report and in Payables Application are differentContent Hi all, Developed a report using Payables -transactions real time subject area.In…Dev Thota 66 views 4 comments 0 points Most recent by Manish Pesswani Reporting and Analytics for ERP -
user role security context security context value reportSummary user role security context security context value reportContent Is there a report where we can retrieve all values as shown in screen shot below?User_2025-01-28-19-49-26-512 259 views 1 comment 1 point Most recent by User_2025-01-30-20-43-00-868 Reporting and Analytics for ERP -
Column aggregates without showing measure columnsSummary Column aggregates without showing measure columnsContent Hi All, I have built a report with multiple measures. Is it possible to show only the column level aggre…Ishan B-112616 43 views 0 comments 0 points Most recent by Ishan B-112616 Reporting and Analytics for ERP -
How to filter between Accounting Period Name in GL dashboard promptSummary How to filter between "Accounting Period Name" in GL dashboard promptContent Hi, I need to use "Accounting Period Name" in "General Ledger - Journals Real Time" … -
R11 ERP OTBI Subject Area Mapping to Fusion Database TablesSummary Release 11 ERP OTBI subject area database table mapping spreadsheetContent This spreadsheet is published by Oracle OTBI Development. This spreadsheet documents F…User720640-Oracle 503 views 14 comments 9 points Most recent by Koteswararao Yenikepalli Reporting and Analytics for ERP -
Reports Generated from Schedule Processes to be mapped to spring boardSummary Reports Generated from Schedule Processes to be mapped to spring board e.g. GL Accounts AnalysisContent Hi All, Is there a possibility to map reports generated v…Achala Munasinghe 70 views 3 comments 0 points Most recent by User_AEMC1 Reporting and Analytics for ERP -
Default "Account Period Name" value in OTBI Prompt while scheduling AgentsSummary Is there a way to default Period name on the OTBI Prompt while scheduling the Analysis from Agents?Content We have an OTBIE analysis "AP Transaction Report" that…GopiKAutomus 410 views 5 comments 0 points Most recent by User_AEMC1 Reporting and Analytics for ERP -
Custom Data Model - Remittance Advice - Change From Check to Wire Payments?Summary Custom report using SQL data model - How to change from check payments to wire payments?Content We have a custom report for AMEX remittance advice which gives us… -
What table joins required to link PO Receipts to GL lines in Data Model?Summary Need to Extract GL lines with PO Receipt details, PO Number with Data ModelContent Hello, We are trying to create a custom GL Report that will show subledger det…user6675104 491 views 2 comments 0 points Most recent by Zlatko Alvir-Oracle Reporting and Analytics for ERP