none
Send email through cube actions

    Question

  •  

    Hi,

     

    Is there any Technet demo or walkthrough available explaining the actions in SSAS cube?

     

    I have a customer dimension. My requirement is to send email to customer when I click or right click on a particular customer while browsing the cube. I’m not sure if it’s feasible in SSAS 2005.

     

    Appreciate any further help!

     

    Thanks,


    - JL
    Wednesday, February 25, 2009 2:24 PM

Answers

  • Actions are pretty straightforward to create. What is your client tool you're using to browse the cube? If it's Excel 2007, then you'll be OK.

    However, creating an action to launch an email client is a bit tougher nut to crack. I would have thought you could create a URL action with a mailto link, but, as the warning in BIDS said when I created that, any link that doesn't start with HTTP or HTTPS is considered "unsafe" so most clients (including Excel 2007) block them. That being the case, we'll need to create an HTTP link action that somewhat accomplishes what you want.

    Your standard HTTP action would have the following properties set in BIDS:

    Name: Email Customer
    Target type: Attribute members
    Target object: Customer.Email Address
    Type: URL
    Action expression: <see below>
    Invocation: Interactive
    Caption: "Email " + [Customer].[Email Address].CurrentMember.Name
    Caption Is MDX: True

    So the question is what you use for the "Action expression" property.

    One option would be to launch a "compose a new email" window in Outlook Web Access. You could create a link like: https://mail.yourcompany.com/owa/?ae=Item&t=IPM.Note&a=New&to=email@domain.com&rt=SMTP
    So the expression for that would be:
    "https://mail.yourcompany.com/owa/?ae=Item&t=IPM.Note&a=New&to=" + [Customer].[Email Address].CurrentMember.Name + "&rt=SMTP"

    The downside to that is that you have to sign in ever time.

    Or you could build a webpage that "clicks" a mailto link for you. A webpage such as the following works:
    <body onload="document.links[0].click()">  
    <href="mailto:email@domain.com">mail</a> 
    </body> 
    So you would have to build an ASPX page that would accept a URL parameter and dynamically build that page.

    That's the best I can come up with. Hope that helps.

    If anyone else has other suggestions, please post them!

    http://artisconsulting.com/Blog/GregGalloway
    • Marked as answer by JiLu Thursday, February 26, 2009 10:08 AM
    Wednesday, February 25, 2009 4:15 PM

All replies

  • Actions are pretty straightforward to create. What is your client tool you're using to browse the cube? If it's Excel 2007, then you'll be OK.

    However, creating an action to launch an email client is a bit tougher nut to crack. I would have thought you could create a URL action with a mailto link, but, as the warning in BIDS said when I created that, any link that doesn't start with HTTP or HTTPS is considered "unsafe" so most clients (including Excel 2007) block them. That being the case, we'll need to create an HTTP link action that somewhat accomplishes what you want.

    Your standard HTTP action would have the following properties set in BIDS:

    Name: Email Customer
    Target type: Attribute members
    Target object: Customer.Email Address
    Type: URL
    Action expression: <see below>
    Invocation: Interactive
    Caption: "Email " + [Customer].[Email Address].CurrentMember.Name
    Caption Is MDX: True

    So the question is what you use for the "Action expression" property.

    One option would be to launch a "compose a new email" window in Outlook Web Access. You could create a link like: https://mail.yourcompany.com/owa/?ae=Item&t=IPM.Note&a=New&to=email@domain.com&rt=SMTP
    So the expression for that would be:
    "https://mail.yourcompany.com/owa/?ae=Item&t=IPM.Note&a=New&to=" + [Customer].[Email Address].CurrentMember.Name + "&rt=SMTP"

    The downside to that is that you have to sign in ever time.

    Or you could build a webpage that "clicks" a mailto link for you. A webpage such as the following works:
    <body onload="document.links[0].click()">  
    <href="mailto:email@domain.com">mail</a> 
    </body> 
    So you would have to build an ASPX page that would accept a URL parameter and dynamically build that page.

    That's the best I can come up with. Hope that helps.

    If anyone else has other suggestions, please post them!

    http://artisconsulting.com/Blog/GregGalloway
    • Marked as answer by JiLu Thursday, February 26, 2009 10:08 AM
    Wednesday, February 25, 2009 4:15 PM
  • Hi,

    I found cube actions working in SQL Management studio only. Cube actions are not working in reporting services 2005 and OWC 11. Which client tool should I use to make it working?

    Thanks.




    - JL
    Tuesday, March 17, 2009 12:37 PM