Build It, Dream It: Self-Service Dashboard

September 12, 2019 Jeff Hainsworth

By popular request, this video provides a step-by-step walk-through on how to build an a-la-carte style self-service dashboard for your users in Dundas BI. It is expected in this video that you already understand the basics of Dundas BI before proceeding.

If you're interested in using the scripts I've used in the video, feel free to acquire them from below: 

script 1: - Data table - onclick

// Hit test the table to see what was clicked
var args = dundas.Utility.getAdapterHitTestArguments(e.originalEvent, table1);
var rowIndex = table1.control.hitTest(args.offsetX, args.offsetY, args.target).rowIndex;
var dashboardName = table1.metricSetBindings[0].dataResult.cellset.rows[rowIndex].members[0].caption;
var dashboardId = table1.metricSetBindings[0].dataResult.cellset.rows[rowIndex].members[1].caption;

// Update the parameter to save what was selected
var canvasService = this.getService("CanvasService");
var viewParameter = canvasService.canvasAdapter.control.viewParameters[window.selectedPanel]; 

// Use the stored 'Selected Panel' to determine the parameter to set
viewParameter.parameterValue.values[0].uniqueName = dashboardId+".Id";
viewParameter.refreshAllAdapters();
viewParameter.invalidateParameterValueLastModifiedTime();

Script 2: Data Label - On Data Changed

var dashboardId = this.metricSetBindings[0].dataResult.cellset.rows[0].members[1].caption;
dashboardId = dashboardId.toLowerCase();  

// Needed otherwise the SubCanvasViewContainer, fails to load.
subCanvasViewContainer1.setTarget(dashboardId, dundas.entities.ViewType.DASHBOARD);

Script 3: Ready Interaction

subCanvasViewContainer1.loadData();
subCanvasViewContainer2.loadData()

About the Author

Jeff Hainsworth

Jeff Hainsworth is a Senior Solutions Architect at Dundas Data Visualization with over a decade and a half of experience in Business Intelligence. He has a passion for building, coding and everything visual – you know, shiny things! Check out "Off the Charts... with Jeff", his platform for great content on all things analytics, data visualizations, dashboards, and business intelligence. There’s something for everyone!

More Content by Jeff Hainsworth
Previous Video
Leverage the REST API in Dundas BI for External Administration
Leverage the REST API in Dundas BI for External Administration

In this video, we explore how you can identify and use a REST API inside Dundas BI to perform application f...

Next Video
KPI 101 - The Basics
KPI 101 - The Basics

In this video, we talk about some of the key terminologies around Key Performance Indicator (KPI) theory. W...

×

What else would you like to see?           Suggest a video!

First Name
Last Name
Company Name
Comments
I consent to receive commercial electronic messages from Dundas regarding products, services, updates and other information about Dundas. You can withdraw your consent at any time.
I Agree
Thank you!
Error - something went wrong!