General OBIEE

Get Involved. Join the Conversation.

Posts

  • Kristy Bartnes
    Report Log85.0
    Topic posted March 21, 2019 by Kristy BartnesGreen Ribbon: 100+ Points, tagged Customizing Reports, Reports, Scheduling or Agents 
    Title:
    Report Log
    Content:

    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.

  • Stephanie Gott
    Published Report Schedule - showing message if attachment...
    Topic posted March 5, 2019 by Stephanie GottSilver Medal: 2,000+ Points, tagged BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Report Delivery, Report Output, Reports, Scheduling or Agents 
    Title:
    Published Report Schedule - showing message if attachment has nothing
    Summary:
    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

  • Senthilrajan Vaithianathan
    New features - BICCC 19A patch
    Topic posted February 13, 2019 by Senthilrajan VaithianathanBronze Trophy: 5,000+ Points, 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 
    Title:
    New features - BICCC 19A patch
    Summary:
    Document for new features list in BICCC - 19A patch
    Content:

    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.

     

  • Kingsley
    OTBI: OTBI Agent with SFTP Destination35.0
    Topic posted December 27, 2018 by KingsleyRed Ribbon: 250+ Points, tagged Analyses, BI Publisher, OBI Answers, OBIEE Answers, OTBI, Report Delivery, Report Output, Reports, Scheduling or Agents, Setup/Administration, Tip 
    Title:
    OTBI: OTBI Agent with SFTP Destination
    Summary:
    How to Setup OTBI Agent to export report results to SFTP Server
    Content:

    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

  • Matthew Voss
    Current Timestamp Not Updating on OTBI ReportAnswered85.0
    Topic posted October 19, 2018 by Matthew VossBronze Trophy: 5,000+ Points, tagged Core HR, Fusion, OBIEE Answers, OTBI, Reports, Scheduling or Agents 
    Title:
    Current Timestamp Not Updating on OTBI Report
    Content:

    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

    https://cloudcustomerconnect.oracle.com/posts/cea6e1d921

  • Kingsley
    List of OTBI inefficient Reports55.0
    Topic posted September 7, 2018 by KingsleyRed Ribbon: 250+ Points, 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 
    Title:
    List of OTBI inefficient Reports
    Summary:
    looking for was to monitor OTBI reports performance and Frequency of use
    Content:

    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
  • Juan Miguel Isip
    Use ESS to run a BI Publisher job that transmits reports via...75.0
    Topic posted September 5, 2018 by Juan Miguel IsipSilver Medal: 2,000+ Points, tagged BI Publisher, Discussion Forums, Fusion, OBI Answers, OBIEE Answers, Report Delivery, Scheduling or Agents, Setup, Setup/Administration 
    Title:
    Use ESS to run a BI Publisher job that transmits reports via SFTP
    Summary:
    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
  • Stefan Orac
    CSV Export with limited range of measures/columnsAnswered11
    Topic posted June 27, 2018 by Stefan OracBronze Medal: 1,250+ Points, tagged Reports, Scheduling or Agents 
    Title:
    CSV Export with limited range of measures/columns
    Content:

    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

  • Laura Robles
    Password Protect OBIEE Agents4
    Topic posted June 18, 2018 by Laura Robles, tagged OBI Answers, OBIEE Answers, Report Delivery, Report Output, Reports, Scheduling or Agents 
    Title:
    Password Protect OBIEE Agents
    Summary:
    Password Protect OBIEE Agents
    Content:

    Hello,

    Any ideas on how to protect reports that are scheduled?

    Thanks!

     

  • Linda Stelling
    Prefix - set effective date using SQL Expresssion2
    Topic posted May 4, 2018 by Linda StellingSilver Medal: 2,000+ Points, tagged Analyses, OBI Answers, OBIEE Answers, OTBI, Reports, Scheduling or Agents 
    Title:
    Prefix - set effective date using SQL Expresssion
    Content:

    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