-
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
Topic posted March 21, 2019 by Kristy Bartnes
, tagged Customizing Reports, Reports, Scheduling or Agents in General OBIEE publicTitle:Report LogContent:Anyone have an xml they would be willing to share or recommendations for creating a 'master' report that returns a list of all the BI reports in order to audit and clean up what has been created over the last couple of years. A few primary details I am needing to include are the report name, location of report, and if it is scheduled - who the recipients are (if possible) and last date report was run (again, if possible). Thank you in advance for any assistance/advice you are able to provide.
Topic posted March 5, 2019 by Stephanie Gott
, tagged BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Report Delivery, Report Output, Reports, Scheduling or Agents in General OBIEE publicTitle:Published Report Schedule - showing message if attachment has nothingSummary:If the published report attachment has no data, can we put that in the body of the message?Content:Hello,
For a personal BIP report schedule, if the attachment has no data on it, is there a way to call that out in the body of the email message to the user? We find that users are opening reports that have no data unnecessarily. Some days the report will have data, sometimes it might not and that could be valid. If there is a way to show the user that they don't need to open the attachment because it doesn't contain data, that would be great. Any thoughts?
Thanks,
Stephanie
Topic posted February 13, 2019 by Senthilrajan Vaithianathan
, tagged Analyses, BI Publisher, BI Publisher Data Models, Customizing Reports, Data Models, Fusion, OBI Answers, OBIEE Answers, OTBI, Report Delivery, Reports, Scheduling or Agents, Upgrades in General OBIEE publicTitle:New features - BICCC 19A patchSummary:Document for new features list in BICCC - 19A patchContent:New features has been added to BICCC Application as part of 19A patch, it is very good, but it will be helpful if we get some document from Oracle explaining the new features within BICCC for every major releases in Advance, Now I am looking for 19A patch new features list for BICCC. let me know if any of you have come across such documentation for BICCC.
Topic posted December 27, 2018 by Kingsley
, tagged Analyses, BI Publisher, OBI Answers, OBIEE Answers, OTBI, Report Delivery, Report Output, Reports, Scheduling or Agents, Setup/Administration, Tip in General OBIEE publicTitle:OTBI: OTBI Agent with SFTP DestinationSummary:How to Setup OTBI Agent to export report results to SFTP ServerContent:Hello All,
I have a request to export the result output of an OTBI report to an SFTP server on a daily basis. Unfortunately the delivery Agent for scheduling OTBI reports does not have the FTP as a Destination option. Has anyone some Ideas on how I can go about this? your contributions are highly appreciated.
Regards
Kingsley
Topic posted October 19, 2018 by Matthew Voss, tagged Core HR, Fusion, OBIEE Answers, OTBI, Reports, Scheduling or Agents in General OBIEE publicTitle:Current Timestamp Not Updating on OTBI ReportContent:Hello,
I'm currently building an HCM Report where it looks at the Timestamp of the change (Hire/Term/etc.) and subtract 1 minute from that timestamp. Then I was hoping to run an agent every minute to pick up any changes in the last minute. I am trying to use the below filter, but when I run the report the CURRENT_TIMESTAMP does not update every time the report/agent runs. When I run the report normally it has the Timestamp of the last time I edited the report, but if I refresh on the bottom of the report it will pull the current timestamp. Below is the filter I'm trying to use and the HCM Post I created, I've also attached the related XML.
Does anyone have any advice on how to make the current_timestamp update every time the report is run or scheduled to run?
Filter
"Assignment Event Details"."Assignment Creation Date" > TIMESTAMPADD(SQL_TSI_MINUTE, -1, CURRENT_TIMESTAMP)
HCM Report Post
Document:- Topic posted September 7, 2018 by Kingsley, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Customizing Reports, Data Models, Fusion, Fusion Performance Mgmt, OBI Answers, OBIEE Answers, OTBI, Report Delivery, Report Layouts, Report Output, Reports, Sample Reports, Scheduling or Agents, SQL in General OBIEE publicTitle:List of OTBI inefficient ReportsSummary:looking for was to monitor OTBI reports performance and Frequency of useContent:
Hi All,
I am looking for ways to monitor the performance of OTBI Reports in fussion cloud environment. We have BIP and OTBI reports that are running poorly and I wish to find out how I can do that. Admin session mager provides the cursor cache where I can see the OTBI report run-time, logs and path but this information is only held for a very short time in the production environment.
Has anyone an idea on how i can get this information for a time period of over a month?
- Report name with path
- Runtime
- Execution time and date
Thanks
Kingsley
Version:R13 - 18B 
Topic posted September 5, 2018 by Juan Miguel Isip, tagged BI Publisher, Discussion Forums, Fusion, OBI Answers, OBIEE Answers, Report Delivery, Scheduling or Agents, Setup, Setup/Administration in General OBIEE publicTitle:Use ESS to run a BI Publisher job that transmits reports via SFTPSummary:Is it possible to use ESS execute a BI Publisher job will transmits reports via SFTP?Content:We have built some Custom Reports in BI Publisher that extract data to a CSV file using a simple SQL script.
This is scheduled running every hour and automatically transmits the file to a vendor's SFTP Server.However, I'm wondering if its possible to call these jobs from the Enterprise Scheduler (ESS) so that we can maintain it from there?
Is this possible? I don't see any option for ESS jobs to transmit reports to a external SFTP server.Please advise.
Version:Oracle Business Intelligence Publisher Enterprise
Topic posted June 27, 2018 by Stefan Orac
, tagged Reports, Scheduling or Agents in General OBIEE publicTitle:CSV Export with limited range of measures/columnsContent:I have created an analysis on employees that works very well for HR reporting.
Due to the fact that I combine multiple subject areas I have entered several measures as well that are not necessary for the final (exported) output. I usually exclude the columns I don't need in the view edit and it works perfect for xls, pdf, exports.
Whenever I run a CSV- export with the same data however I get the whole set of infomation exported, including all columns that I had excluded. How can I reduce my CSV-export to the same amount of information as it is in the other exports?I guess it is a really easy step, but I couldn't find the right trigger so far.
Thanks for all information in advance.
BR
Stefan
Topic posted June 18, 2018 by Laura Robles, tagged OBI Answers, OBIEE Answers, Report Delivery, Report Output, Reports, Scheduling or Agents in General OBIEE publicTitle:Password Protect OBIEE AgentsSummary:Password Protect OBIEE AgentsContent:Hello,
Any ideas on how to protect reports that are scheduled?
Thanks!
- Topic posted May 4, 2018 by Linda Stelling, tagged Analyses, OBI Answers, OBIEE Answers, OTBI, Reports, Scheduling or Agents in General OBIEE publicTitle:Prefix - set effective date using SQL ExpresssionContent:
Hello - I'm hoping someone can help me with this please.
I have an OTBI analysis that I want to schedule on the first of each month that will show changes in the previous month. One of the 'changes' could be that the record has been ended but because the because the subject area is a Real Time one (Payroll - Element Entries Real Time) the record is no longer current when the report is being run so it will not report the change.
Therefore, I am wondering if I could include the SQL expression below (to get to the 1st of the previous month) in the prefix to set the effective date to be the 'first of the previous month'.
TIMESTAMPADD(SQL_TSI_MONTH, -1, TIMESTAMPADD(SQL_TSI_DAY, DAYOFMONTH(CURRENT_DATE) * -(1) + 1, CURRENT_DATE))
I hope that makes sense and if someone can help me do this I'd be very grateful. I tried several different ways to add this to the Prefix with no success so I think it might be a syntax issue, or maybe it's just not possible to do this?
Many thanks
Linda