Working with Agents - OTBI - Help needed — Oracle Analytics

Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Working with Agents - OTBI - Help needed

Received Response
384
Views
17
Comments
Dudi Levi
Dudi Levi Rank 2 - Community Beginner
in Oracle Transactional Business Intelligence

Summary

I've setup an agent to deliver a report via E-mail... I tried everything but report is being delivered with no results:

Content

Hi,

I've setup an agent to deliver a report via E-mail (as an attached excel file)... I tried everything but report is being delivered with no results\:

BTW when I'm running the report from app it works just fine.

Any suggestions?

Regards,

Dudi

«1

Answers

  • Linda Stelling-2166
    Linda Stelling-2166 Rank 1 - Community Starter

    Hi Dudi

    I am just wondering if you have any conditions specified in the agent that are maybe knocking the results out when the agent is running the report?

    Linda

  • Dudi Levi
    Dudi Levi Rank 2 - Community Beginner

    Hi Linda, Thanks 4 ur response.
    There is no use in conditions on that agent...
    I've just setup a schedule for it to run, I chose the analysis that it supposed to send via email and I chose the email recipients.

    BR Dudi

  • Linda Stelling-2166
    Linda Stelling-2166 Rank 1 - Community Starter

    Hi Dudi, OK I am certainly no expert, but I have done the same in order to schedule reports to send me an email attachment based on the analyis, unless the condition isn't met; in which case an email just comes telling me no data to report. If you are not setting any conditions, and your attachment comes by email but it contains no data, the only other thing I would look at is 'Run as' setting on the General tab of the agent. It's my understanding that this looks at the security profile of the recipient so if they don't have visibility to see that data then no data will be shown on the delivered report.

    I may be wrong but that would be my next point of investigation. If you are running it as yourself with you as the recipient then clearly that won't be the answer !

    Regards

    Linda

  • Dudi Levi
    Dudi Levi Rank 2 - Community Beginner

    Thanks Linda, The problem is that I'm sending the report to my self as a test and I get no results...

    Many Thanks(:

    Dudi

  • Linda Stelling-2166
    Linda Stelling-2166 Rank 1 - Community Starter

    Ah, well then I have exhausted my knowledge. Sorry I couldn't help further.

    Linda

  • Dudi Levi
    Dudi Levi Rank 2 - Community Beginner

    Thanks Linda(:

    Promise to update when I'll find a solution for that issue(:

    BR Dudi

  • Michal
    Michal Rank 1 - Community Starter

    Hi Dudi, 

     

    Are you running a report or a dashboard in this agent?

    Is There any filter that is part of this report?

    When you run the report on the App, Does the filter (or the dashboard promt) has values?

     

    This might be another direction to go to.

     

    Michal 

  • Julian Challenger-Oracle
    Julian Challenger-Oracle Rank 6 - Analytics Lead

    Does your report produce results when you run it on it's own (i.e. not in the agent)?

    Please try creating the agent by locating the report in the catalog and clicking More and then Schedule.  Ensure Run As = Use Agent Owner's Credentials.  On the destinations tab, click Specific Devices and Email.  Don't change anything on any other tab.  Save the agent and click on the run icon.

    What did you receive?

  • Dudi Levi
    Dudi Levi Rank 2 - Community Beginner

    Hi All,

    Issue has been solved by changing security profile.

    Thanks,

    Dudi

  • Manjula K R
    Manjula K R Rank 2 - Community Beginner

    Hi All,

    I am getting an error stating "Agent Completed with warning" when try to run Agent with condition since i choose recipients from Analysis. But i am not getting any Email(Opted for Email Destination). The same works fine when i provide Email directly as recipients without condition.
    Could anyone please help me. Am i missing something?
    I have attached the screenshot FYR.

    Thanks