-
Forums
-
- Applications (SaaS)
-
Customer Experience
Customer Experience
DashboardB2C Service
Field Service
Marketing
-
Human Capital Management
Human Capital Management
DashboardTalent Management
HCM ANNOUNCEMENT: Deadline Approaching Responsive UX - Urgent Action Required! -
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
Forums
Use our discussion forums to pose questions, explore ideas, and discuss Oracle Applications. -
-
Ideas
-
- Applications (SaaS)
-
Customer Experience
Customer Experience
My IdeasCustomer Experience
-
Human Capital Management
Human Capital Management
My Ideas -
Enterprise Resource Planning
Enterprise Resource Planning
My Ideas -
Supply Chain Management
Supply Chain Management
My Ideas -
Reporting and Analytics
Reporting and Analytics
My IdeasReporting and Analytics
-
More
More
My IdeasPublic Sector
Oracle Education
-
Platform (PaaS)
Platform (PaaS)
My Ideas
Ideas
Share your ideas on product enhancements, vote, and comment on your favorite ideas. -
-
Events
-
Events
Sales and Service
Human Capital Management
-
- Contribute
- Hall of Fame
- Learning
- Success
- Documentation
- Support
Posts
Posts
- 1-4 of 4
Topic posted August 3, 2018 by Naveen BITRA
, tagged BI Publisher, Compensation, OBIEE Answers, OTBI, Report Delivery, Reports, Setup/Administration in General OBIEE publicTitle:OTBI Reports - Disable Excel optionSummary:Can we hide 'Excel 2007' option under Export for OTBI reportsContent:Hello All - We have an issue with downloading OTBI reports to Excel. it doesn't download all rows and truncates after reaching a limit. However, CSV works fine. To avoid this, we did like to disable/hide 'Excel 2007' option under Exports so that users use only CSV. Is it possible to do this for OTBI reports?
Image:
- Topic posted July 5, 2017 by Giuseppe Botta
, tagged Analyses, BI Publisher, BI Publisher Data Models, Compensation, OTBI, Report Output, Reports, SQL in General OBIEE publicTitle:Calculate Yesterday date based on CURRENT_DATE variableSummary:Calculate Yesterday date based on CURRENT_DATE variableContent:Hello,
how do I could calcolate obtain yesterday date based on current_date field in an OTBI analysis, to use it in a where clause for example?
ex "...WHERE "Compensation Person Worksheet Details"."Worksheet Last Update Date" < CURRENT_DATE-1" (not working)
Thank you in advance
- Topic posted June 14, 2017 by Brenda Jacks, tagged Analyses, Compensation, Core HR, Customizing Reports, Data Models, Fusion, OBI Answers, OBIEE Answers, OTBI, SQL in General OBIEE publicTitle:How to do MAX Date Logic less than Prompted AsOfDate in AnalysisSummary:Trying to get the maximum Salary Change Date in OTBI AnalysisContent:
I am trying to convert a filter to SQL to get the maximum Salary Change Date that is less than or equal to a prompted AsOfDate in an OTBI Analysis. Here is the filter I am using:
"Compensation - Salary History Details Real Time"."Salary Details"."Salary change date" =
SELECT MAX("Compensation - Salary History Details Real Time"."Salary Details"."Salary change date")
FROM "Compensation - Salary History Details Real Time"
WHERE "Compensation - Salary History Details Real Time"."Salary Details"."Salary change date" <= '@{AsOfDate}{@{system.currentTime}[YYYY-MM-DD]}'I'm getting error getting drill information and wondering how I can fix this? I have attached the catalog.
Thank you!
Brenda
Document: 
Topic posted December 28, 2014 by Gal Shani, tagged Compensation, OBIEE Answers, OTBI, Reports in General OBIEE publicTitle:Duplicate rows in OBIEE reportsContent:Hi,
Tried to eliminate the duplicate rows with the usual way (see attached screenshots), but it's seems this is not working on calculated field ('new salary', 'prior salary', etc'..).
If someone can share his knowledge regarding this issue this will be very useful.
Thanks,
Gal.
Image:
Document:2014-12-28_1709_001.png (25KB)