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 […]
Monthly Archives: October 2008
BusinessObjects XI 3.1 Features
I haven’t seen a lot of information available that talks about what’s new in the release of the latest version, BusinessObjects XI 3.1, so I thought I would point out some of the highlights I’ve come across. You may also want read the complete What’s New in BusinessObjects XI 3.1 guide from the website. Release […]
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 […]