Tracking Concurrent Users with Query Builder and Auditing Data

Today I received the following request via email: “Do you have any pointers for me where I can find a lot of useful [Query Builder] queries? One in particular I am looking for is where I can see what is the max concurrent users on our environment by today, week, month and all historical dates…” […]
Continue reading…

Enjoyed this post? Share it!

 
 

New Version of the Query Builder Guide is Released!

In January I committed myself over on our Facebook page to completing the long-promised updates to the Business Objects Query Guide. Last night, technically just one day later than promised, I delivered on that promise. Many Improvements to Our Most Popular Guide 1) First of all, the hyperlinks within the document are fixed. There are […]
Continue reading…

Enjoyed this post? Share it!

 
 

New Query Builder Guide Version Published – Includes XI 3.x Updates and Relationship Functions

I have finally completed my nearly 3-month long update to our Query Builder Guide. Like most things I do, the deeper I got into it the more I found that needed work. What kept me going, and delaying my previously promised delivery time, was the realization that aside from Ted Ueda‘s famous blog entries on […]
Continue reading…

Enjoyed this post? Share it!

 
 

Hardly Working? No, Hard at Work on the Query Builder Guide

I feel I owe a small explanation for the lull in the new article publishing on the site. I have remained active at responding to article comments, but I haven’t published a new article in nearly a month (although I just added some details to the latest article on BO XI 3.1 Fix Packs). Anyway, […]
Continue reading…

Enjoyed this post? Share it!

 
 

In Business Objects how can I get a list of reports using a specific universe?

I have been asked the following related questions a few times in the past months and I thought it would be a good idea to post a public answer to them. First the questions: Is there any way to get a list of reports that are using a specific universe? If I change this universe […]
Continue reading…

Enjoyed this post? Share it!

 
 

Have You Heard of Path Queries in Query Builder?

Did you know that there is a tweak that you can do to your Business Objects server’s Query Builder main page “query.jsp” so that it can handle “Path Queries”? Do you know what a “Path Query” is? Do you know why you should care about “Path Queries”? I was originally introduced to Path Queries by […]
Continue reading…

Enjoyed this post? Share it!

 
 

New Lower Price on Query Builder Guide

I just wanted to let visitors know that we have just lowered the price of the “BusinessObjectsTips.com Query Builder Guide” to $27.00. We have heard a lot of good things about the guide from its students since its release late last year. It truly is the “The Best Query Builder Guide Ever Written”! Just as […]
Continue reading…

Enjoyed this post? Share it!

 
 

Querying the Busines Objects XI CMS InfoStore Database Tables

The question has come to my mind many times over the years and this month it has come to my inbox. Thanks to Pluto for inspiring me to write this article. The question: Is it possible to peer into the Business Objects XI CMS InfoStore (a.k.a. database repository) without Query Builder or the BOXI SDK???? […]
Continue reading…

Enjoyed this post? Share it!

 
 

Using BO Query Builder to Detect Report-Universe Binding Status

The loss of binding between reports and universes is a common problem experienced by BO XI users. Often the issue can go unnoticed for quite a while, but like a dormant disease it can spontaneously begin to demonstrate severe symptoms that can result in the loss of your report. Sound serious enough? It is! The […]
Continue reading…

Enjoyed this post? Share it!

 
 

A Favorite from Query Builder – Active User List

Sometimes you can’t get Business Objects’ Central Management Console (CMC) to return the “Metrics” page and you need to know how many users are logged in to the system. Other times the CMC “Metrics” page works, but in the case of system administration, you may want to know who is logged in to your Business […]
Continue reading…

Enjoyed this post? Share it!

 
 

Business Objects Query Builder Functions: Max, Min, and Sub-Queries

If you have spent some time with Business Object’s Query Builder you may have arrived at the conclusion that the SQL that it supports is rather simplistic. I don’t blame you, when I first started using Query Builder I felt the same was after spending just a few hours struggling with the tool. Most of […]
Continue reading…

Enjoyed this post? Share it!

 
 

Officially Released: The Best Business Objects XI Query Builder Guide Ever Written!

Perhaps a few visitors to BusinessObjectsTip.com have already noticed that we posted a new guide for BO XI Query Builder on the site last month. Due to some technical difficulties and lots of other lame excuses there was trouble finding and ordering the guide. These obstacles have been overcome now and I would invite you […]
Continue reading…

Enjoyed this post? Share it!

 
 

Business Objects XI – Changing BO Report / Universe Relationships

Common Ground – Terminology Firstly, let me lay down some terminology in order to make this concept easier to discuss. “Classic BO” refers to any version of Business Objects between 5.X and 6.X. “BOXI” or “BO XI” refers to the Business Objects XI Release 1, 2, or 3 (R1/R2/R3), the injection of BO to the […]
Continue reading…

Enjoyed this post? Share it!

 
 

Query Builder: Improving Query Performance

Business Objects Query Builder is a free application provided with Business Objects Enterprise XI (BOXI). It is uses the BOE SDK to provide a simple web user interface for submitting queries against the CMS InfoStore and returning their results. Query Performance Concerns: Indexed Properties As you begin to experience the wonders of Query Builder you […]
Continue reading…

Enjoyed this post? Share it!