-
Forums
-
- Applications (SaaS)
-
Marketing, Sales, and Service
Marketing, Sales, and Service
DashboardB2C Service
Field Service
Marketing
-
Human Capital Management
Human Capital Management
DashboardTalent Management
-
Enterprise Resource Planning
Enterprise Resource Planning
DashboardRisk Management
Project Management
Reporting and Analytics
Integrations, Extensions, and Security
-
Supply Chain Management
Supply Chain Management
Dashboard -
Reporting and Analytics
Reporting and Analytics
DashboardSolutions for Applications (OTBI)
- Reporting & Analytics for HCM
- Reporting & Analytics for Taleo Enterprise (TEE)
- Reporting & Analytics for Taleo Midsize (TBE)
- Reporting & Analytics for Taleo Learn
- Reporting & Analytics for ERP
- Reporting & Analytics for SCM
- Reporting & Analytics for Sales
- Reporting & Analytics for B2C Service
- OBIEE for Applications
Business Analytics
- Applications Security
-
More
More
-
Infrastructure (IaaS)
and Platform (PaaS)Infrastructure (IaaS) and Platform (PaaS)
DashboardContent and Experience
Business Analytics
Security
System Management
-
Partners
OPN Technical Assistance Forums for Partners
BUILD: Partner Technical Assistance
For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
SERVICE: Partner Technical Assistance
For partners that provide implementation or managed services around Oracle Cloud Applications
- Announcements
-
-
Ideas
-
- Applications (SaaS)
-
Marketing, Sales, and Service
Marketing, Sales, and Service
Marketing, Sales, and Service
-
Human Capital Management
Human Capital Management
-
Enterprise Resource Planning
Enterprise Resource Planning
-
Supply Chain Management
Supply Chain Management
-
Reporting and Analytics
Reporting and Analytics
Reporting and Analytics
-
Platform (PaaS)
Platform (PaaS)
-
-
Events
-
Events
Sales and Service
Human Capital Management
-
- Contribute
- Hall of Fame
- Learning
- Success
- Documentation
- Support
Posts
Posts
Topic posted February 16, 2017 by Tu Lam
, tagged Asset Tracking, Configure to Order-CTO, Costing, Dashboards, Geneology, Innovation Management, Installed Base, Inventory, Maintenance, Manufacturing, Order Management, OTBI, Procurement, Product Development, Product Information Management-PIM, Quality – Inspections, Quality – Issues and Actions, Reporting and Analytics, SCM, Supply Chain Collaboration, Supply Chain Common Components, Supply Chain Financial Orchestration-SFO, Supply Chain Planning in Reporting and Analytics for SCM publicTitle:SCM and PRC OTBI Subject Area DescriptionsSummary:SCM and PRC OTBI Subject Area DescriptionsDocument:- Topic posted February 14, 2017 by Lukas Oleksiak
, tagged Fusion Project reporting, OTBI in Reporting and Analytics for ERP publicTitle:OTBI on delegated authoritySummary:I require an OTBI report to display the users who have set up a delegated approval (for OTL, Requisitions etc), when they created and who they delegated their approval to.Content:Does anyone know if it is possible to create this?
Topic posted February 14, 2017 by Aaron Leggett
, tagged Analyses, Core HR, OBI Answers, OBIEE Answers, OTBI, Public Sector, Reports, SQL in General OBIEE publicTitle: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 bank account number). When we run the report without a filter, we get back all the results as expected (records who have bank details and records who do not have bank details). When we apply the IS NOT NULL filter, we get back all the results as expected; records whom have bank details. However, when we apply the IS NULL filter, we get an error and don't get back any results when we should be getting back around 300.
Currently we're having to run the report without a filter and then apply filters in excel to find out which records are missing bank details. Is there any other formula we could try other than IS NULL?
- Topic posted February 13, 2017 by Rohan Lobo
, tagged Fusion Project reporting, OTBI, Reports in Reporting and Analytics for ERP publicTitle:OTBI Reporting for Project Portfolio Management (PPM) Cloud - Tips and TechniquesSummary:The white paper addresses frequently asked questions in OTBI reporting for Project Portfolio Management (PPM) Cloud. It also includes tips to enhance report performance and other useful topics.Document:OTBI_PPM_Reporting_Tips.pdf (335KB) - Topic posted February 13, 2017 by Peter Kirwan, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Core HR, Data Models, Fusion, OBI Answers, OBIEE Answers, OTBI, Report Delivery, Report Layouts, Report Output, Reports, Sample Reports, SQL in General OBIEE publicTitle:StatsSummary:Stat ReportContent:
is it possible to report where you have a count of the number of employees in a age range - the age ranges would be columns and then rows would be the Department Grouping they are in?
I would then section by Grade
Topic posted February 10, 2017 by Clifford-Barrington Trett, tagged Analyses, Core HR, OTBI, Reports in General OBIEE publicTitle:Absence Leave Amount & Payroll Element NameContent:Good Day,
We have been tasked to create a report where anyone who has booked less than a full days leave is highlighted. This in its self is very easy and achievable.
But there is a second requirement, the requesting team then want this/these people to only be highlighted if they have a Recurring Element in the "Payroll" - "Element Name" field.We have tried various different computations and realignments, also going onto Advanced Tab and then to apply sql after the relevant marker has been ticked. And still no joy. There are a minimum of 6 subfolders that match the SA's together as well.
It always errors with this "No fact table exists at the requested level of detail"
Any advice please,
Thank you
Topic posted February 9, 2017 by Andy Gough, tagged Fusion Procurement reporting, OTBI, Reports, Sample Reports in Reporting and Analytics for ERP publicTitle:Open Purchase Orders & Goods Received Not Invoiced reportsSummary:Various OTBI reports showing Open Purchase Orders & Goods Received Not InvoicedContent:Import the attached catalog files into your environment using the "Unarchive" command from the OTBI catalog page
Image:
Document:Document:Document:Document:- Topic posted February 9, 2017 by Aaron Leggett, tagged Analyses, BI Publisher Data Models, Customizing Reports, Data Models, OTBI, Public Sector, Reports, Setup/Administration in General OBIEE publicTitle: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 containing highly sensitive information when the report was created via a data model. When they try to run a sensitive report via OTBI (analysis), they get an error and can't run it - as we expect.
Ideally, we don't want accounts with just the employee role to even see the contents of certain folders. For instance, we don't want a regularly person in consultancy to be able to see all the names of the reports in the Shared > Custom > Human Capital Management folder. We only want the Human Capital Management folder to be shown to people with the right roles, let alone employees seeing the names of the reports and being able to run some of them.
Any help/advice is appreciated!
Aaron
Topic posted February 8, 2017 by Robin O'Connor
, tagged Analyses, OBIEE Answers, OTBI, Report Output, Reports in General OBIEE publicTitle:Any way to bypass the row LimitationSummary:Bypass Row LimitationContent:Is there anyway to bypass the row limitation? There are times I need to be able to analyze more than 25,000 rows of data. This is causing a lot of work to divide reports up to be able to get to all of the information needed.
- Topic posted February 8, 2017 by Aaron Leggett, tagged Analyses, Core HR, OBIEE Answers, OTBI, Public Sector, Reports in General OBIEE publicTitle: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 Management - Work Relationship Real Time subject area. I have looked in all the folders and I would expect it to appear under Work Relationship Details, next to Termination Date but it doesn't.
Any idea where it could be held?
Thanks
Image: