The Query & Analysis tools from SAP BusinessObjects – Desktop Intelligence and Web Intelligence – are very powerful when it comes to analyzing corporate information. They give you the ability to add complex conditions without the need to know SQL language. A problem that may arise when generating your query is that, when defining conditions with sub queries, the complexity (an indicator of the performance that the query will have when transformed into SQL language) escalates causing your query to take an enormous amount of time to generate, or not to generate at all. Let’s look at the root causes of these facts and a workaround that can be used to make your analysis quicker.
How to decrypt the CMS in SAP BusinessObjects R2 / R3.1
Unlike previous versions of SAP BusinessObjects, the system database in the XI releases is encrypted and cannot be manually queried or modified by the system administrators. SAP BusinessObjects includes one tool called Query Builder, which can be used to perform some queries against the system database, but the power of these queries is very limited.
Embedding Xcelsius dashboards in Dashboard Builder
If your goal is to build a balanced scorecard that is interactive and also secure, you can achieve this by embedding an existing Xcelsius dashboard in Dashboard Builder.
With Xcelsius you have the tools to design an interactive and user-friendly dashboard. And with Dashboard Builder you can build a well-structured scorecard and define which users or group can access it. So with the combination of both tools, you can create a dynamic, user-friendly scorecard which can be integrated with the SAP BusinessObjects XI security model.