As mobile technologies become more agile and affordable, business professionals have come to rely more heavily on their mobile devices for work. Voice and email were the first two evolutionary steps that organizations and individuals adopted with mobile technologies. The next logical leap for organizations to take is to embrace mobile BI. In fact, many [...]
21
Feb
Using SQL Server Ranking Functions to Find and Remove Duplicate Records
This article will look at the SQL code used to find duplicate records and then to delete all but one copy of each group of duplicates. It will look at two scenarios: A table with an auto-incrementing unique field and a table without a unique identifier for each record. Consider the following scenario: A Report [...]
21
Feb
QlikView Incremental Loads and QVD’s
QlikView, by design, includes many new and innovative technologies such as the associative data model and highly effective data compression algorithms which make possible its state-of-the-art in-memory technology. QlikView allows us to load and keep all the data in memory for evaluation, analysis and reporting. If you’ve worked with QlikView you understand the value of [...]
06
Feb
SSRS – Creating and Using Custom Assemblies Part 2
This is the second article in a two part series that describes the steps necessary to add a custom assembly to a SQL Server Reporting Services (SSRS) report and to utilize the business logic within it. The last article used a class that only had a single static constructor. Within this article we will take [...]
06
Feb
SSRS – Creating and Using Custom Assemblies Part 1
This will be the first article in a series that will describe the steps necessary to add a custom assembly to a SQL Server Reporting Services (SSRS) report and to utilize the business logic within it. Let’s assume for a minute that you have custom business logic already wrapped up in a .Net assembly and [...]
06
Feb
Job Openings
New Job Openings have been posted at Result Data. Visit our employment page for more information
03
Feb
QlikView – Service Accounts
So what is a Service Account? A Service Account is often an Active Directory user account that is created for the sole purpose of gaining access to some sort of network resource, like a file share or a database via an ODBC/OLEDB connection, it is this account that a service uses to run as (often [...]
24
Jan
Using Alternate States in QlikView 11
Comparative Analysis, known to QlikView developers as alternate states, is a new feature in QlikView 11. A user can create any number of alternate states and assign objects to these states. This allows for easy comparisons between certain selections. A user could easily create two alternate states, and by just changing list boxes assigned to [...]
24
Jan
The Web Intelligence Name Game
Confused by some of the terminology associated with the SAP BusinessObjects BI Platform 4.0? This article explains some of the new terminology which is associated with Web Intelligence. One of the charming idiosyncrasies of the new SAP BusinessObjects 4.0 platform is the confusion over names. In some cases the confusion is over a simple name [...]
23
Jan
Upgrading to SAP Business Intelligence 4.0
With the official release of the newest version of SAP BusinessObjects Business Intelligence platform 4.0 comes the inevitable question: Should I upgrade to 4.0? The real question is not should I upgrade; the question is WHEN should I upgrade. I have experienced many a “nightmare” upgrade scenario over the years and they all have one [...]