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: BI Platform
Xcelsius 2008 and Refresh On Load
Are you used to the new Xcelsius 2008 yet? The release of SP1 has definately been a big improvement. Like many others, I struggled with the new and improved Xcelsius. There were a few too many quirks for me and until the release of SP1, I went back to Xcelsius 4.5. Besides the fact that […]
Crystal Reports Embedded And Its Limitations
So you may be asking… What is Crystal Reports Embedded? Crystal Reports embedded is an architecture which allows the Crystal Reports Rendering engine to run within the confides of the application environment. BusinessObjects provides a .NET runtime and a Java Report Component (JRC) which allows developers to embed Crystal Reports in their applications. Crystal Reports […]
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 […]
Looking for an Xcelsius 2008 Best Practices Guide?
I think I may have found what you are looking for. This is an excellent guide that you can use to bring best practices to all your Xcelsius work. This 16 page guide is an well thought out guide for using standard around colors, data organization, testing, etc. Implementing these best practices will undoubtedly improve […]