Public Sector
Discussion List
-
Project Commitments Real Time - need current open PO balance by project OTBI analysisSummary: I am looking for a column for current open PO balance by project. I am currently using the "Project Costing - Commitments Real Time"."- Purchase Order Measures"…Alex Glose 21 views 9 comments 0 points Most recent by Rich Merkel General Transactional Reporting (OTBI) -
Can we report on the columns and subject areas used in an OTBI report?Summary: As 22d is removing the Workforce Learning - Learning Management Real Time subject area, I wondered if there was a report that could tell us which of our reports…Dawn Cawston - CPS 41 views 6 comments 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI) -
How can I find all reports using the same BI Publisher Data ModelSummary I need to be able to identify all the reports that are using a Data Model before I make changes to the DM.Content Bi Publisher Data Model has been created, I now…Sarah Munro 12024679 34 views 8 comments 2 points Most recent by Frank Davidson General Transactional Reporting (OTBI) -
Filter out Employee RatingSummary: I have created a report that has the field Rating Level Name but it includes both Employee and Manager Rating Level Content (required): I how do I identify whic…Dawn Cawston - CPS 2 views 3 comments 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI)
-
OTBI report and data role securitySummary: Should an OTBI report using General Ledger - Balances Real Time subject area (linked to the Essbase cube) inherit custom data roles configured in SaaS? Content …Craig Hevey 2 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI) -
Report Job History in Chrome, Blank ScreenSummary When navigating to Report Job History in Chrome, page loads, but then disappears. See screenshotContent Has anyone else ever encountered this? The page renders c…David Rabalais 27 views 2 comments 1 point Most recent by David Rabalais General Transactional Reporting (OTBI) -
Functionality to store the details of an email sent through burstingContent As an organization, we have used bursting for various notifications to staff. There is a business need to show that some of these emails were sent to individuals…Ian Rumble 17 views 1 comment 1 point Most recent by Anil Kola-Oracle General Transactional Reporting (OTBI) -
Dashboard with multiple BI Publisher reports export to excel is blankSummary When using the Export entire workbook to excel function the exported excel sheet creates all the correct worksheet pages and headings however, the data is blank.…Sarah Munro 12024679 24 views 2 comments 0 points Most recent by Sarah Munro 12024679 General Transactional Reporting (OTBI)
-
OBIEE 11.1.1.9 - BI Publisher report with Bar Chart - Hover does not show dataSummary I have created a BI Publisher report with a bar chart however, when I run the report there is no data shown when I hover over the bar graph.Content I have now us…Sarah Munro 12024679 21 views 0 comments 1 point Started by Sarah Munro 12024679 General Transactional Reporting (OTBI)
-
VO for ASE tablesContent Hi, are there VO for ASE tables like ASE_USER_LOGIN_INFO to extract data other then using BIP I would like to do scheduled extract to load into ADW for reporting…User_32E4S 23 views 2 comments 1 point Most recent by Robert Fighiroae-Oracle General Transactional Reporting (OTBI) -
1z0-591 OBIEE CertificationSummary Need assistance on preparation of 1z0-591 OBIEE examContent Hi Experts, The course is all about 12 C and the exam is for 11 g.So can anyone help me how to prepar…priscilla balusupati 23 views 2 comments 0 points Most recent by priscilla balusupati General Transactional Reporting (OTBI)
-
SQL to Query Report Library - OTBI CatalogSummary Looking for SQL or tables to report a list of all reports, properties and folder locationContent Does anyone have a SQL or know the tables that would contain the… -
Custom BI Webcat Reporting DutySummary Trying to hide seeded reporting folders and understand the updated options within 19DContent We are keen to have the option to hide seeded folders from users. Ch…Sian S 40 views 5 comments 2 points Most recent by Christian Berg-0racle General Transactional Reporting (OTBI)
-
Oracle report development methodologySummary Looking to see if there is a suggested report development methodology for use across Oracle reporting toolsContent Using HCM & ERP and wondering if there is a re…Christine Pritchard 41 views 4 comments 4 points Most recent by Nathan CCC General Transactional Reporting (OTBI)
-
BI Publisher Report as Cloud Data Extract engineSummary Use of Report as Cloud Data Extract engine and keep track of extracted data/ recordContent Cloud Integration process where data is extracted and sent via FTP to …Sandip Kumar, PMP, CPIM 36 views 2 comments 0 points Most recent by Shalindra Singh General Transactional Reporting (OTBI)
-
Terminations ReportContent Hi I am currently trying to create a terminations report. I cannot find the following: - Termination Action - Termination Reason I am using the Workforce Managem…Aaron Leggett 224 views 8 comments 1 point Most recent by Jatinder Tanda General Transactional Reporting (OTBI) -
BI/OTBI report location and last run date - is it possible?Summary BI/OTBI report location and last run date - is it possible?Content Hello I want to be able to extract a list of all OTBI and BI reports and their folder location…Helen Thomas-53877 60 views 2 comments 0 points Most recent by Helen Thomas-53877 General Transactional Reporting (OTBI)
-
Two Pivot Tables with Different ValuesContent Hi I am trying to contain a report that has two pivot tables in it but with different parameters to restrict the results. I am pulling in the Expenditure Type co…Aaron Leggett 25 views 0 comments 0 points Started by Aaron Leggett General Transactional Reporting (OTBI)
-
Extracting Configuration Options via OBIEEContent Hi All I've been asked to try and export the configuration options of expenses (Setup and Maintenance > Manage Policies By Expense Category). Now, I can export t…Aaron Leggett 23 views 1 comment 0 points Most recent by Satish Kumar-21650 General Transactional Reporting (OTBI)
-
OTBI Security HelpContent Hi All, We are deploying some reports to production for the HR team to use. We are confused with the way the security works in regards to the reports. Ideally, w…Aaron Leggett 59 views 1 comment 0 points Most recent by Suvankar Dasgupta General Transactional Reporting (OTBI)
-
Oracle Data WarehouseContent Hi In order to utilize the full capability of Oracle Reporting (OTBI), do we need to purchase the Data Warehouse? We are currently under the impression that we a…Aaron Leggett 31 views 3 comments 2 points Most recent by Antony Hooper-29731 General Transactional Reporting (OTBI)
-
SQL IS NULL errorContent Hi We're trying to create multiple reports where we want to bring back a column with no data in (e.g. Missing Bank Details where the employee does not have a ban…Aaron Leggett 32 views 3 comments 0 points Most recent by Neil Peacock General Transactional Reporting (OTBI)
-
How to stop employees viewing reports in 'Custom'?Content Hi We're having some trouble with report access. We're testing our reports and came across an issue where accounts with just the employee role can run reports co…Aaron Leggett 43 views 2 comments 0 points Most recent by Aaron Leggett General Transactional Reporting (OTBI)