Automate Cross-Dataset Filtering with Connected Data Sources

The selection binding techniques area already available in the Wave Analytics but it can be done only by using JSON. Now, without writing any piece of JSON code, we can easily bind more than one different dataset by using Connected Data source. Let’s see how to bind two different datasets using Data Source Connection.

Overview 

The selection binding techniques area already available in the Wave Analytics but it can be done only by using JSON.  Now, without writing any piece of JSON code, we can easily bind more than one different dataset by using Connected Data source. Let’s see how to bind two different datasets using Data Source Connection.

Step1:

Dataset 1- Create a lens named “Filter by Forecast Category for Opportunity” by clicking on the Opportunity Dataset.

Click on the Group option and select Forecast Category Name field to group the picklist value.

cross dataset filtering
  1. Can view the specific record count based on the Forecast Category Field values. Finally, save the lens with the name of Filter by Forecast Category for Opportunity.
  2. Select the App already created in Wave Analytics. If we select the Private App, then it’s not visible to all the users but only the owner has access for it.
  3.  Shared App is visible to all users available in the organization.
cross dataset filtering

Click on the Icon to use this lens in new dashboard. Provide Display label name as ‘Opportunity Lens ‘and Click on the Clip to Designer.

cross dataset filtering

This lens is automatically added to the new dashboard under all step.

cross dataset filtering

Step 2:

Dataset 2 – Create a lens named “Filter by Forecast Category for OppProduct” by clicking the Products Opportunity Dataset and group the Opportunities ForecastCategoryName field.cross dataset filtering

Choose the shared App to store this lens inside the app.

cross dataset filtering

Click on  Icon to use this lens in new dashboard. Provide Display label name as ‘Opportunity Product Lens ‘and Click on the Clip to Designer.

cross dataset filtering

After the Clip to Designer is clicked, this lens will also be automatically added to the new dashboard.

cross dataset filtering

Step 3:

The following need to be added in the New Dashboard.

  1. Click on the Number list and drag and drop the Opportunity lens.
  2. Click on the Chart and drag and drop the Opportunity lens.
  3. Click on the chart and drag and drop the Opportunity Product Lens.
cross dataset filtering

Step 4

In the right side of the Dashboard page, click on the Icon and select the Connect Data Sources.

cross dataset filtering

After clicking the Connect Data Sources Option, it will redirect to the following page.

cross dataset filtering

Step 5

Click the New Connection button to establish a connection between two difference Datasets and provide label name as ‘Connection Between Opportunity & OpportunityProduct’.

cross dataset filtering

Step 6

Choose Data Source 1 and select the Opportunity Dataset.

cross dataset filtering

Step 7 – Select the common key in both Different dataset.

Select the ForecastCategoryName from Opportunity Dataset.

cross dataset filtering

Step 8

Choose Data Source 2 and Select the Products Opportunity Dataset.

cross dataset filtering

Step 9

Select the Opportunities ForecastcategortyName from Products Opportunity Dataset.

cross dataset filtering

Step 10

Click on the Save button to commit the connection. Now, the connection has been established between the Opportunity and Product Opportunity Dataset with the common key as “ForecastCategoryName”.

cross dataset filtering

After the Save Button is clicked, it will redirect to the following detail page of the connection.

cross dataset filtering

Step 11

Finally, Save the dashboard with the appropriate name and description.

cross dataset filtering

Step 12

Before Creating Data Sources Connection:

  1. Here, the Best case and Omitted are selected in the Opportunity Picklist value drop-down list.
  2. Now, the Opportunity chart only highlights the specific record count and Opportunity Product chart doesn’t highlight the specific value rather it would highlight every picklist since it doesn’t have any connection between Opportunity and Opportunity Product.
cross dataset filtering

Step 13

After Creating Data Sources Connection:

  1. If we select the Opportunity Picklist value (Omitted & Best Case) in dropdown list, the corresponding picklist value’s record count will be highlighted in both Opportunity and Opportunity Product Chart.
cross dataset filtering

Advantages 

  1. This can be easily achieved by point and click without writing any code.
  2. Takes less time to develop.
  3. Can create more than one connection for different datasets.
  4. Can maintain consistency across the dataset in organization.

Summary 

  • We have implemented the cross filter across different dataset in the organization with the help of Connection Data Sources Feature. Now, we can easily bind or link two different datasets without writing any code.

Reference Link:

https://releasenotes.docs.salesforce.com/en-us/spring17/release-notes/rn_bi_dashboards_connected_data_sources.htm?edition=&impact

About MST

At MST Solutions our cornerstone is to adapt, engage and create solutions which guarantee the success of our clients. The talent of our team and experiences in varied business verticals gives us an advantage over other competitors.

Recent Articles

Work with us.

Our people aren’t just employees, they are key to the success of our business. We recognize the strengths of each individual and allow them time and resources to further develop those skills, crafting a culture of leaders who are passionate about where they are going within our organization.