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 […]
Category Archives: Semantic Layer
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 […]
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: […]