| < Day Day Up > |
|
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 > |
|