Guest Blog – Differentiation in Five Steps from Mueller Inc.
To gain a client perspective on business analytics, we asked data science executives to provide their real-world expertise. In this post, we welcome Mark Lack, Manager of Strategy Analytics & Business Intelligence at Mueller Inc. Mark is considered a thought leader in this space and has won various awards including IBM Analytics Champion, Information Management’s […]
Configure Multiple Reports in One Report Specification
One report specification can contain different views of your data, essentially rendering different reports. But why would it make sense to set up one report spec to do this, you ask? This makes sense when the queries behind the pages share a lot of content, and it’s easiest to maintain that content in one location […]
Back to Basics with Qlik
For the start of 2016, let’s get back to the Qlik Scripting Basics! Here are a few basic scripts that you will always want to have handy in your Qlik toolbox. These scripts will be very useful when creating new QlikView and Qlik Sense applications time and time again. You will definitely want to bookmark […]
Why Use a Synthetic Dimension in QlikView?
The definition of a ‘Synthetic Dimension’ is a dimension based on fields that are not stored in your data model. There are many uses of a Synthetic Dimension – For the sake of this post, I am going to cover the most common use that I’ve experienced. It is all too often when a client […]
Relative Time Prompt Token Macro Technique
Prompt token macros are used to pass the definition of a data item rather than a value. They are very efficient and useful for both relational and dimensional data sources and prove to be a friendly administrative and end user experience. You can use the relative time token for scheduling purposes as well as a […]
Manage Framework Manager Model Changes
Managing change is difficult in any aspect of life, whether changing jobs, moving cities or simply adapting to the fact that Panera has done away with your favorite Cuban Chicken Panini (bummer, right?). Addressing changes in business critical systems can range from mildly annoying to down right time consuming depending upon several factors. How big […]
Use a Variable in a TM1 TI Process SQL Statement to Filter on Input from a User
Variables can be used in a variety of ways in Turbo Integrator processes. The use of variables can increase efficiency by making the administration of your TM1 model easier. Variables can also play a role in providing an end-user with the ability to perform administrative tasks similar to typical user input. Many times SQL statements […]
How to Perform Data Validation in QlikView
As with any BI tool, developer validity testing needs to be performed prior to any and all releases of an application to the end users. BI tools, like QlikView, allow for the rapid development of an application giving results very quickly. This rapid development is wonderful to help see results and make decisions…. but a […]
Business Decisions: Don’t be Afraid to Break the Chain
When an elephant is young, its leg is chained to an anchor in the ground. The baby tries and tries to get free, but cannot. When that baby elephant grows up into a large adult, it has the power to break out of the chain, but it doesn’t even try because of its prior experience […]