SuperQuery Online Help
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| What is SuperQuery? | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
SuperQuery is a data analysis and mining tool that runs under the Windows. Using Rule Induction Technology, SuperQuery searches data tables and reports all interesting patterns and exceptions. The Fact Discovery Engine is easily tuned to meet various analysis needs. SuperQuery also assists in preparing data for analysis by providing a number of facilities for partitioning, classifying and processing data columns. In addition, SuperQuery help to explore and analyze data by automatically displaying graphs and calculating statistics. It contains a number of Wizards that help read, update, and analyze data effortlessly.
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
|
SuperQuery Discovery version can read Access, xBASE, Excel, Paradox and Text files directly. and can also use ODBC to open most of the popular databases that have ODBC drivers. SuperQuery Office version can only reads MS Access and Excel files. The Open Table Wizard will help you in opening your data. After you open the data you may analyze the entire table ( see limitations in the open Wizard ), a random sample, or a sample that satisfies given criteria. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Introduction | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
SuperQuery is a query and database analysis tool. It helps you explore and analyze your data and discover any existing patterns.
SuperQuery is composed of three integrated facilities: ·Fact Finding System. ·Query Visual Tool. ·Tab Organizer.
The fact finding system searches your table and reports all interesting facts and exceptions. The query tool allows you to visually create different views on your data. Each view may have its own criteria and columns. Each view automatically displays statistical data and graphs about the current column. The Tab Organizer allows you to store all your views into different tabs. This helps you in using and presenting your analysis.
SuperQuery requires no knowledge of database languages or SQL. Fact Finding and Classification SuperQuery finds all “interesting” similarities among your data. For example, it may find that all your low income customers buy product A while most of your High Income customers are interested in product B. On the other hand, SuperQuery also detects exceptions. For example, in a mutual fund data table, SuperQuery may detect the exception that only two funds have Risk = Low and income = High.
SuperQuery uses heuristic functions to evaluate the interest level of facts and exceptions so that it can control the number and quality of facts reported. The user can raise or lower the interest threshold thus decreasing or increasing the number of facts and exceptions reported. Lowering the interest threshold reduces (and eventually cancel) the effects of heuristic functions.
In order to find facts in numerical columns ( like price, volume, temperature, etc.), we need to classify those columns into categories or ranges. SuperQuery can automatically create a new “virtual” column that classifies a numeric column into three ranges; High, Medium, and Low. You can change the number of categories and specify the ranges.
Moreover, SuperQuery allows general classification on other types of columns like Date and Text. You can create a virtual column that contains criteria on one or more columns. For example, you can classify your active customers as follows: Large Customer if shipyear = 95 and sales > 100 Medium Customerifshipyear = 95 and sales isbetween( 10, 100 ) Small Customer if shipyear = 95 and sales < 10
Once you create the “Active Customers” column, SuperQuery is able to find facts about your Large, Medium, and Small customers. The more classified your data is, the more opportunities for finding interesting facts.
Virtual columns also include a “Formula” type that allows the user to create calculated columns. For example create a “Total Cost” column multiplying Quantity by Price columns. Another type is the “Keyword” column that detects keywords from description columns. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Chapter1 Getting Started in SuperQuery | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
This tutorial will show you how to analyze and mine your data using SuperQuery. In the following chapters you will learn how to:
·Access your product sales data that is stored in the Sales table. ·Browse, set filters and create visual queries. ·Discover the hidden patterns in your data that are potentially useful. ·Summarize your sales data by product. The tutorial consists of 5 chapters, each requires about 10 minutes.
Launch SuperQuery If you are in the "Getting Started" dialog then, go to step 2. If you are in the SuperQuery main screen then, select the Table | Open Wizard menu item and go to "Read the Data" section.
1.Launch SuperQuery Click the Start button, click Programs and click SuperQuery. In the list of SuperQuery items that appears, click SuperQuery. The SuperQuery Getting Started dialog appears
2. Click on the "Use Wizard to read your data" button. Press OK.
Read the Data To access your data, you first need to read the database. SuperQuery will start the Open Wizard to help you read your table.
Chapter 1: Getting Started in SuperQuery Chapter 2: Organizing your Data Chapter 3: Querying the Database Chapter 4: Discovering Facts and Rules Chapter 5: Summarizing your Data
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Chapter2 Organizing your Data | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Since you will create more views in the coming sections, you need to organize these views in order to easily access them.
SuperQuery main screen consists of one row of eight tabs. You can edit the tab title and change the tab color. You can explore these features from the tab property menu. To display the property menu, click the right mouse button on the tab you want to edit.
From the property menu of the first tab, select the "Title" menu item and write down " Sales Data" in the "Edit Title" edit box, then press OK. Repeat for the second tab, and write down the title "Product Summary".
Now we need to copy the main data view and put it in a separate tab before performing more analysis. Press the Duplicate button. SuperQuery creates a new copy of the same view. To move this view to the third tab, press the button. The button state will change to indicating that the view is now floating. Click on the third tab, in order to activate it. The current active tab becomes the third tab and the view still floats on this tab. Press the button again. The view is now fixed in this tab and the button state changes to . Write down the title "Raw Data" on the third tab in the same way you did for the two previous tabs.
SuperQuery's data view consists of four panes; the main pane is the Data Table that controls the scrolling of other panes. The other three panes are: Total Page, Reps Graph and the Data Page. Each pane has a re-sizable frame, to allow you to change pane size according to your preferences and the type of the analysis you are performing.
As you move the mouse on the pane frames, the cursor changes to in order to re-size vertical splitters and to re-size horizontal splitters separating the panes. As you move the cursor towards the splitter ends, the cursor changes to one of the following shapes in order to maximize or minimize the pane in the arrow's direction.
To change the pane type simply, select the "Change Type" menu item from the pane property menu. To display the property menu, click on the right mouse button when placed on the pane you want to edit. Select the new pane type from the list of the available types. Each pane has its own unique property menu that is tailored to its own functionality.
It is recommended that you spend some time to familiarize yourself with the different pane types and their properties in order to explore the strengths and capabilities of the system.
Chapter 1: Getting Started in SuperQuery Chapter 2: Organizing your Data Chapter 3: Querying the Database |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Now that you have the view of the table "Sales", you can start browsing, exploring and learning more about your data. SuperQuery Table View contains several panes separated by Splitters. As you are scrolling in the Data Table pane, all other panes in the same view are updated at all times. You can completely reconfigure any view by including some or all pane types.
Simple Queries: In the Sales view:
Click on the "Sales Data" tab. Move the cursor through the columns, and look at the Reps Graph to see the most common values in each column.
Go to a numerical column "PROFITDLR" or "QTYSOLD" and look at the Total Page pane to see the total, average, minimum and maximum values.
Click on any cell in the "CITY" column. The Reps Graph pane will show the most common values in this column. Double click on the "New York" bar in the graph. SuperQuery will immediately position the cursor in the Data Table at the first row that has the value "CITY = New York". Now push the filter button, and you will see only those rows satisfying that value "CITY = New York". Scroll through the other columns and watch all graphs and statistics calculated for New York. Furthermore, move to the "Profit" column and place the cursor on any cell having the value "High" then press the button again. This will simply perform the Query "City = New York AND Profit = High". This means that you are only viewing sales in New York City, which has high profits.
As you may have noticed, both "Profit" and "Quantity" columns have the cyan color, to reflect that they are calculated by the system. The Analysis Wizard created these two columns when you were reading the data table.
In order to edit the "Profit" column; first make sure that no filters are set on the view. To release all filters, press on the button, so that the green light is turned off. Double click on the column "Profit", the "Enter Ranges" dialog is displayed. Click on "5 Range" button and press OK. The column will be recalculated to map the original numerical values into five ranges (Very High, High, Medium, Low and Very Low) instead of three ranges (High, Medium, and Low).
More Comprehensive Queries: In the "Sales" table, suppose that you want to study the New York City sales only during the winter. To do this, you need to create a new column of type "Filter" to perform the criterion: CITY = New York and MONTH is one of (December, January and February).
Click on the first tab "Sales Data" in order to work with the Sales data view. Make sure that no filters are set on the view. To release all filters press on the button, so that the green light is turned off.
Chapter 1: Getting Started in SuperQuery Chapter 2: Organizing your Data Chapter 3: Querying the Database |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Chapter4 Discover Facts and Rules. | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Now you are ready to run the most powerful feature in SuperQuery and discover the patterns hidden in the data.
Click on the first tab "Sales Data" in order to work again with the Sales data view. Make sure that no filters are set on the view. To release all filters, press on the filter button, so that the green light is turned off.
When the engine finishes scanning the data , it asks you if you want to view the discovered facts in a table view. Press "Yes" to view the facts in the SuperQuery Facts View.
The new view will be floating on top of the data view. You can move this view to one of the empty tabs and edit its title to read "Profit Facts" (as explained in Chapter 2).
Now you can scroll through the "Fact Table View" rows and read the facts. Notice that as you are scrolling in the rows, the Facts pane (the pane below the Data Table pane) shows the description of the current fact in natural language. For example, in the first row, you should have a fact similar to following:
This Fact means that "Most Hat Sales have Medium Profits." The fact has a certainty factor of 80% and there are 25 rows supporting this fact.
You can also look at the Facts pane and read the same fact in a more natural language "Most Sales where PRODUCT = Hat --> have Profit = Medium. Percentage 80% Supported by 25 rows." You can also read the fact in the Rules format. To do this, click on the Right mouse button when placed on the Facts pane and check the Rules Format. The text will be changed to "If PRODUCT = Hat --> then Profit = Medium. Confidence 80% Supported by 25 rows."
Press the Drill-Down button to view those data rows supporting this fact. SuperQuery will create a new data view and set filter on those data rows. You can close the view or move it to another tab. It is sometimes easier to read the discovered facts in a report form. SuperQuery allows you to export the discovered facts into text files in both Facts and Rules format. From the Table menu, select the Export | Facts menu items. When the "Select Table" dialog is displayed, select the "Profit Facts" table. Press OK, the Save As dialog is displayed. Write down "ProfFact" in the "File name" edit box and press OK. SuperQuery saves the new file as a text file "ProfFact.txt". Open this file using any text editors and view the text. Try to do the same steps to export the Facts Tables in the Rules format and compare the two.
In situations where you have a lot of facts, it is useful to be able to set filters on specific types of facts and also see a graph of the distribution of facts among columns and values. To do this, you need the "Reps Graph Pane" which is already in the view but minimized. Use the splitter bar at the right side to resize it, then scroll through the view columns to see the different distributions.
Chapter 1: Getting Started in SuperQuery Chapter 2: Organizing your Data Chapter 3: Querying the Database Chapter 4: Discovering Facts and Rules |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Chapter 5 Summarize your data | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Suppose that you want to analyze your sales by product. For example, for each product, you want to know: The most common city and month in sales, The total quantity sold, and The total profit.
Now click on the first tab "Sales Data" in order to work again with the Sales data view. Make sure that no filters are set on the view. To release all filters, press on the filter button so that the green light is turned off.
On the sales view, press the Summary button; the Add / Edit Summary table dialog is displayed. In the Select / Add Summary Table edit box, write down "Product Summary" to name the new Summary table. Click on the "Group By" drop-down box to select the PRODUCT column. Press the "Select Cols" button in order to select the columns City, Month, QTYSOLD and PROFITDLR and their associated summary operators. The "Select columns and their summary calculations" dialog is displayed. Check the boxes next to the columns: City, Month, QTYSOLD and PROFITDLR. Click on the drop-down box next to the "CITY", and select the operator "Most common". Also for the "MONTH", select the operator "Most common". For both "QTYSOLD" and "PROFITDLR", select the operator "Total". Press OK to return back to the Add / Edit Summary Table dialog and press OK.
SuperQuery will summarize the data on each of the products: Coat, Glove, Hat, Jacket and Shirt and will show them in a new Summary view.
The new view will be floating on the top of the data view. Move this view to third tab "Product Summary". To do this, click on the "Product Summary" tab. The view will move to this tab. Press on the button to fix the view in this tab.
The first row in the summary view reveals the following :
In order to view those rows that have "PRODUCT = Coat", place the cursor on the first row and click on the Drill-Down button. SuperQuery will create a new data view and set a filter on those data rows. You can close the view or move it to another tab.
The Data Graph is showing the values of the column you have the cursor on. In this case, the graph is showing the values of the column "Total QTYSOLD". It is clear that Shirts are the highest quantity sold since they have the longest bar in the graph. You can set the Graph Pane to show the highest or lowest values using its property menu.
Browse through the summary view rows and columns and look at the Data Graph and experiment with changing the property of each pane.
Chapter 1: Getting Started in SuperQuery Chapter 2: Organizing your Data Chapter 3: Querying the Database Chapter 4: Discovering Facts and Rules Chapter 5: Summarizing your Data |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
SuperQuery defines three major concepts are for data visualization and organization:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Definitions
Query and Statistical Analysis
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Query and Statistical Analysis | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
SuperQuery allows you to create queries visually in a “Query-By-Example” style. Furthermore, there are a number of short cuts that let you interact faster with your data. For example:
Examples of SuperQuery Panes are:
The user can completely configure any view by including some or all pane types. Panes process rows selected in the filter, for example, if you need to find total sales from NY then:
Similarly, if you need to find how you shipped to NY, move to the shipment column and look at the Reps Graph. The Graph will show the percentage of your different shipment methods to NY. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Tab Organization | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
In order to create a comprehensive analysis on your data, you need to create several views. Some views showing rows sharing common criteria or compose a specific fact. In order to be able to organize these views, SuperQuery provides a Hierarchical Tab Organizer. Initially, you have eight empty Tabs. You can start organizing your data views in these tabs. Each view has a “pin” button. You simply click the button to “fix” the view in the current tab. Similarly you click the pin again to make the view “floating”, then change to another tab and “fix” it there. If you need more tabs, you can add a new group of tabs inside any of the exiting ones. This allows you to create as many tabs as you want . |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Criteria | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
SuperQuery allows you to build criteria in a very easy manner ; SQ criterion consists of any number of Expressions ANDed or ORed together. Each expression consists of : Column identifier Operator Value (s)
See the criterion example See the criteria example |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Calculation statement | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The Calculation statement consists of one or more Operands and one Operator.
The Operand types are:
The Operator types are:
You may choose among these operator types depending on the operand's type. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Criteria Operators: | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
SuperQuery supports a wide selection of comparison operators, following is a list of these operators:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Date Operators | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
Logical Operators |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Mathematical Operators | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Numerical Operators | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Text Operators | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Calculation Statement Operators | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
SuperQuery supports the five following Calculation Statement operator's types:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Column identifier | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The column identifier is any valid column name that exists in the data table. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Primary key | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
A primary key is the table key. It is a data column with unique values. An example of the primary key is Employer Name column in the Employee table. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Foreign Key | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The foreign key in a table is a column that represents the primary key of another table . Each table may contain non-or many foreign keys. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| SQL Types | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
SuperQuery Supports the following SQL types list which contains the major ODBC SQL types:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| Statistical calculations | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| Value (s) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Values may be literal for example, 100 and “New Jersey” and may not be in the table, or may selected from the existing values. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Tab or Folder | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The main window in SuperQuery contains a set of tabs or folders. Each tab may have data Table Views or other tabs (but not both). This means you can have a hierarchy of tabs. A new SuperQuery document contains one tab-level that has eight tabs. You may add any number of tabs at this level or create more levels of tabs within any tab. Tab customization includes:
Changing the tab background color Moving views from one tab to the other Adding tabs to a specific tab level or even Adding tab level to within another tab
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| Editing the tab title | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Select the tab, then, choose the Tab | Title from the main menu, or click on the right mouse button on the tab and choose the title menu item. The Edit Title dialog will be displayed to allow you to enter or edit the tab name. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Changing the tab background color | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Select the tab, then choose the Tab | Color from the main menu or, click the right mouse button on the tab and choose the Color menu item. The Color dialog will be displayed to allow you to change the tab background color. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Adding tabs to a specific tab level | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Select the tab level that you want to add a tab to, by clicking on any of its tabs. Choose the Tab | New | Tab from the main menu or, click the right mouse button on the tab and choose the New | Tab menu item. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Adding a tab level | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Select an empty tab that you want to insert a tab level in. Choose the Tab | New | Tab Level from the main menu or, click the right mouse button on the tab and choose the New | Tab Level menu item. The Insert Tab(s) dialog will be displayed.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| Table view (TV) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
SuperQuery Table View is a new innovative way of viewing the data. Each Table View consists of a set of Panes. Each pane displays data from its own point of view.
The SuperQuery standard Table View consists of four panes; the main pane is the Data Table Pane that controls the scrolling of the other three panes; Total Page Pane, Reps Graph Pane and the Data Page Pane.
Each pane has a re-sizable frame, to allow you to change pane size according to your preferences and type of analysis. As you move the mouse on the pane frame, the cursor shape changes to show the re-sizing cursor and to show which frame to re-size. To maximize or minimize a pane, use the small button located at both ends of each frame.
Table view contains a row of 12 sets of buttons: |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| Pane | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
A pane is a re-sizable window that displays data in a certain way. SuperQuery provides 10 types of panes: |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The standard Table View panes are the Data Table Pane, Data Page Pane, Reps Graph Pane and the Data Page Pane. You can change the type of any pane but you must have one Data Table Pane. You can't have more than one pane of each type. To change the pane type:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Data Cell Pane | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Data Cell Pane is a view of the current cell. It is useful for displaying memo fields or long text lines.
To change the properties of the Data Cell Pane, click on the right mouse button (when placed on the Data Cell Pane) the Data cell pane menu will pop up. Select the property you want change. |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| Data Graph Pane | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The graph consists of horizontal bars representing the numerical values of the data fields in the current column. The left side of the graph shows the row number and the content of the first column. The right side of the bar shows the numerical value. You can set the graph to show the highest or lowest number of values.
If you double click on any bar, SuperQuery will go to that row number. You can then set a filter to study all rows that have this value.
To change the properties of the Data Graph Pane, click on the right mouse button (when placed on the Data Graph Pane) the Data graph pane menu will pop up. Select the property you want change. |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| Data Page Pane | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Data Page Pane is a page view of the current row. The pane’s first column contains names of the view columns. The second column ( in the pane ) contains the current row data. When you scroll in the Data Page Pane, SuperQuery will update all other panes in the Table View.
To change the properties of the Data Page Pane, click on the right mouse button (when placed on the Data Page Pane) the Data page pane menu will pop up. Select the property you want change. |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| Data Table Pane | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The Data Table Pane is the main pane in SuperQuery. The first row shows column headers, and the first column shows the row numbers (initially hidden). You can keep the first column or hide it, using the property menu item -- Display row headers. The status bar shows the total number of rows and the current row number.
As you scroll across columns and the rows of the Data Table Pane, all other panes in the view will consequently update their content.
When you double click on any virtual column in the Data Table Pane, SuperQuery will bring up the corresponding edit dialog for that virtual column type.
To change the properties of the Data Table Pane, click on the right mouse button ( when placed on the Data Table pane) the Data table pane menu will pop up. Select the property you want change. |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| Facts Pane | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Facts pane rewrites the current row in the facts table in a more natural language form. You have the option to select the formatting in either a "Facts - Exception" or "if ... then" form.
To change the properties of the Facts Pane, click on the right mouse button (when placed on the Facts Pane) the Facts pane menu will pop up. Select the property you want change. |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| Notes Pane | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Notes Pane is a window that you can use to write any comments about the view.
To change the properties of the Notes Pane, click on the right mouse button (when placed on the Notes Pane) the Notes pane menu will pop up. Select the property you want change. |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| Reps Graph Pane | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
This pane displays the repetition of values in the current column. It shows the number of occurrences (or frequency) of each individual value in a graphical representation.
The graph consists of horizontal bars representing the unique values in the current column. On the right side of the bars are the corresponding number of rows and their percentage to the total number of rows.
If you double click on any bar, SuperQuery will search for the first row that has that value. You can then set a filter to study all rows that have this value.
To change the properties of the Reps Graph Pane, click on the right mouse button (when placed on the Reps Graph Pane) the Reps graph pane menu will pop up. Select the property you want change. |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Reps Table Pane displays the repetition of values in the current column. It shows the number of occurrences (or frequency) of each individual value.
If you double click in any of the value cells, SuperQuery will search for the first row that has that value. You can then set a filter to study all rows that have this value.
To change the properties of the Reps table Pane, click on the right mouse button (when placed on the Reps Table Pane) the Reps table pane menu will pop up. Select the property you want change. |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| Total Page Pane | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Total Page Pane displays statistics about the current numerical column. You can add or remove from the set of default statistical calculations that were selected.
When you double click on a value in the pane, SuperQuery will search for the first row that has that value. This makes it easy to locate rows that have the maximum or minimum values for example.
To change the properties of the Total Page Pane click, on the right mouse button (when placed on the Total Page Pane) the Total page pane menu will pop up. Select the property you want change. |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| Total Table Pane | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Total Table Pane works exactly the same as the Total Page Pane but with extended view to show the result of the selected statistical calculations when applied to all the numerical columns in the view.
When you double click on a value in the pane, SuperQuery will search for the first row that has that value. This makes it easy to locate rows that have the maximum or minimum values for example.
To change the properties of the Total Table Pane, click on the right mouse button (when placed on the Total Table Pane) the Total table pane menu will pop up. Select the property you want change. |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
Panes properties menus |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Data graph pane menu commands | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| Notes pane menu commands | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| Data Page pane menu commands | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| Data Cell Pane menu commands | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| Reps Table Pane menu commands | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| Total Table Pane menu commands | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| Total Page Pane menu commands | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Reps graph pane menu commands | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| How to start SuperQuery? | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
From the Getting Started dialog you can either select any SuperQuery document from the drop down list, or the Use Wizard to read your data button to run the Open Wizard to help you to open your data. or From the File menu select any of the three menu items:
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| How to open a table? | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
From the Table menu select the Open Wizard menu item. The Open Wizard will run and will assist you to open your data. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| How to generate facts on a table? | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
From the View menu select the Facts menu item or press the Facts button to display the Add / Edit Table Facts dialog or the Facts Engine dialog to create a new fact table. When you press the Run button, the fact engine starts and the system automatically generates a new table view on the new created Facts Table. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| How to summarize a table? | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
From the View menu select the Summary menu item or press the Summary button to display the Add / Edit Summary Table Dialog in order to create a new Summary Table. Press the Select Cols button to select the columns you want to include in the summary table. When you finish with the dialog press OK, the system automatically generates a new table view on the new created Summary Table. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| How to update a table? | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
From the Table menu select the Update Wizard menu item. The Update Wizard will run and will assist you to update your data. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| How to change pane properties? | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| How to change pane type? | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| How to create SQ Criteria? | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| How to create a virtual column? | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
From the Table menu select The Analysis Wizard menu item to run the Analysis Wizard that will assist you to create the virtual column, or:
You can then follow the instructions in each dialog.
How to create a Filter column?
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| How to create a Filter column? | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| How to create a Formula column? | |||||||||||||||||||||||||||||||||||||||||||||||||||||
SuperQuery creates a new column and places the result of the last calculation statement. Note that the evaluation of the last calculation statement will automatically calculate all the contained statements (if any) |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| How to create a Range column? | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| How to create a Classification column? | |||||||||||||||||||||||||||||||||||||||||||||||||||||
SuperQuery scans all the data rows evaluating each criterion at each row. The category name associated with the first criterion that evaluates to TRUE, is placed in the classification column. If none of the criteria matches, SuperQuery inserts “Unclassified” in the Note you may replace the "Unclassified" word by writing any word at the row following the last row containing a value - criteria pair. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| How to create a Keyword column? | |||||||||||||||||||||||||||||||||||||||||||||||||||||
SuperQuery searches in the current column rows for the keyword. If SuperQuery finds the word among the data text, it will place the word in the new column row corresponding to that of the data table. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| How to create a graph? | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
You can add two types of graphs to your view: Reps Graph and Data Graph. To add a graph to the view, you need to change the type of one of the existing panes to the new graph pane type. To do this:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| How to export a table? | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
SuperQuery allows you to export both the data tables and the generated facts into text files. Select Table | Export | Tab delimited to export data tables into a tab delimited file. The system will display the Select Table Dialog to select a table that you want to export, then will display the Save As dialog to save the new file.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| How to move views? | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Select the view that you want to move and make it floating by pressing the view Fix button. Select the destination tab to make it the current tab, then click the Fix button again to fix the view there. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| How to join tables together ? | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Fix button
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Press the Fix button to fix or float a view in the current tab. To move a view from one tab to another, first float the view, switch to the other tab, then fix the view. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Press the Select Columns button to display the Select and reorder columns dialog in order to select or deselect columns in the view. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Duplicate button |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Press the Duplicate button to duplicate the current view. You can use the Duplicate button to create a new copy of the view. You can then set a different filter, maximize a graph pane, or in general, perform further analysis on the new view. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Print button |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Press the Print button, to see a print-preview the current data table view. Press the print button from the preview screen to start the printing to your printer. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Find button |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Press the Find button to display the Find dialog that allows you to search for a specific word or phrase in the current column. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Filter buttons |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Filter buttons are composed of three buttons. When you press the left button, SuperQuery sets a filter on the value in the current cell in the Data Table Pane. Only rows that have the filter value are shown in the view. If you move to another cell and press the button again, the filter further restricted by the new value. Each time you press this button, you are ANDing the current cell value to the filter. The button at the right side, is an "undo" filter operation. It will remove the last filter you set and hence expands the view. The middle button acts mainly as an indicator to show you if there is a filter set. You can also use it as a shortcut to clear all filters. It is important to note that all panes will change their contents according to the current filter. For example, “Total” panes will display totals for all rows in the filter. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Index buttons |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Index buttons are composed of two buttons. The left button displays the Add / Edit Table Index dialog that allows you to create, edit, or select a Table Index. The right button acts as an indicator and a shortcut to set or set the current index. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Add Virtual Columns button |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Press the Add virtual columns button to display the Add / Edit Virtual Columns dialog, which helps you create, edit, or delete a virtual column.
SuperQuery supports five types of the virtual columns: |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Drill-Down button |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
This button creates a detailed view of the current row in the view. This button exists only in the Summary and Facts tables . When you press it in a Summary view, SuperQuery creates a "Drill-Down" view the original data of the current row. Similarly, in the facts table view, the Drill-Down button displays all data rows that support the current fact. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Summary button
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Press the Summary button to display the Add / Edit Summary Table Dialog that will help you summarize a data table. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Facts button |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Press the Facts button to display the Add / Edit Table Facts dialog or the Facts Engine dialog that will let you run the fact engine. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Criteria example | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Table name : Orders Columns: Customer, Order_Value, Order_Date
Exp1 AND Exp2 Orders.Customer_Name begins with ‘Ch’ AND Orders.Order_Value >= 1000
In this example, the criterion statement consists of two ANDed criteria. The system will only consider data rows from the table Orders that has Customer_Name column beginning with ‘Ch’ and Order_Value >= 1000. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Criterion example | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Table name : Orders Columns: Customer, Order_Value, Order_Date
column identifier criteria operator value Orders.Customer_Name begins with ‘Ch’
In this example, the column identifier is Orders.Customer_ Name where, Orders is the table name and Customer_ Name is the column name.
This criterion selects rows that have Customer_Name that starts with the two letters ‘Ch’, e.g., Charles, Chris, ... |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Classification column example | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Table name : Orders Columns: Customer, Order_Value, Order_Date
Value Criteria
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Filter column example | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Table name : Orders Columns: Customer, Order_Value, Order_Date
Suppose that you want to view only orders that are greater than $1000.
You can create a filter virtual column as follows:
A new column is inserted that has the two values TRUE and FALSE depending on whether the Order_Value satisfy the criteria or not.
You can move to a cell that has a TRUE value and push the filter button to view only those rows having the TRUE value. Similarly, you can view only rows that have FALSE values.
Notice that the criteria may contain more than one condition. For example, Order_Value > 1000 and Order_Month = August.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Formula Column example | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Table name : Orders Columns: Customer, Qty, Unit Price Suppose you want to create a new column that contains the total Order_Value.
You can create a formula virtual column as follows:
Name Calculation statement Result Line1Qty * Unit_Price
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Keyword Column example | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Using the Orders table, the user may create a VISA column to reclassify the Payment_Method column. This allows for the analysis of customers who used Visa card for payment.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Range column example | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Table name : Orders Columns: Customer, Order_Value, Order_Date
Suppose you want to classify your orders into three classes Low, Medium and High orders. You can create a range virtual column as follows:
Low from the lowest value to 1000 Medium from 1000 to 3000 High from 3000 to the highest value available
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Virtual Column | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
A virtual column is a user-defined column that is based on one or more data ( and / or virtual ) column. The Virtual column is dependent on its source columns and is used to produce an analytical view of the data.
SuperQuery supports five types of the virtual columns:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Filter column | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Fitter Column has TRUE / FALSE values based on a specific criteria statement.
see the Filter column example |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Range column | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The Range column is a mapping ( or partitioning ) of a numerical column into number of ranges or levels that you specify.
See the Range column example |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Keyword column | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The Keyword column is a straight and easy way to reclassify any data text column by searching for a keyword among the contents of the column.
see the Keyword column example |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Classification column | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The Classification column is the general form of the filter column. You can classify your data using the Enter Value - Criteria Dialog into a number of categories each has its own criterion.
SuperQuery scans all the data rows evaluating each criterion at each row. The category name associated with the first criterion that evaluates to TRUE, is placed in the classification column. If none of the criteria matches, SuperQuery inserts “Unclassified” in the Note you may replace the "Unclassified" word by writing any word at the row following the last row containing a value - criteria pair.
See the Classification column example |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Formula column | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The Formula column contains the result of execution of one or more calculation statement that you specify.
see the Formula column example |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Edit Tab Title Dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Enter or edit the title of the selected tab. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Add / Edit Summary Table Dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
You can create or select a summary table from the "Select / Add Summary Table" box. Select the “Group By” column(s) that you want to summarize your table on. This column should represent groups of values. Therefore, The "Group By" box will not show key columns or columns that has no repeated values.
If you want to select more than one Group By column, press the More button that will display four more combo boxes. Check the Ascending check box if you want to summarize columns in ascending manner or uncheck it to summarize in a descending manner.
Press the ” Select Cols” button to display the Select columns and their summary calculations dialog to select the summary columns and their associated calculations.
When you finish entering all the information, press the OK button, the system will then display a progress bar indicating its progress in creating the summary table.
You can also delete an existing summary table by selecting the table from the "Select / Add Summary Table" list and press the “Delete” button. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Add / Edit Table Index Dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
This dialog allows you to edit an existing Table Index or to create a new index. The dialog consists of: ·Select / Add Index group contains:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Add / Edit Virtual Columns dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
This dialog allows you to create a new ( or edit an existing ) Virtual Column . The dialog consists of:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Add New Table View Dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Use this dialog to select the data table of the new view. If you want to select the view layout of the new view press the “View” button, the system will display the View Layout Dialog to select the layout.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Change Pane Type dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Select one of the pane types from the “Change pane type to:” Combo box that contains all the available pane types. These pane types are the ones that do not exist in the current Table View. A Table View can not contain more than one pane from the each type.
Since the Data Table Pane is the main Table View Pane, you can not change its type to any other pane type.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Change Row Heights dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
This dialog allows you to change the height of grid rows. The new height is applied to all grid rows. Since the individual grid row height may be changed, the dialog will always show the first row height.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Edit / Add Keyword dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
See the Keyword column example
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Edit Calculation Statement dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
This Dialog allows you to create calculation statements by selecting an operator and its operands. A list of six buttons shows the five different types of operators and the sixth button selects all types together. When choosing one of these buttons, the “Select operator” list box displays a list of operators from that type.
After you choose the operator, the “Operands - Current row” group will show the required number of operands.
An operand combo box contains:
You can also enter directly any number or text as the operand value.
As a quick test of your statement, you can press the “Calc” button to view the value of operands at the current row, as well as the result of the calculation statement. You can review the result for other rows in the table by using the right and left arrow buttons to change the current row position.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Edit Criterion dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
This dialog allows you to edit a criterion by selecting the operator and the operand (s).
The Value edit box allows you to type one or more values. When entering more than one value, separate each value by a comma.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Edit Criteria Dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Select the criterion operator from the ‘Criterion Operator’ combo box that contains all relevant operators.
Enter the Criterion values directly into the ‘Value (s)’ edit box or, press the values button to display Select Value(s) Dialog and select from a list of data table values.
To enter more than one value type the letter comma ‘,’ to separate them. The system will do it automatically if you select the values from the Select Value (s) Dialog.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Edit Foreign Keys Dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
In order to define a foreign key(s) you will have to specify the foreign table and its primary key from within the same database and to associate them with one of the table( the one you are editing) columns.
The dialog displays all the column names in the table you are editing to select the foreign column (s) from them.
Click on the drop-down button next to foreign column you selected under the “Foreign Table- Key” column to display all the [ Primary Table - Key ] combinations in the open database to associate on combination with selected foreign key.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Edit No. of Graph Bars dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
This command changes the number of bars in the graph. The default number of bars is seven. The system will automatically update the graph with the new number of bars.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Edit Tab Title Dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Enter or edit the title of the selected tab.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Edit Table Index dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The Edit Table Index dialog allows you to edit an existing Index. It allows you to select up to five columns to index your table on. The table will be sorted on the first column then the second and so on up to the last index column. To build a new index, you enter the name of the index in the Add / Edit Table Index dialog, then press the Edit button to display the Edit Table Index dialog.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Edit Table Keys Dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The dialog displays all the open tables in the current database in the “Table” column.
Click on the drop-down button next to the table you want to define its primary key
To select the foreign key (s) double click on the “Foreign key” cell next to the table you want to define its foreign key (s), or place the active grid cell on the table and click on the “Edit Foreign Key” button.
The Edit Foreign Keys Dialog will be displayed for you to define the foreign keys of the table. After you finish with the dialog the keys you defined will be displayed in the cell next to the table under the “Foreign Key” column.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Enter criteria Dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
This dialog allows you to specify which columns as well as which rows to read. Select the columns you want to read from the data table by checking or un-checking the boxes in the “Select” column.
To specify criteria, follow these steps: (example: Color = Red and Shape = Box)
On the other hand, to OR a criterion, instead of using the same vertical column as in step 4, use another vertical column.
The rule is simple; any criteria sharing the same vertical column in this dialog are ANDed otherwise they are ORed. Read the final criteria from top to bottom.
The complete criteria are always displayed in a text box at the bottom of the dialog. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The Enter Ranges dialog consists of a grid with three columns; the Value column, the Minimum range and the Maximum range. You can classify any numeric column into a number of ranges by entering the name of each range in the Value column and the corresponding maximum value.
The first minimum value and the last maximum value are automatically calculated by the system. As the data table is updated, the minimum and maximum are automatically recalculated.
SuperQuery copies each maximum to the minimum of the following range. This ensures the continuity of all ranges.
There are a number of pre-defined ranges that you can, these are:
You can change the number of ranges from 3 as shown above to 5 by checking the 5 - Ranges button. The system will add two more ranges by adding the word “very” to both the first and the last ranges. You can edit these names and you can also add and delete any range values. ·Recalc. Min. & Max.
The Recalc. Min. & Max. button recalculates all the minimum and maximum ranges.
·Clear Grid The Clear Grid button clears all ranges and entries made by you leaving the two default rows.
·Delete Range The Delete Range button deletes the current range.
·Add Range The Add Range button adds a blank range above the current cell.
See the Range column example
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Enter Value - Criteria dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
This dialog is a list of value / criteria pairs. For each row in the table, the system evaluates each of these criteria. If a criterion is satisfied, the corresponding value is placed in the classification column. If none of the criteria were satisfied, the system places “Unclassified” in the corresponding row in the classification column.
You can change the “Unclassified” word by entering any text in the value column without an associated criterion at the last entry.
This dialog consists of grid with two columns:
The Insert row button is used for inserting a blank line above the current cell. The Delete row button deletes the current line.
·See the Classification column example
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Enter Value - Formula dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
This dialog allows you to easily create comprehensive calculations. It allows you to break down the formula into a number of calculation statements. Each calculation statement is evaluated separately on the current row of the Data Table. The result is placed in the last column in the table to allow you to test its functionality.
The “Variable” column contains the name of the Calculation Statement. You can enter any name. Double click on the Calculation statement column to display Edit Calculation Statement dialog and edit the calculation statement.
Since calculating the last calculation statement will automatically calculate all statements involved, the system will only execute the last calculation statement.
The Insert row button is used for insetting a blank calculation statement above the current cell. The Delete row button deletes the current row with its content.
see the Formula column example |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Add / Edit Table Facts Dialog (Fact Discovery Engine) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Enter a new name in the ‘Select / Add Fact’ list box to create a new facts table or select one of the existing tables to edit.
The "If Condition" and "Then Conclusion" combo boxes allow you to instruct the engine to search using one or all columns in the condition part and in the conclusion part.
For example, in the following fact; Most products where Product = Jacket have Profit = High. Percentage = 80% "If Condition" column is Product and the "Then Conclusion" column is Profit.
You can store new facts in a new Table or you can use an existing Facts Table. If you use an existing facts table, then you can append or replace the new facts to the table. Check the “Append new facts” box to append any new generated facts to the selected Facts Table. If you uncheck the button the new facts will replace the existing ones.
To delete a Facts Table, select the table first then, press the delete button.
You can select whether you want Facts, Exceptions or both from the radio button group.
You can press the Filters button to remove or add certain types of facts. You can also use the Dependency button to specify interdependent groups of columns. The engine will not report any facts among these dependent columns. See hints and help within each dialog.
If you need to fine tune the performance of the Fact Engine, then press the Settings button to display the Fact Settings Dialog.
Press the Run button to start the Fact Engine. The system will then automatically generate facts, add them to the Facts Table, and arrange them in a new view. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Fact Engine Dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Since you might be interested in facts about a specific column or about all column, the [Search for facts about:] combo box allows you to instruct the engine to search using one or all columns in the conclusion part.
For example, in the following fact; Most products where Product = Jacket have Profit = High. Percentage = 80%.The " Conclusion" column is Profit.
You can select whether you want Facts, Exceptions or both from the radio button group.
You can use the Dependency button to specify interdependent groups of columns. The engine will not report any facts among these dependent columns. See hints and help within the Dependency dialog.
To increase or decrease the number of facts discovered , change the [Discover] slider. When you increase the slider, the engine will discover more facts by decreasing the support level requirements. This means that the engine will not require each fact to be supported by many data rows. On the other hand, when you decrease the slider, the engine will report less facts by raising the support requirements. This means that the engine will report those patterns supported by a larger number of data rows. Support level is the number of data rows that satisfies the fact or rule.
Press the Run button to start the Fact Engine. The system will display "Facts Progress Dialog" that displays the engine performance as it discovers facts.
After the system discovers all the facts, it displays the "Fact engine save results dialog" to allow you to browse through the facts and to give you the option to write facts to one of the following format: "If ... Then", "Fact - Exception..." or " Tab Delimited". |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Fact Filters Dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Ignore blank values The Engine will ignore any value that is blank in either the condition or the conclusion side.
Ignore facts between a virtual column and its sources The Engine will ignore any facts among a virtual column and all its source columns.
Ignore facts that conclude a most common value (MCV) If this box is checked, the Engine will ignore all facts that have in the conclusion part a value that is already the most common value. For example, The fact that “Most Objects where Color = Red have Shape = Box” is ignored because “Box” is already the most common value in the Shape column. In other words, “Most objects have Shape = Box” is already given. In this Example Box is the MCV with 75% because we have 6 Boxes divided by 8 rows.
Example Table:
Ignore type "All" Apply the above filter on facts of type “All”.
MCV > .. % For the “All” filter, specify the percentage after which a value is considered a MCV.
Ignore type "Most" Apply the above filter on facts of type “Most”
MCV > .. % For the “Most” filter, specify the percentage after which a value is considered a MCV. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Fact Settings Dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
There are two sets of sliders used to fine tune the fact finding performance. The first set is the Facts settings sliders and the second is the Exception settings set.
In the Facts set, each slider controls the number of facts reported in a specific range. The first slider controls facts that are of type “All” and have a 100% confidence. The second slider is for facts of type “Most” and in the confidence range from 80% to 99%. The rest of the sliders cover the remaining 4 ranges. Sliders that control confidence ranges less than 50% are only useful when fact level is more than 1.
For example, if you increase the first slider, you will increase the number of facts reported that have a confidence of 100%. The fact engine will take more time and the new facts will be supported by fewer rows from the table.
In the Exception set, the first slider control exceptions that are less than 1% and the remaining sliders control the range up to 10%. When you increase a slider, you increase the number of exceptions reported in that range. On the other hand, decreasing the slider value, requires a higher clustering level. On the other hand, increasing the slider value, relaxes the clustering requirements.
Minimum Confidence Level: This combo-box allows you to define the minimum confidence in reported facts. For example, if you select 70% then any fact of type Most must have at least 70% confidence factor. The confidence factor is the percentage of rows satisfying the fact to all rows in the filter. The default level is 60%. For example, the following table describes abstract objects that have color, shape and weight.
The following fact is generated if the “Most Level” is set at 60%. Most(75%)objects that have Color = Red have Shape = Box (3 rows) Consequently, if the “Most Level” is increased to 80%, then this fact is not reported.
Maximum fact level: This combo-box allows you to define the Fact Level. The fact level is defined by the number of columns in the fact left side. For example in the following table,
The fact: Most objects that have Color = Red have Shape = Box, is fact level 1 because it has one column at the left side (Color). On the other hand, the fact: All objects that have Color = Red and Shape = Box have weight= 100, is fact level 2 because it has two columns at the left side( Color and Shape ).
Increasing the fact level increase the fact finding time. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| File Save As dialog box | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The following options allow you to specify the name and location of the file you're about to save:
File Name Type a new filename to save a document with a different name. A filename can contain up to eight characters and an extension of up to three characters. SuperQuery uses the extension sqd to the name you specify. Drives Select the drive in which you want to store the document. Directories Select the directory in which you want to store the document. Network... Choose this button to connect to a network location, assigning it a new drive letter.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Find dialog box | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Use the find dialog to search for a word in the current Data Table column of the current view. You can select the search pattern by either checking the Match whole word only or the match case. The Match whole word only will exact compare the column fields with the word given. On the other hand the Match case will compare the fields taking into consideration the case sensitivity of the given word.
The dialog will then move the active cell of the Data Table pane to the first match found however, if the dialog fails to find a match the Data Table active cell will remain in its position and not move.
You can also control the direction of the search by selecting one of the Direction group buttons Up or Down.
Find next button will try to find the next match in the column fields. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Insert Tab(s) Dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Enter the number of tabs in the new level. The system will insert the new tab level into the current active tab. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Panes Management Dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Select one of the following available pane types to replace the pane you selected:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The following options allow you to specify how the document should be printed:
Printer This is the active printer and printer connection. Choose the Setup option to change the printer and printer connection.
Setup Displays a Print Setup dialog box, so you can select a printer and printer connection.
Print Range Specify the pages you want to print:
Copies Specify the number of copies you want to print for the above page range.
Collate Copies Prints copies in page number order, instead of separated multiple copies of each page.
Print Quality Select the quality of the printing. Generally, lower quality printing takes less time to produce. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Print Progress Dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The Printing dialog box is shown during the time that SuperQuery is sending output to the printer. The page number indicates the progress of the printing. To abort printing, choose Cancel.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Print Setup dialog box | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The following options allow you to select the destination printer and its connection.
Printer Select the printer you want to use. Choose the Default Printer; or choose the Specific Printer option and select one of the current installed printers shown in the box. You install printers and configure ports using the Windows Control Panel.
Orientation Choose Portrait or Landscape.
Paper Size Select the size of paper that the document is to be printed on.
Paper Source Some printers offer multiple trays for different paper sources. Specify the tray here.
Options Displays a dialog box where you can make additional choices about printing, specific to the type of printer you have selected.
Choose this button to connect to a network location, assigning it a new drive letter. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Select & Reorder Columns Dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
This dialog allows you to select columns that will be displayed in the view. You can also change their order. When you run the Facts Engine on a view, only those columns selected in the view are processed. The dialog consists of the following four columns:
Select column contains check boxes to select / deselect a column.
Column Name column contains all the table column names including all virtual columns.
Sql Type column contains the Sql type of the corresponding column. The Sql type is useful in deciding whether to include or to exclude the column.
Ana Type column contains the Analysis type of the column. This is either “Normal” for data columns, or one of the Virtual column types.
You can move the position of any column by placing the cursor on that column and pushing the Up or Down arrow or use the drag and drop property.
To add a foreign column to the table, press the “Add foreign col” button. This invokes the Select Foreign Table Dialog to let you select the foreign column that you want to add. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Select & Reorder Statistical Calculations Dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Use this dialog to select or de-select the statistical calculations you want to apply to data columns. You can also change the order of the appearance of the calculations by using the up and down buttons or by using drag and drop. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Select columns and their summary calculation dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The dialog contains a list of all table columns with their corresponding Sql type. Select all columns that you want to include in the summary table by checking the corresponding check box. In the “Calculation” column, click on the corresponding drop-down button to select one of the summary calculation. SuperQuery gives the new summary column a name that consists of the selected summary operator and the data column name. However, you can write a different name in the “New Column Name” next to the selected column.
Sometimes, it is useful to summarize one column with more than one operator (for example you may want to summarize Sales with the average, total and maximum operators). You can do this by duplicating the data column (Sales) and selecting the required summary operator for each duplicate. ·Select the data column and press the “Duplicate Line” button. ·Select the new summary operator from the “Calculation” column. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Select Dependent Column Groups Dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Press any Group button to select the group of columns that are interdependent. This will display the Select Dependent Columns Dialog. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Select Dependent Columns Dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Click on all columns from the Multiple Selection List that are interrelated. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Select foreign columns with many-to-one relation dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The dialog lists all the columns existing in the foreign table. Select the column(s) you want to add to your table. Since the relation between this table and the foreign table is many-to-one, you will be able to select one of the summary operator. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Select foreign columns with one-to-many relation dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The dialog lists all the existing columns in the foreign table. Select the column(s) that you want to add to your table and optionally rename it. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Select Foreign Table Dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The Dialog displays all open tables in the current database. Select the table from which you want to bring foreign column (s). When you press the “Select Cols” button, SuperQuery displays either the Select foreign columns with many-to-one relation or Select foreign columns with one-to-many relation. This depends on the relationship between the current table and the foreign table. This will enable SuperQuery to either: show the associated value in the many-to-one case, or summarize a number of values into one value in the one-to-many case. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Select Table dialog consists of two list boxes:
·Databases list which contains all open databases ·Tables list which displays all tables contained in the database currently selected in the database list.
You should select a database then select one of its tables. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Select value(s) Dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
This dialog consists of a list box that contains all the different values in the selected column. Select one or more of these values depending on the Criterion Operator you chose from the Edit Criterion dialog. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| View Layout Dialog | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Select one of the following four layouts for the new view you are creating:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| File menu commands | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The File menu offers the following commands:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Table menu commands | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Tab menu commands | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| View menu commands | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Window menu commands | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The Window menu offers the following commands, which enable you to arrange multiple views of multiple documents in the application window:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Help menu commands | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The Help menu offers the following commands, which provide you assistance with this application:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Open Wizard command (Table menu) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
SuperQuery can open most common types of databases directly using “Data Access Objects”. Also it supports ODBC if you have both ODBC and your database drivers installed.
Select Open Wizard menu item to help you in opening your data. After opening the data table, the Wizard will give you the options to:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Update Wizard command (Table menu) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
SuperQuery allows you to update your data tables. SuperQuery will read the new data from the original source ( you can specify another source ) and update the entire analysis.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Analysis Wizard command (Table menu) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Select Analysis Wizard menu command to run the Analysis Wizard to help to perform one of the following analysis: |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Link command (Table menu) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
hen you have a database open, you can link its tables. This allows you to synchronize table views and exchange foreign columns among these tables. Linking your tables requires you to define both primary key and foreign key(s). SuperQuery provides the Edit Table Keys Dialog to help with this process. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Export (Table menu) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
SuperQuery allows you to export both the data tables and the generated facts into text files. Select Export | Tab delimited to export data tables into a tab delimited file. The system will display the Select Table Dialog to select a table that you want to export, then will display the Save As dialog to save the new file.
Select Export | Facts to export the facts generated into a "Fact - Exception" format text file. Select Export | Rules to export the facts generated into an "If ... Then" format text file. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Close command (Table menu) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Choose the Close command menu to remove a table from memory. The system will display the Select Table Dialog to select a table that you want to close. The system will also close all its associated views (if any) from the document. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Synchronize Children command (Tab menu) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
When you have more than one view in the same tab you may use this command to synchronize all those views. This means that SuperQuery will try to synchronize the scrolling of all views in this tab.
For views on the same table, if you move in one view to row 100, all other views will also scroll to row 100.
All views will have row 100 as the current row.
When you have views on different but related tables, SuperQuery will synchronize them depending on their relationships.
For example, let us assume that view 'X' is a Customer view and view 'Y' is an Orders view. Each customer may have a number of orders. Therefore, there is a "one to many" relation between customer and orders ( or a "many to one" between orders and customers). Now, if you scroll in the customer view to customer 'A', SuperQuery sets a filter on all orders from customer 'A' in the Orders view. Consequently, when you scroll in Orders to order 'B', SuperQuery finds the customer associated with that order and make it the current row in the Customer view. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| New command (View menu) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Choose the New command menu to create a new view on any of the open tables. SuperQuery displays the Add New Table View Dialog to let you select the database and table that you want to view. If you want to select the view layout, press the “View” button to display the View Layout Dialog and select one of the four layouts |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Export command (View menu) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Select Export | Tab delimited to export active data view into a tab delimited file. SuperQuery displays the Save As dialog to save the new file. Select Export | Facts to export the facts generated view into a "Fact - Exception" format text file. Select Export | Rules to export the facts generated view into an "If ... Then" format text file. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Set / Reset Filter command (View menu) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Index menu command (View menu) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Export command (View menu) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Select Export | Tab delimited to export active data view into a tab delimited file. SuperQuery displays the Save As dialog to save the new file. Select Export | Facts to export the facts generated view into a "Fact - Exception" format text file. Select Export | Rules to export the facts generated view into an "If ... Then" format text file. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Update Panes command (View menu) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Use this menu command if you have selected the Fast Scrolling Option and you want to update all panes in the active view. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Panes Management menu command (View menu) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Use this command to display the Panes Management Dialog. Use this dialog to select a pane and change its properties. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Fast Scrolling command (Options menu) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Use this command to instruct SuperQuery not to update all panes in the view when scrolling in the Data Table Pane. This will allows you to scroll faster in the Data Table Pane. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| Normal Scrolling command (Options menu) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Use this command to instruct SuperQuery to update all panes whenever you scroll in the Data Table Pane. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||