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…
Posts tagged with 'Query Builder'
SI_LASTLOGONTIME Updates Every Other Time
Sometimes people bring issues to me that exceed my knowledge and experience (or time to investigate). Business Objects is a complex tool now and there are always new nooks and crannies full of “features” that frustrate BO administrators and users. Alan Miles brought this latest one to my attention; I hope that we can collectively […]
Continue reading…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…