Chapter 22: Complex Queries

 < Day Day Up > 



Overview

One of BusinessObjects’ greatest strengths is its query engine. Its powerful semantic layer lets you create complex SQL statements, without your ever having to know or write SQL. I refer to complex queries as any query that contains SQL that

  • Not all BI tools can handle

  • Potentially have an adverse effect on response time

  • May lead you to incorrect results the first time if you lack a clear understanding of the functionality or logic

You may not always realize when you generate a complex query; it’s quite simple to add result objects to the Query Panel that, unbeknownst to you, come from two different star schemas. In other cases, you may struggle to define conditions in a way that gives you the desired results—for example, you may be forced to use nested conditions or subqueries in which building the query with the attendant thought process and tasks feels complex.



 < Day Day Up > 



Business Objects(c) The Complete Reference
Cisco Field Manual: Catalyst Switch Configuration
ISBN: 72262656
EAN: 2147483647
Year: 2005
Pages: 206

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net