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 more of them and now they ALL work linking different parts of the document and providing links to the web as well.
2) I include details about Business Objects Business Intelligence platform 4.0, a.k.a. BI 4.0, a.k.a. XI 4.0.
3) Added MetaData.DataConnection to Appendix A’s si_kind cross-reference table.
4) Corrected error regarding “Supplemental” fields (link) such as those in Processing Info.
5) Cleaned-up sample queries and added a couple new queries.
6) The biggest improvement, aside from the fixed hyperlinking is that I added NEW section focussing on the IsAllowed function. This function is great, it allows you to filter query results based on the security rights of a specified user or user group! There is very little written about this function anywhere, and certainly not more than in the Query Builder guide.
Get the Latest Version of the Query Builder Guide
Therefore, if you have not yet purchased your Business Objects Query Guide, now is the time to get it. If you are already reaping the many benefits of owning the Business Objects Query Builder guide, then now is the time to pick up your free upgrade (please see your original purchase email receipt for details, contact me if you can’t find them).
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 I hope you will find useful and valuable. Yes, now we can honestly state that we offer guides, that is to say, instead of offering solely our popular Query Builder guide.
We have compiled our NEW Business Objects XI Web Intelligence Quick Reference Guide from the personal feedback and cheat-sheets of seasoned Web Intelligence developers. The result is a concentrated collection of the most popular and valuable functions, WebI operators, syntax details, tips, and more, pulled together with the goal to increase WebI developer efficiency and precision and to make reports more professional and complete. We want to enable Web Intelligence reports and their developers to realize their full potential… please read more about the guide and order one here
Want a Business Objects XI Guide? Please Let Me Know
For those of you who might have had the time to revisit this web site over the past year you might be wondering why we only have one single guide available. I ask myself this question almost everyday. I have been working on an administrator’s Life Cycle Management / Content Structuring guide for MANY months now and it is still far from being complete. Perhaps the obstacles are not so much many day job and my personal life, but rather the lack of drive to complete the guide because of doubts that there is demand out there for it.
Our Query Builder guide has sold quite so far, but I always knew there was a demand for it, because I myself struggled so much with Query Builder and its lack of documentation. I do need to go back and update it for BO XI 3, I know this. But I also feel that there are other guides I should be writing that would help make the jobs of Business Objects administrators, architects, and report writers easier.
Please help me figure out what kinds of guides would be most helpful. For example, do any of the following guides interest you enough to justify my extra effort and a few of your (or preferably your company’s) dollars:
- Quick Reference Guides, two or three pages packed with syntax and examples focused on a single topic such as Universes, Reports, Query Builder, Auditing, Import Wizard, or CMC
- Content Structuring and Life Cycle Management to improve metadata integrity
- Creating a Data Mart solution out of the Business Objects auditing data
These were just at the top of my head. Please leave a comment and share what is at the top of yours. I’d like to expand the value that this site provides to the Business Objects community, but I need your help. Thanks!
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 one very small example of the benefit of the guide let me share the following excerpt:
“Query Builder’s SQL engine is not case-sensitive. This applies to both inputs in the Query Builder GUI and also queries manually added to the top text area. For many this is a welcome feature as it improves efficiency in query entry and clear query results. Others may loathe this feature as it provides less filtering functionality for object values with only case variations.”
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 to check out “The Best Business Objects XI Query Builder Guide Ever Written!” We know that you will find it valuable and that it will turn you into a Query Building Genius!



