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…
Tools
Import Wizard, Life Cycle Manager, UMT, & Promotion Management, Oh My…
Hey Import Wizard, Good Job! Anyone who has spent some time around Business Objects before BI 4 should be familiar with Import Wizard. It has a little clunky and hard to control, but once you learned to follow and few rules and respect its limits Import Wizard became a powerful tool in your hands. I […]
Continue reading…
Hot Backup & Restore of BusinessObjects XI3/BI4 Content
Background Backing up a BusinessObjects Enterprise system is not the easiest of tasks and normally requires the database and cluster to be taken down to ensure the system database and file store are correctly synchronised. Retrieving a single document from the backup can involve restoring a clone system to access the single document or overwriting […]
Continue reading…
QBXcell – Unlock Your System Database
Analyse BusinessObjects users, documents, connections, servers, scheduling, security, which documents use which universes etc. Background Originally the BusinessObjects repository held all the deployment information for your BOE system. As the repository was a standard relational database the information could be queried via a universe or directly from SQL. Since BusinessObjects XI the repository has been […]
Continue reading…
BOXI Grooming: Prune Your Input and Output FRS
Origin of a Cluttered FRS Business Objects XI has a way of making more sub-folders than files. Seriously, take a close look at your Input and Output File Repository Servers, or rather your FRS on the disk. You will notice a crazy number of folders. As objects get deleted in Business Objects XI their corresponding […]
Continue reading…
Archiving Historical Object Instances in Business Objects
I like to answer the really good and broad-focused emailed questions through articles on this site. The following is one such emailed question: In Business Objects is there any way to archive historical object instances? We need to keep objects for several years, but don’t want to keep so many objects available on the server […]
Continue reading…
Which Business Objects Auditing Activities or Events Capture BO Universe Name?
Some of us in the in the wide world of BO use universes as a method to segregate our reporting. This is logical since a universe is usually tied to a single database connection. Therefore little groups of reporting users tend to congregate around universes. Some of us have picked up on this little fact […]
Continue reading…
Solving Business Objects XI R2 CMS Security Viewer’s Crashes
Business Objects XI R2 CMS Security Viewer is a useful administrative tool provided freely by Business Objects. It allows one to analyze your security models without having to actually alter user group membership or login as different users. The tool should not be need in Business Objects XI Release 3.0; however, it can be very […]
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…