For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
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?
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
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
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.