|
New Report
|
|
Creates a new report. |
|
Save
|
|
Saves the report. The first time that you save the report, you are prompted to specify a name and location. |
|
Save As
|
|
Saves the report to a location you specify. |
|
Cut
|
|
Removes the selected column from the report and places it on the Clipboard for pasting. |
|
Paste
|
|
Places a cut column back into the report to the left of your cursor. |
|
Delete
|
|
Removes the selected column from the report. |
|
Undo
|
|
Returns the report to the way it looked before the last action. |
|
Redo
|
|
Performs the last undone action again. |
|
Run with all data and Re-prompt
|
|
A Query Studio report retrieves data as soon as you open or modify it. However, you can run a report to retrieve any recently updated data.
Running a report with all data could take some time, depending on the data.
You can add prompts to reports that request that the user make selections about the contents of the report before the report is run. Clicking this icon displays the prompts.
|
|
Filter
|
|
Limits the report results for data in selected column. |
|
Sort
|
|
Orders the data in a selected column in either ascending or descending order. |
|
Summarize
|
|
Calculates the total, count, maximum, minimum, or average of the values in individual report items. There are many predefined summary features.
See the Cognos Query Studio User Guide or online help.
|
|
Calculate
|
|
Performs a calculation on a selected column. |
|
Drill down
|
|
Drills into a related drillable data. |
|
Drill up
|
|
From a drilled-down data item, returns to the data on an upper level. |
|
Go to
|
|
Goes to another report either in Query Studio or Report Studio.
|
|
Chart
|
|
Creates a chart based on the report data. |
|
Group
|
|
Sorts the data and suppresses duplicate values in a selected column. |
|
Pivot
|
|
Changes a sectioned report to a crosstab report. |
|
Ungroup
|
|
Restores the duplicate values in a grouped column. |
|
Create Sections
|
|
Makes different sections of the data based on column selected. For example, if you select the Switch Analysis > Discovery State column, different state sections are created: Discovered, Full, Missing, and Partial. |
|
Swap Rows and Columns
|
|
Changes column data to row data and row data to column data in crosstab reports or charts based on crosstab reports. |
|
Collapse Group
|
|
Collapses a report's details, making it easier to find higher levels. |
|
Expand Group
|
|
Expands the collapsed levels of a report. |
