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 [...]
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). [...]
Continue reading about Hardly Working? No, Hard at Work on the Query Builder Guide
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 which [...]
I am not sure under which rock I have been living but apparently 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”.
I read a bit about it here at a SAP Business Objects Blog on the topic. Check [...]
Continue reading about Have you Heard of Path Queries in Query Builder?
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 [...]
Continue reading about New Lower Price on Query Builder Guide
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????
The answer: No
All [...]
Continue reading about Querying the Busines Objects XI CMS InfoStore Database Tables
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? [...]
Continue reading about Using BO Query Builder to Detect Report-Universe Binding Status
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 [...]
Continue reading about A Favorite from Query Builder – Active User List
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. [...]
Continue reading about Business Objects Query Builder Functions: Max, Min, and Sub-Queries
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 [...]
