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…
Search Results for: www.businessobjectstips.com/business-objects-xi-query-builder-guide
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…
Newly Released Guide: Web Intelligence Quick Reference
It has been exactly one month since I published my last Business Objects XI article. I sincerely apologize for the delay, but I promise that I did not take a holiday. I spent the past month working on enabling a new “Subscribe to Comments” feature and lately on pulling together a brand new guide which […]
Continue reading…
Store
These are products sold by retailers related to Business Objects that we believe you might find resourceful. We offer no guarantees (except for our guides), just recommendations based on personal experience or the feedback of others. If you have a Business Objects related product that you would like to recommend please send us an email […]
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…
OpenDocument – An Introduction to a Powerful Tool
If you are not yet using the OpenDocument function in your reports you might want learn a bit more about it and see if it could not meet some of your current business requirements, or better yet allow you to amaze your business partners by giving them something they didn’t yet know that they needed! […]
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 Guides and Tutorials
“The Best Web Intelligence Quick Reference Guide Available!” We have compiled our NEW Business Objects XI Web Intelligence Quick Reference Guide into a concise collection of the most popular and valuable WebI functions, syntax details, tips, and more all with the goal to increase developer efficiency and precision and to make reports more professional and […]
Continue reading…