Using Browser Debugging Tools and a Neat Trick to Script (Video Tip)

When presented with an interesting scripting problem in Dundas BI, you can use the browser tools to help you understand what is going on. In this tip, I walk you through my mindset and show how I can use JavaScript to override the default behaviour.

Here is a completed sample that I created to test this.

Sample Script:

var overrideString = "{\"adapterId\":\"72099a99-b18d-5c23-9d45-7ebd291ec40b\",\"metricSetBindingId\":\"a641df4e-fb73-4fdf-9909-d388171444ea\",\"requestOverrides\":{\"__classType\":\"dundas.data.RequestOverrides\",\"isResultTransposed\":false,\"isTotalsAtBottom\":true,\"measureOverrides\":[],\"hierarchyOverrides\":[],\"sortPriorityOverrides\":[\"Continent\",\"Country\",\"Product\",\"Index\"],\"isTimeMemberSharingEnabled\":false,\"itemizeTotals\":false}}";
var overrides = JSON.parse(overrideString);
this.parentView.control.overrides.metricSetBindingOverrides = [overrides];
this.parentView.control.overrides.metricSetBindingOverrides[0].requestOverrides.sortPriorityOverrides = ["Product", "Country", "Continent", "Index"];
table1.loadData();

If you’d like to learn more, I’d recommend you go to my learning channel - Off the Charts (with Jeff).
https://www.dundas.com/resources/off-the-charts-tips-from-an-expert

8 Likes