DBI Cheats

#101

Luis thanks for sharing this.

I needed this but for showing a layer and also controled the parameter filter value based on what section of a pie chart was clicked.

#102

I made a little script on a No Data Action that goes back one time period.


// Get the parent view.
var parentView = this.parentView;
// Get the view parameters.
var viewParameters = parentView.control.viewParameters;
// Using the library, get the view parameter based on it's name
var viewParameter = this.parentView.control.getViewParameterByName("jvMetricMatLaborRevDateviewParameter");
//Go back one time period on offset
viewParameter.parameterValue.token.offset = viewParameter.parameterValue.token.offset -1;
viewParameter.invalidateParameterValueLastModifiedTime();
viewParameter.refreshAllAdapters();


At first this was really long, I was copying the token then clearing tokens and values then setting the token.

Turns out all that was need was to change the offset value.


This goes back one time period (what ever the level is set to) if that new one has no data it just keeps going untill it "Has Data".

#103

Here is a working link for that article:

https://www.dundas.com/support/support-center/support-articles/metric-sets/display-top-n-other-measures-using-data-cube-transforms

#104

This is amazing! Bookmarking this thread right away!

#105

Good idea! Very useful for many cases!

1 Like
#106

Cool ! We did a google like search in which we invented a key pressed event in JS :slight_smile:

1 Like
#107

Very cool and useful! Great idea!

#108

This forum thread is great, but I would like some way to organise it as it is unwieldy to find the piece that you want when you need it.

1 Like
#109

I completely agree, it need to be it own forum topic so that we can have a thread per tip or trick (or is it trick or treat today :scream::ghost:)

#110

If you hold down control when using the arrow keys, then it moves 10 pixels instead of the 1 when you don’t hold down control key.

1 Like
#111

Doesn’t work on osx Chrome

#112

This is all interesting but very unorganised as there are no categories or anything like that. hard to find things

#113

It should work on Chrome as well (at least it does for me). Can you confirm you are holding down the “ctrl” key and hitting the arrow keys? If indeed it doesn’t work with you then we can work with the support team to further investigate.

#114

I wish I could refute that, but you are correct! Unfortunately, when this thread was first created it was prior to our new User Forums structure, making it much more difficult to separate (and navigate) threads. Since there’s such a great wealth of knowledge in this thread, we felt it worthwhile to keep it (as cumbersome as it is) vs. removing it entirely.

That being said, it is now easier to search for the cheats within this thread using our new, advanced search functionality (you just may need to know what you’re searching for :wink:)

We’ve also separated our tips of the week into individual threads now so they are much easier to find. A great starting place as well is our business intelligence resources thread - we update this frequently with new content.

#115

Could Lock this tread and make a new Category for new ones to go?

#116

Someone (I know that saying someone normally means no one) should go through this thread and pull out and categorise the gold nuggets buried within.
In the way that the script library / documentations are sorted into categories (data / design etc). the tips can also be arranged like that.

#117

I would if I could create new categories. :smiling_imp:

#118

:raising_hand_man: I know someone who can do it!

All jokes aside, we are working on finding ways for which we can better organize these “cheats” and “tips”. We’ve thought about separating them from this category, and applying them into the categories they refer to, however, there’s the risk they’ll get lost in the rest of the discussion.

Part of what’s so great about this new User Forum model though, is that the search functionality is very powerful, so while it may not be practical to sift and read through every “cheat”, if you search for something, it’s highly likely a relevant “cheat” will appear. So we won’t be locking this thread until we’re certain we can organize all the content that resides here properly within appropriate threads.

In the meantime you’ll have to settle for scrolling and searching :blush:

1 Like
#119

Really nice work good job

#120

Very nice Dundas Cheat Sheets.