On August 5, 2009, the SAP BusinessObjects Innovation Center announced a prototype for moving Sets Technology directly into the Semantic Layer. Potential Future of Sets Since the EOL announcement of BusinessObjects Performance Manager and two of the three analytic engines, Process Analysis and Predictive Analysis, there has been an ongoing question on the future of […]
Tag Archives: Multi-pass SQL
Multipass SQL 2.0 (Updated 2/23/2009)
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 […]
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 […]