Oracle Analytics Cloud and Server

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

iBot to run for a catalog group (recipient) and deliver to a single user E-mail in obiee 12c

Received Response
3
Views
4
Comments
3779545
3779545 Rank 1 - Community Starter

Hi,

I have a requirement to deliver an iBot which uses a catalog group of users as recipient and to deliver not the recipients but to a single user. In other words, running the ibot as the catalog group as there is data level security involved, and while running the ibot, we need to restrict not use the delivery profile of the recipients but to a single email id.

I tried different options:

1) Created a filter on user name column, gave multiple users and in ibot recipients tab selected weblogic and in weblogic delivery profile, updated the desired email in weblogic's delivery profile.

Result: It has delivered to the correct email but ran the report for the last user in the filter, not running for all the users in the filter.

2) Tried to run as Specified user in General tab. Thought of selecting multiple users as "specified user" and selecting a single user who need to receive all the reports (same report but run for multiple users with data level security) in Recipients tab

Result: Though a list of users added, it is running the delivers only for one time.

3) Using the customise option in Delivery Content tab, selected multiple users in user name prompted parameter (in delivery content customisation) and selecting a single user to receive the emails in recipient tab.

Result: Though multiple users selected (List of values), the ibot is running only once for one user.

Appreciate your thoughts and ideas to archive this functionality .

Thanks,

Anil.

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    You're probably better off looking at BI Publisher to achieve this. This is OOTB BI Publisher functionality rather than trying to reinvent the wheel with OBIEE delivers.

  • 3779545
    3779545 Rank 1 - Community Starter

    Hi Joel, thanks for your reply, I tried BIP as well, job history shows that the job has been completed successfully, but didn't receive any email, any suggestions ?

    Thanks,

    Anil.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner
    3779545 wrote:Hi,I have a requirement to deliver an iBot which uses a catalog group of users as recipient and to deliver not the recipients but to a single user. In other words, running the ibot as the catalog group

    Catalog Groups are outdated. Dead. Over. No longer supported and since 12.2.1.1 not even in the product anymore.

    Since 11g was released back in 2010 they were very clearly documented as being outdated with the hint that they should be removed and something more modern and appropriate u(and supported) in their place.

    It's now almost 10 years later which should have been enough time to digest this change,  move  prto a proper usage of the product and not stick to a leftover functionality from pre-10g days.

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

    @3779545 did you give up on this thread?