Dave’s Adventures in Business Intelligence

If you have been to the Integra Solutions web site and looked at their presentations page, or if you have been to one of the many Business Objects conferences that I have presented at over the years, you may have seen one of my “Variables” presentations. The very first one was in 1997 at the conference in New Orleans. And believe it or not, it was the presentation that almost wasn’t.

Continue reading “Variables and More Variables”

The Challenge

It is not uncommon for a report writer to want to know how many items were selected from a prompt. The challenge is that there really isn’t a way to do that, at least not one that is available as a function. So this article will show an interesting way to solve that challenge. It is not my original idea; it came from a post on BOB. At the moment I cannot find the post in order to give credit to the original author.

In a nutshell what is required is as follows:

• Capture the user’s response to the prompt
• Count the number of semi-colon characters found in that string

Continue reading “How many values were picked from a list?”