So what is Multipass SQL? Multipass SQL. To calculate comparisons or to correctly calculate non-additive measures in report break rows, the query tool must break the report down into a number of simple queries that are processed separately by the DBMS. The query tool then automatically combines the results of the separate queries in an […]
Category Archives: Web Intelligence
Common Questions about Connectivity with SAP
Now that SAP has clearly and unambiguously stated that BusinessObjects is the new face of BI for SAP, we have many customers who want more information about connectivity with SAP and are surprised when we recommend that they connect to an existing BW Query instead of to the entire Infocube. Why is connecting to SAP […]
Set Analysis Part 5b: Custom Groups in WebIntelligence
So how we do do this exactly? How can I use BusinessObjects to create custom groups on-the-fly? How can I get beyond my requirements for multi-pass SQL and speed up my reports? The answer is Sets. Set Data All the information regarding sets is located is the tables called sets_*. The most important tables are: […]
Set Analysis Part 5a: Custom Groups in WebIntelligence
I recently had a customer who was in the process of migrating from a legacy version of Microstrategy to BusinessObjects. They had been able to migrate over most of their core reports, but there were several reports that required a number of custom groups. Microstrategy’s approach was to allow the customer to define any number […]
Row-level Security Trick with WebIntelligence
Can I Get Row-level Security with WebIntelligence and Still Avoid a Document Refresh? Sure! As a follow-up to my post yesterday I wanted to step back and say that normally you do want to handle row-level security from within the semantic layer. The problem is that you can’t get the benefit of the speed of […]