DBI Cheats

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

: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

Really nice work good job

Very nice Dundas Cheat Sheets.

All of these are awesome.

I have posted a script to disable / enable the schedules of all cubes in a project.
This was in answer to a question, and is available here

Add weather historical data to map against your actual data, not just the weather now feature shown in the blog (https://www.dundas.com/support/blog/adding-weather-data-to-dundas-bi-is-a-breeze). Many retail purchasing activities are driven by weather events, for instance, people buy more chocolate when it cools, bbq items start selling quickly is weather improves especially after long cool periods. www.aerisweather.com has some great API data and historical data that can be downloaded.

1 Like

very helpful! good!!

yea, I agree with this. This is a tricky resource to use in the current format. And I imagine it will just keep getting BIGGER!

Not really a code specific cheat, but something the analysts and developers here are working on implementing / using is using a layer on our dashboards to communicate, keep script we’re using, data… Especially for projects where one primary person is working on it and others may jump in occasionally, it’s nice to have this resource right there in a place you don’t have to hunt for it and go outside your workflow.

1 Like

very nice information

These are nice tips for all level of Dundas profesionals

Good information! Thanks!

Cool cheats, man! Thanks a lot!

I am constantly surprised by how intuitive Dundas is for design on most things. If you’ve worked in systems that aren’t, it’s easy to miss the little things that make live easier.

I agree that this blog could use some tags or topics to help organize it. It’s hard to find anything helpful.

1 Like

Point taken! We will do our best to gather all the nuggets in this thread and put them together somewhere it’s easier to access. We’ll keep you posted.

Not exactly a cheat, but something I learned while trying to get the combined value of 3 columns. Null values have to be treated as zeros if they are to be used in calculations.

Very helpful, saved lot of time Thanks to Dundas Cheat Sheets

Good job! Very interesting!