OBIEE send different report to different user using ibot — Oracle Analytics

Oracle Analytics Cloud and Server

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

OBIEE send different report to different user using ibot

Received Response
123
Views
15
Comments
user2461087
user2461087 Rank 1 - Community Starter

Hi ,

We have a dashboard which depicts information about performance of employees . Now i want to send this performance dashboard to managers to review their subordinates performance. We want to automatically filter reports on Manager name so he gets information related to his subordinates .    

None of the users who will be receiving reports are OBIEE user.

I was wondering if anyone has done this before.

Regards,

S

«1

Answers

  • Hi,

    user2461087 wrote:None of the users who will be receiving reports are OBIEE user.

    So you send to email addresses directly?

    There is unique and single way to do that: as many agents (ibot) as you have managers. As many dashboards as you have managers.

    Each dashboard will need to have the filter hardcoded, and so you need an agent for each one of the dashboard to send it out to a single person.

    The only way to make it dynamic with a single dashboard and agent is by having these managers receiving the report as OBIEE users, and by building your dashboard to automatically filter based on the user (so login or session variable you set at the login etc.) and executing the agent not with a unique generic account (specified user) but by setting it to run as recipients.

    No other options (already asked and that's how the tool work, and it totally make sense)

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    Hi,

    Go through concept of SA Subject Area, which should help achieve your requirement.

    https://docs.oracle.com/cd/E28280_01/doc.1111/e18562/sa_system.htm#BIESJ3137

    Thanks and Regards,

    Syed Hamd Salman

  • user2461087 wrote:None of the users who will be receiving reports are OBIEE user.

    SA subject area can't help at all ...

    This appendix describes setting up the SA System subject area to retrieve user information from a database and populate user profile information. Oracle BI Presentation Services delivers alerts from Oracle BI Delivers to specified e-mail addresses, phone numbers, and so on. These delivery destinations are stored in the Oracle Business Intelligence profile for each user. In some cases, you might want to automatically populate the phone numbers or e-mail addresses in user profiles.
  • Vipulbhatia29
    Vipulbhatia29 Rank 2 - Community Beginner

    Hi Gianni

    We actually implemeted the exact same logic actually with a report using SA subject area approach to send a filtered report to a number of users that were external to obiee.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    You send to external users using SA Subject? How?

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    With SA system it will actually configure a delivery profile for each user.

    You can try creating generic user groups in weblogic and assign Delivery lists to those groups and use session variable in dashboard prompt and run as recipient in ibots.

    Thanks

    Aj

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    Hello Gianni,

    I remember implementing the same for on of the customer , something similar to discussed in below blog:

    Complete Business Intelligence Solutions: How to Send ibots/Agents to Non-OBIEE users


    Thanks and Regards,

    Syed Hamd Salman

  • Hi Syed,

    Delivering an agent to external users is easy and supported without any kind of SA or setup or conditional analysis: simply enter the email addresses as recipients in the agent, done !

    But how do you send from a single agent different content to different users which are just email addresses?

    That's the impossible part!

    @user2461087 : still here around or not really looking at this thread anymore?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    @Syed Hamd Salman How does that blog post say anything about how to send to "non-obiee users"? Where does the data come from? Magic?

    Also: If you propose this you are aware that this will actually "win" over any other solution you have, right?

    Some comments on why you propose this as a solution and how and why this would be highly appreciated.

  • user2461087
    user2461087 Rank 1 - Community Starter

    I thought same but making over 100 dashboards specifically for each user was something I was trying to avoid . I was hoping there would some work around it which i am unaware of.

    Thanks for help.