I was recently working with a universe and attempting to calculate a ratio between two numbers and coming up with some strange results. I wanted to share this with you so you didn’t waste as much time as I did trying to solve the problem. Always Returning Zero In my example, I had two measures […]
Tag Archives: Universe
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: […]