16 June 2017

How to Customize Your Report Downloads Dashboard

Attention all security folks! How to monitor data exports from cloud applications is always popular topic amongst security teams.

With Event Monitoring and Salesforce Shield, customers can closely follow these activities in form of Event Log Files and Transaction Security Policies. With Event Monitoring Wave App, customers can further visualize who's downloading data (exporting reports).

Event Monitoring Wave App already includes the out of the box denormalization from UserIDs to Usernames but with three simple steps you can also denormalize and update your Report Downloads dashboard to include what reports your users are downloading.

Dennis Schultz, Principal Solution Engineer from Salesforce has worked on a short video that shows how to use Salesforce Wave Analytics Recipe feature to bring more Salesforce data into Wave and transform your dashboards to include Report Names just under 5 minutes.

How to add Report Names to the Report Dashboards with Salesforce Wave Analytics Recipes in 3 easy steps.


1. Create "Lookup" Dataset
  • From your Wave app environment click Create Dataset. 
  • Select Salesforce as the source and select Report object. Select fields e.g. Report ID and Report Name. Create the Dataset. 
  • To enable the integration between Wave Analytics and Salesforce, go to Data Manager to enable the default Salesforce Dataflow. Once finished, soon you'll see the dataset in your Wave environment. 
  • You can confirm you have the right information from the Values table.
2. Create a new Report Export Dataset with Recipe features
  • Go to Data Manager and select Prepare
  • Create Recipe and Select ReportExportWithUsers Dataset as the base to work with
  • Name your new Dataset "ReportExportWithReportNames"
  • Transform the table with the Lookup Dataset we created in Step 1 with Add Data Transform
  • Select URI_ID_Derived from the Base ReportExportWithUsers Dataset and Report ID from the new Lookup Dataset
  • Now specify you want the Report Name field to be included in the new Dataset
  • Finally create Dataset to run the Recipe
  • Run on scheduled to pick up new events daily
3. Update the Report Downloads Dashboards
  • Open the Report Downloads Dashboard
  • Make a Copy or Clone the Dashboard before continuing 
  • Rename the Dashboard "New Report Downloads" and Save
  • Open ReportExportwithReportNames DataSet
  • Group by Username and ReportName - some names might not be available e.g. User created a new report and deleted the report
  • Click the scissors to "Clip to Designer" the lense and Provide a name ReportExportWithNames 
  • Return to the New Report Downloads Dashboard and hold the Shift Key down and move the widget to the Dashboard
  • Save the Dashboard and Click the Eye button to view it
Please take a look at the video and leave comments or questions below: http://salesforce.vidyard.com/watch/SfuJDkrD9qmycyjgwcdiNS



Cheers, Jari

06 April 2017

Augmenting Salesforce Event Monitoring Datasets

Augmenting Salesforce Event Monitoring Datasets in Wave Analytics to understand in more detail what records your users have been viewing

In this short video Dennis Schultz, Principal Solution Engineer at Salesforce describes how you can use Event Monitoring for Adoption, Performance and Security analysis and specifically use the URI (PageView) dataset in the Event Monitoring Wave App with Wave's new Recipe capability (in Spring'17) augmented with entity type, turning the data set and visualization into more insightful and easier to use for human analyst consumption.



To enable your Event Monitoring Wave App, please visit the instructions in Salesforce Help & Training or to have Event Monitoring turned on to your Salesforce application, please get in touch with your Account Executive.

To get more familiar with Wave Analytics, see the these Trailheads training modules and to learn more about Salesforce Shield and Event Monitoring please capture these badges.

Please leave your questions and comments below! 

Cheers, Jari