OBIEE Answers
Discussion List
-
BIP Report ParametersSummary BIP Report ParametersContent Hi -> BIP Report Parameters: Can we make BIP report parameters in the required order if there are more parameters. Ex: I have 20 par…Amarnath Govindu 61 views 3 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
CSV output Date FormatSummary CSV output Date FormatContent Hello all, I have created one Report using new data model (OBIEE data source) and an Subject Area Analysis based query. I have crea…User_2025-01-30-21-01-20-715 71 views 14 comments 2 points Most recent by User_2025-02-03-21-40-10-404 Reporting and Analytics for ERP -
Incentive compensation - Recovery Amounts DashboardSummary 19D release feature - Participant Recovery Amounts Dashboard & reports on Performance and Earnings Summary Subject AreaContent Business Use Case: Attainment Rank…Harshavardhan Konathala 18 views 0 comments 0 points Most recent by Harshavardhan Konathala Reporting and Analytics for SCM -
Print Amount in Arabic in OTBI ReportSummary Print Amount in Arabic in OTBI ReportContent Hi, We have developed a report where every month we sent a balance confirmation letter to customer. This balance cou…Sanin Antony T 26 views 3 comments 0 points Most recent by Sanin Antony T Reporting and Analytics for ERP -
Customization on the AP invoiceSummary Customization on the AP invoiceContent Is it possible to do a customization on the AP invoice to validate certain fields and making some fields required based on…Mohammad Alhindawi 46 views 1 comment 2 points Most recent by User_2025-02-04-07-16-12-621 Reporting and Analytics for SCM
-
SQL Link between GL and ProjectsSummary Report which shows project transaction that have flown through to GLContent Hi Does anyone know the links/joins between GL and Projects, we are trying to build a…User_2025-01-30-20-23-15-920 1K views 4 comments 0 points Most recent by Michelle Haynes Reporting and Analytics for ERP
-
Copy Oracle Standard Report as Custom ReportSummary Copy Oracle Standard Report as Custom ReportContent I am new to OTBI in cloud version and have tried to create a very simple OTBI report. However, how to copy ex…User_2025-02-04-05-26-22-197 105 views 4 comments 0 points Most recent by Purnachandra Rao Reporting and Analytics for ERP
-
Is it possible to repete LOV(Data validation)to each row in BI Excel template outputSummary In the excel template row grouping we have created LOV for a single column, while generating excel reports and LOV applied to first row only, I need to repeat LO…Kalieswaran S-Oracle 22 views 0 comments 0 points Most recent by Kalieswaran S-Oracle Reporting and Analytics for ERP
-
R13.19A OTBI Direct Database Query Privilege ChangeSummary In R13.19A OTBI direct database query has been disabled by default. To prevent reports generating system errors, BI Administrator can modify BI privileges to rev…User720640-Oracle 144 views 6 comments 3 points Most recent by Amarnath Govindu Reporting and Analytics for ERP -
OTBI Calculated Measure sum is incorrectSummary Trying to sum two columns by rowDebbie Herbert 65 views 2 comments 0 points Most recent by Purnachandra Rao Reporting and Analytics for ERP
-
BI Publisher Report sporadically fails - database error?Summary Error message: SQL or ORA exceptions caused due to invalid SQL, database package state or some database exceptionsContent The error message "SQL or ORA exception…User_2025-02-01-06-21-55-603 44 views 1 comment 0 points Most recent by User_2025-01-30-01-18-25-142 Reporting and Analytics for ERP
-
SQL to Report on List of User Logins Per DaySummary seeking a listing of unique user loginsContent Can anyone provide SQL, or perhaps just table name, to get a list of unique user logins into Fusion? Thanks, Wendy -
Analysis & Query - for PRs history or apprvoal levelSummary Need to develop analysis to see the approval status and history of certiain PRContent Hi, I am trying to get the catalog or query to develop the analysis and rep…Farooq Syed, CPA, PMP, CISA 66 views 3 comments 2 points Most recent by Koteswararao Yenikepalli Reporting and Analytics for SCM -
GST Report for SingaporeSummary Anyone has built GST report for Sinagpore country?Content Anyone has built GST report for Singapore where output is bifurcated as per the tax rate and tax type c…Manish Gianani 63 views 1 comment 2 points Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP
-
How to extract Registration Number on OTBI?Content Hi I've used the mapping tables for R11 but cannot seem to find the 'Registration Number' under Registration Details (For Suppliers). What I do get back is 'Firs…Aaron Leggett 71 views 2 comments 1 point Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP -
eText Header RecordSummary I need to create a header record in an fixed position eText Template.Content I need to create a header record in an fixed position eText Template. Which contains…User_2025-01-28-20-26-08-493 49 views 1 comment 1 point Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP
-
Project Portfolio Management Cloud OTBI Release 12: Subject Area Description DocumentSummary This document provides a comprehensive description of each subject area including the key business questions that can be answered using the same.Content Use this…Rohan Lobo-Oracle 137 views 3 comments 1 point Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP
-
Project Portfolio Management Cloud OTBI Release 11: Subject Area Description DocumentSummary This document provides a comprehensive description of each subject area including the key business questions that can be answered using the same.Content Use this…Rohan Lobo-Oracle 54 views 1 comment 1 point Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP
-
OTBI - Combining gl segments values with Suject areasSummary Problems whenusing the Real Time Subject Areas combining with the tree hierarchy for GL ValuesContent My customer is trying to build an OTBI report using the Rea…User_2025-01-28-07-58-18-982 98 views 7 comments 1 point Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP
-
ERP - LAG / AGING reportSummary I need to create a LAG / Aging report and was hoping there's a report I could use as a starter.Content Not sure how the forums work as it's my first time here. A…User_5F4G3 51 views 2 comments 1 point Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP
-
Financials Cloud OTBI Release 11: Subject Area Description DocumentSummary This document provides a comprehensive description of each subject area including the key business questions that can be answered using the same.Content Use this…Anand DN-Oracle 113 views 3 comments 2 points Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP
-
Release 11 Data Lineage Guide for FSCM (Financials, Projects, Supply Chain)Summary The Data Lineage Guide provides a mapping of the BI Subject Area columns to source data base tables and columns. It also has the View Object (VO) names for each …Anand DN-Oracle 145 views 3 comments 2 points Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP