The Set Planner Report dialog box is designed to write out to a file the information displayed in the main Set Planner display. A report from the Set Planner application will be very useful when designing and building an Extraction Set in the Set Designer application. Designer application.
Set Planner Report Sample
DATABEE SET PLANNER REPORT
DataBee Version: v03.00 beta 10
Report Written: Tue 18 Mar 2003, 10:43
Total Tables: 16
Total Source Rows: 2821
Total "Undecided" Tables: 0
Total "Undecided" Table Rows: 0
Total "Subset" Tables: 9
Total "Subset" Table Rows: 2223
Total "All" Tables: 5
Total "All" Table Rows: 139
Total "None" Tables: 2
Total "None" Table Rows: 459
Rows Wanted User Name Table Name Source Rows
----------- ---------- ------------------------- ------------
[Subset] SRC_BILL DTB_INVOICE 300
[Subset] DTB_INVOICE_LINE 1000
[Subset] SRC_CUST DTB_CUSTOMER 10
[Subset] DTB_SUPPLIER 90
[Subset] SRC_INVN DTB_INVENTORY_ITEM 290
[Subset] SRC_WARE DTB_WAREHOUSE_STOCK_HK 124
[Subset] DTB_WAREHOUSE_STOCK_LA 98
[Subset] DTB_WAREHOUSE_STOCK_LO 143
[Subset] DTB_WAREHOUSE_STOCK_NY 168
[All] SRC_BILL DTB_DISCOUNT 11
[All] DTB_INVOICE_STATUS 4
[All] SRC_CUST DTB_POSTCODE 100
[All] DTB_WEEKNUMBER 20
[All] SRC_WARE DTB_WAREHOUSE 4
[None] SRC_BILL DTB_INVOICE_LINE_HISTORY 0
[None] SRC_INVN DTB_ITEM_X_CUSTOMER_AGG 459