Tech Tips

Have you ever had the need to display a full year of data on a chart … even when you don’t have actual data to display? This is what we want to display: But this is what our data displays: We used to use complicated work arounds to handle this ...

Tableau uses the concept of hyper extracts – a compressed snapshot of data stored on disk and loaded into memory when required to render a tableau visualization. Hyper extracts are very beneficial and even essential to Tableau users. To refresh an extract on a daily, weekly or monthly basis users ...

Lately we have noticed issues with a lot of customers regarding their BO auditor not working due to lot of Audit files being present in the Auditing folder. So, here is tip for administrators to include as a part of their Application Maintenance list, which helps make sure the auditor ...

Many business users require similar report content with minor formatting differences.  Rather than create individual, customized reports for each business user the report writer can leverage input controls and conditional formatting to put the power of customization back into the hands of the business users. Below is a sample of ...

This blog is aimed at Xcelsius users who want to migrate their .xlfs into Squirrel. To everyone else — don’t let this put you off, it’s still an interesting read and you might pick up a few hints and tips along the way. The first thing to know is Our ...

Tip : How to use System Configurations A system configuration defines a set of datastore configurations that can be used at job runtime. System configurations are used to execute the same logic against different datastore environments. Migration is faster between environments. Steps: Right click an existing data store and click ...

Sometimes just because you can, doesn’t mean you should.  Although sometimes it pays to break that rule, in many cases it is the one rule that we pass on to our kids that we most hope they follow.  And so, it follows that maybe it was the one rule our ...

I have been designing dashboards with Xcelsius and Custom Code (HTML5) the past couple of years and I wanted to share how you can design dashboards like a pro. Personally, I am an advocate for designing dashboards with Adobe Illustrator. I found it the easiest to learn.  You can choose ...

In Design mode of Web Intelligence, you can change the sort order of columns in a block.  However, this option is not available in Reading mode.  We can accomplish some basic sorting tasks using an input control and the steps below will detail how this is done. We’ll start off ...

In this tech tip, you will learn how to dynamically switch a break dimension using an input control.  We will start with a cross table that was created in the Alternate Break Value Highlighting tech tip, but you can substitute any 2 dimensions you would like to work with.  This ...