Component Solution Services REC02F Manuel d'utilisateur télécharger pdf (Page 18)

Tips Recipes Brio 2002

Section Type: Query section

Tip Name: “What’s Not” Query

Purpose / Use: To find out from the database what did not happen.

Sample File: Not sold.bqy

Steps to Produce: Add a limit based on a “not in” sub-query select.

1) Build a data model that includes one or more tables that would normally contain the absent

information.

2) Add a limit on the primary key join field by either double-clicking on the field, or dragging

it into the Limit Line.

3) In the Limit dialog box, click on the “Custom SQL” button.

4) Enter the SQL for a “not in” query that tells the database to fetch data from the primary

table where the linking field does not appear in the subordinate table. For example:

Products.Product_Id not in (select product_id from sales_fact)

You can even add a limiting WHERE clause to the not-in sub-select to constrain the results

further.

1 2 ... 13 14 15 16 17 18 19 20 21 22 23 ... 77 78

Pas de commentaire

Component Solution Services REC02F Manuel d'utilisateur Page 18