Oracle Analytics Cloud and Server

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

Sending Emails Directly from a Dashboard in OBIEE 11g

Received Response
462
Views
5
Comments
Rank 2 - Community Beginner

Hi Oracle Community,

Can anyone assist me. I have a report that uses a Usage Tracking to get all users that are using a specific dashboard. When we make changes to the path of the dashboard, we want to notify users of the new path or dashboard name. Now this report has email address in it, now we want to have a way to click to Send Email button or link and this should add all the email address in this report to the email client.

Almost similar to this link here but this should attache all the email list.

The version of is Oracle Business Intelligence Product Version 11.1.1.9.0 (Build 150415.1247 64-bit)

Please see the attached screenshot.

Thank you

Lerata Motaung

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 1 - Community Starter

    Hi,

    i might not give you an accurate procedure to do it. But as per my understanding of your question, you can use a condition report and use the result of this condition report as the recipients.

    lets say you have report with user email address as shown in your screen. you will add that report to the condition

    pastedImage_0.png

    and then add your delivery content of what ever you would require.

    Lastly for the recipients you will need to select the recipients from the conditional report which is on the right side.

    pastedImage_1.png

    this should work for both 11g and 12c. Give a try and let us know.

    hope this helps.

    -Naga

  • Hi,

    It's actually a simple extension of the one you linked ....

    To have a link which open a mail with multiple recipients the only difference is that instead of <a href="mailto:user1@email.com">link</a> you must add the recipients separated by a " , " without spaces in between. So something like <a href="mailto:user1@email.com,user2@email.com,user3@email.com">link</a> .

    To get that from your analysis the simplest is to add a narrative view to your analysis to concatenate the email addresses together.

    Of course replace @1 by the right number (@2, @3 etc.) to match the column of your analysis containing the email. To easily check syntax uncheck the "contains html markup" first so you see the HTML code and when it looks good you check this checkbox again to make it working.

    Capture.PNG

  • Rank 2 - Community Beginner

    Hi Gianni, Thank you!! This is what I was looking for. Thanks to Nega as well for providing an alternative direction. Thank you gents.

  • Rank 1 - Community Starter

    HI Dears ,

    I have dashboard and I want to schedule it as link instead of attachment (how can I do that - I want receipts to receive an email with link which will take them to dashboard

    instead of sharing attachment)

  • @User_09N8L ,

    Do not randomly post in 6 years old threads that aren't even related to your question.

    If you don't already have a thread open for that, start a new one (but no double posting).

Welcome!

It looks like you're new here. Sign in or register to get started.