Data extraction examples

Grocery store

This table shows customer purchases against a grocery store inventory in a database.

Reference link

A Reference Link returns the value of a single record.

In this example:

• The Data Filter item is Product ID = 20002
• The Output item is Product.

This table show the result as Orange.

Summary link

A Summary Link returns the balance of a filtered range. For example, the total cost of Bakery goods. You can output the Bakery item with the highest cost by specifying the 'Maximum' Extraction Type.

In this example:

• The Data Filter item is Product Category = BAKERY
• Cost is selected twice as an output item. In one instance, the Extraction Type is Sum. In the second, the Extraction Type is Maximum.

This table shows that the displayed results are $206 (Sum) and $35 (Maximum).

Summary report

A Summary Report provides a summarized listing. Microsoft® Office Excel displays a row that contains all Output Data Items for each summary level. For example, a list of fruit goods and quantities with the ID 20002 to 20004.

In this example:

• The Data Filter item is Product ID = 20002 to 20004
• The Output Data items are Product and Quantity.

This table show the displayed results:

Detail report

A Detailed Report provides a detailed listing. There is one row in Excel for each record in the database. For example, all products (and respective quantities) that include the term 'Loaf''.

In this example:

The Data Filter item is Product = %Loaf%

The Output Data items are Product and Quantity.

This table show the displayed results: