OBIEE Answers
Discussion List
-
Subject Area to capture Employee detailsSummary: Content (required): Hi, Can someone please let me know the subject area to be used if the requirement is to capture the username, employee first name, employee …Sheneli Fernando 14 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Change Excel Sheet name in BI Publisher TemplateContent Hello, Is it possible to rename the Excel Sheet names of a BI Publisher Template Report [Type xpt] which has default output format as Excel (xlsx) ? I have creat…Nalinee Uppiah 88 views 2 comments 1 point Most recent by Raymund Jerome Reporting and Analytics for ERP
-
OTBI Report for AP Invoice HoldsSummary Sample OTBI Report for ERP Cloud: AP Invoices on HoldContent This is an update on Andy Gough's Topic using the new subject area. I have also enhanced Andy's repo… -
OTBI Payables Invoices to Subledger joinContent We have a requirement to display Payables Invoices data (Payables Invoices Transactions Real Time) and their corresponding Subledger entries & other Subledger sp…Rajagopalan Rangarajan 33 views 1 comment 3 points Most recent by Gillian Kilbride Reporting and Analytics for ERP
-
Customisation of Expense Approval Workflow Notification using BIPSummary Issues persist even while following expense config document step by stepContent Hi,We are trying to implement customized expense approval workflow notifications …
-
Manage Project Sets - Table/Subject AreaSummary: Content (required): Hi I would like to know which tables stores the information in regards to Project Sets that is created in Fusion. I find the manage project …Nicolas Vahman 1 view 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Payables Invoices by Cost Centre/SupplierSummary Dashboard & reports showing summary of AP invoice value by period/cost centre/supplier, with drill-down to invoice detailsContent Please see attached documents f…Andy Gough 634 views 10 comments 12 points Most recent by Sahil Makhiza Reporting and Analytics for ERP -
Where is WF_ROUTING_RULES located? Vacation Rules table?Content Hi, I'm trying to do reports for vacation rules and I have read I can use WF_ROUTING_RULES but or the life of me I can't find where these reside Any clues? Do I …King Jack 48 views 9 comments 2 points Most recent by Divya Mangtani Reporting and Analytics for ERP -
SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesSummary SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesContent Trying to built a query to fetch Application Roles, Privileges, Data Security & …
-
Export Current Page returns all rows i.e, entire dashboard data in OTBI.Summary: Export Entire Dashboard is exporting all rows but "Export Current Page" no longer exports only the rows on the current page. It is exporting all rows. Please ad…Abhilash K - Deloitte USI 31 views 5 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
OTBI Analysis: Is it possible to add a column that summarizes Invoice Amount by Supplier?Summary I'm building an analysis in OTBI and wanted to know if it's possible to have a calculated column that summarizes one of the other columnsContent I'm building an … -
Report on OTBI Agents Scheduled / StatusesSummary: Report on OTBI Agents Scheduled / Statuses Content (required): Is there any way to Report on OTBI Agents Scheduled / Statuses, either via SQL in BI Publisher or…AngelOftheNorth 1 view 3 comments 0 points Most recent by User_VX7QK Reporting and Analytics for ERP
-
Fixed Assets- Asset Balance Real Time and GL SegmentsSummary In OTBI Fixed Asset subject don't have the GL Segments - just concatenatedContent I need to build reporting on fixed assets around the different segments in the …amy hardtke 25 views 4 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
how to define a xml in rtf if there are multiple datasets with the same column nameSummary: Hi everyone, Recently I faced an issue with a seeded report that was customized. The report had two datasets with the same column on both, where when I try to l…
-
R13 Financials OTBI subject area to database lineage mapping spreadsheetSummary This spreadsheet documents R13 Financials OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by …Noelle Bartlam-Oracle 12.5K views 81 comments 44 points Most recent by Roelof de Groot Reporting and Analytics for ERP
-
How to disable Edit option in OTBI Reports?Summary How to disable Edit option in OTBI ReportsContent Need to disable the Edit Option from the OTBI Analysis. Could you please suggest how we can achieve this?Srikanth Raavi 64 views 6 comments 1 point Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP -
How to send BI Publisher reports to FTP folder from ESS jobSummary: How to send BI Publisher reports to FTP folder from ESS job Content (required): Hello All, I will appreciate your support in the following: When I schedule the …Bernard T 66 views 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Unable to locate Direct SQL option after upgrade 19ASummary Unable to locate Direct SQL option after upgrade 19AContent HI, I'm not able to location the Direct SQL option after upgrade the 19A. Can anybody suggest where w…Suresh.Kumarasamy-Oracle 55 views 10 comments 2 points Most recent by Shyam_Patel Reporting and Analytics for ERP -
Fixed column for year and other columns are promptedSummary: Content (required): Hi all I would like to know if it is possible to have one fixed column which always shows the forecast for e.g. 2022 while other columns are…Nicolas Vahman 21 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Adding and embedding BI content into Fusion Cloud ApplicationsSummary Looking for guidelines on which Fusion Cloud Applications pages we can add or embed BI content intoContent Hi All, Our client wants to be able to add some BI con…Richard Beet 317 views 32 comments 3 points Most recent by Aitor Quintela Reporting and Analytics for ERP
-
Create List of Values for Dependent Segments in GL Custom BI Publisher Reports White PaperSummary: Your finance staff may modify standard GL BI Publisher (BIP) reports to address specific business requirements. They may need to run a GL BIP report by various …Helle Hennings-Oracle 114 views 1 comment 4 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
R13: Project Portfolio Management Cloud OTBI: Subject Areas to Database Tables Mapping SpreadsheetSummary The spreadsheet provides a mapping of the BI Subject Area columns to source database tables and columns. It also has the View Object (VO) names for each column.&…Noelle Bartlam-Oracle 2.2K views 19 comments 4 points Most recent by User541815-Oracle Reporting and Analytics for ERP
-
Invoice Count by Supplier From Prior MonthSummary: COUNT function to display number of invoices by submitted from supplier in prior month using Dynamic Date scheduling Content (required): Hi All, Using the COUNT…Rory Chirmside 11 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
BIP Report to read file from UCMSummary Need to read file in UCM using BIP ReportContent Hi Team, Could you please let us know whether it is possible to read file from UCM via BIP report ? If anyone ha…Uvaraja-Oracle 82 views 7 comments 0 points Most recent by Rory Chirmside Reporting and Analytics for ERP
-
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 -
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 44 views 3 comments 0 points Most recent by Rebecca Walker 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 19 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
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… -
OTBI report - export to Excel limitationSummary: We have OTBI reports that will exceed the 50,000 field limitation for exporting to Excel. Content (required): Can you "schedule" an OTBI report to get around th…Kathy King 34 views 2 comments 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP