Cognos Overview

Cognos reporting tools, along with the Banner Operational Store (ODS) and Banner Enterprise Data Warehouse (EDW), allows business users at all levels of the institution to have near-time access to operational data formatted in a manner that facilitates reporting.

The tools in Cognos are:

  • Cognos Connection - Use as an access point to existing reports (including your own in My Folders) and schedule reports to run.
  • Report Studio - Use this tool to build reports on any of the Banner ODS packages you have permission to use.
  • Query Studio - This tool has been used to build reports. It is being phased out by IBM. Convert any Query Studio reports to Report Studio
  • Cognos Workspace - Use this tool to build your own workspace (also known as a dashboards). Charts and reports included will update with the current data in Banner ODS when you open up the workspace. You can designate a workspace as your Home.
  • Cognos Workspace Advance - Use this tool to build reports including tables, crosstabs (matrixes) and charts.

Faculty and staff who wish to build reports in Banner ODS need to have an account set up and attend training. To log into Cognos, follow How to log into Cognos.

Click on the link below to jump to a section.

Data Protection Guidelines

Policies and procedures are consistent with overall institutional policies regarding release of student information as outlined in the Release of Student Information memo and the FERPA Summary document from the Office of the Enrollment Services to ensure compliance with the Family Educational Rights and Privacy Act (FERPA) and in the Acceptable Use policy in A Guide to Computing Resources.

  • We may not disclose any information about students, other than directory information, to unauthorized persons or organizations. Non-disclosable information includes things like social security number, grades, academic standing, which classes a student is enrolled in, how many credit hours the student has earned, test scores, student disciplinary records, and any other information considered an education record.
  • Directory information at SOU includes: name, local and permanent addresses and telephone numbers, date and place of birth, academic major, participation in officially recognized activities and sports, dates of attendance, enrollment status, degrees and awards received, and the most recent previous institution attended. We cannot release any information, even directory information, for a confidential student. We cannot even acknowledge that the student is at SOU.
  • Data which is identifiable to particular individuals (e.g. inclusion of names, social security numbers, student ID's, addresses, telephone numbers) shall be used only by persons with a legitimate educational interest and within the scope of the individual's responsibilities (e.g. instructors may access data for classes which they teach, departments for their majors, etc.). A legitimate educational interest means that the person is required to perform certain duties and these duties involve the use of student data.
  • Any release of individual or aggregate student information to anyone outside of SOU who have a legitimate educational "need to know" must be authorized by the Office of the Enrollment Services consistent with a written request stating the use of the data.
  • Anyone with Banner ODS access must ensure that such data is not available to individuals who do not have access to the same data via a normal Banner account or who do not have a legitimate "need to know". The individual with Banner ODS access is responsible for providing security and auditing that security on a regular basis.
  • The actual data is made available only in Banner ODS via an authorized user ID and password. Data which is saved locally must be adequately protected from outside access. We recommend that you password protect all saved data files and use the Windows workstation locking feature or screensaver password on all of your computers with this data. Saved data must be updated frequently enough such that the likelihood of incorrect data being used is minimized.
  • Requests for data or the use thereof which are outside the users' scope must be authorized in advance by the Office of Enrollment Services consistent with a written request stating the use of the data.
  • Requests (or subpoenas) for individual or aggregate student information from law enforcement authorities (including campus security, FBI, CIA, District Attorney) or legislative officials should be referred to the appropriate executive dean.
  • Printed reports with student ID's, social security numbers, confidential students, or FERPA protected data should be kept in a protected environment and shredded when disposed of.
Glossary
  • Attribute - A building block of information within a view. Many attributes in a view come directly from fields in the source database (Banner). Other attributes are derived either through calculations or the logic defined in a function.
  • Banner Enterprise Data Warehouse (Banner EDW) - An informational database that enables an institution to keep time slices of data over time, over history, stored for easy retrieval and comparison. The Enterprise Data Warehouse is an extension of the Operational Data Store, which is the primary source of aggregated and detailed data.
  • Banner Operational Data Store (Banner ODS) - The primary source of aggregated and detailed data is comprised of over 300 reporting views containing data across subject areas applicable to higher education. Because of the size and scope of the Banner ODS data model, reporting views are grouped into logical business concepts to better illustrate the various business uses. The data models are grouped into the following sections : Accounts Receivable, Common, Finance, Financial Aid, Human Resources and Student.
  • Canvas - An area within a workspace (dashboard) that users interact with to create, view, and manipulate content and data.
  • Charts - Graphical interpretation of the data. Cognos Report Studio can be used to create many chart types, such as column, bar, area, and line charts.
  • Crosstab Report - Use crosstab reports, also known as matrix reports, to show the relationships between three or more data items. Crosstab reports show data in rows and columns with information summarized at the intersection points.
  • Data Item (Query Item) - A representation of a column (fields) of data in a data source. Data items may appear in a model or in a report and contain a reference to a database column, a reference to another data item, or a calculation.
  • Data Objects (Query Objects) - The tables of information stored in the database. They have additional information, or data items, associated with them.
  • Dimension - A structural attribute of data that consists of pieces of information of a similar type. A Geography dimension, for example, may contain data about regions, countries, cities, states. A time dimension contains year, month, day and hour members. A multidimensional data structure allows data to be organized and analyzed in a concise, efficient way.
  • Facts/Measures - Numbers that are related to the attributes. Facts and measures (the terms are synonymous) generally represent counts, sums or percentages and other ratios. They may be stored and retrieved or calculated from stored measures as the query is executed.
  • Filter - A filter is used to defined or restrict the data that is shown on a report.
  • Grouping - In reporting, the process of organizing common values of data items together and only displaying the value once.
  • Incremental Refresh - Data in the Banner ODS is updated, or refreshed, at predetermined intervals of time. Only the data that has changed in the source database (Banner) since the last refresh is updated.
  • List of Values - A list of values is a set of valid values (codes) for a column in a reporting view. A List of Values generally includes the description along with the code.
  • Model - A physical or business representation of the structure of the data from one or more data sources. A model describes data objects, structure, and grouping, as well as relationships and security. In Cognos, a model is created and maintained in Framework Manager. The model or a subset of the model must be published to the Cognos server as a package for users to create and run reports.
  • ODS Business Concepts - Business concepts are used to organize the data available for different reporting requirements. A business concept shows the relationships between the data supporting a set of business processes. Because different business processes often require different perspectives on data, the relationships among the supporting database objects need to change based on the being performed.
  • ODS Composite View Meta Data - The composite views gather Banner source data necessary to populate and maintain the information stored in the Banner ODS.
  • ODS Reporting View Meta Data - Meta data in Banner ODS tells what data columns are in Banner ODS , a definition of their business use, the type of data (number, character, date, etc.), how long they are, where they come from (in the source system) and their destination (in the target system.)
  • Package - A package is a subset of data in Cognos designed to support a specific set of reporting needs. They are used by Report Studio to access data for the reports being built. Within the various Cognos tools you can report against only one package at a time. When creating a new report, you are prompted to select which package to use.
  • Prompt - A prompt is used to create a list of values that can be selected from. The report will be built (or filtered) based on the prompts selected.
  • Relationships - How the data objects are joined together. They allow users to create reports using more than one data object.
  • Report - A set of data deliberately laid out to communicate business information.
  • Slotted View - Slotted views group similar information in one row instead of multiple rows to make reporting simpler. An example could be Student holds. Instead of having separate rows for each hold a student has, there would be one row with up to 5 holds in separate fields. Which holds show in the slotted view is based on Display Rules that are defined by the Institution. The number of slots in different slotted view varies.
  • Sort - Presentation options for organized appearance. Puts the data in alphabetical or numerical order that is either in ascending or descending order.
  • Source Function - Functions that use data from the Banner tables to create new data that is stored in the Banner ODS.
  • Source Table - Tables from the Banner database where the data is coming from.
  • Target View - Banner ODS reporting views that contain information from the related Banner tables.
  • Widget - A portable, reusable application or piece of dynamic content that can be placed into a workspace (dashboard) receive input, and communicate with an application or with another widget.
  • Workspace (Dashboard) - A web page that can contain one or more widgets that graphically represent business data.

Help Available

We have several different methods of help available for Cognos and Banner ODS:

Back to Cognos Overview


How to log into Cognos

inside.sou.edu provides access to Cognos along with many other applications. When you access Cognos from Online Services within inside.sou.edu, it will open up Cognos in a new browser tab or window.

  1. Get into Mozilla Firefox.
  2. Log into inside.sou.edu.
  3. Click on one of the Cognos links in the Online Services block.
    • Cognos Home - This will go the home page you have designated in Cognos Connection.
    • Cognos-FIS Reports - This goes to the FIS Reports home page in Cognos. You can use this if you have access to the FIS Reports.
    • Cognos-I*Reports - This goes to the I*Reports home page in Cognos.
  4. Enter your Network username and password and click OK.

    Cognos Login

Back to Cognos Overview


Cognos Connection

Cognos Connection is the portal to Cognos. Cognos Connection provides a single access point to all SOU data available in Cognos. You can use Cognos Connection to work with entries such as reports, analyses, queries, metrics, and packages. You can use Cognos Connection to create, run and schedule reports and distribute the results.

  • Log On - To use Cognos software, you must successfully log on. During the logon process, you must provide your network user ID and password.
  • Log Off - You log off to end your session.
  • Entry Properties - You can control the way an entry appears and behaves by modifying its properties. The properties for entries vary depending upon the type of entry selected and your privileges. For example, reports have properties to control run options while folders do not. If a property is not applicable to the type of entry you are customizing, it will not appear in the Set properties page.
  • Organizing Entries - Organize entries such as reports in a meaningful way so that you can easily find them. Creating folders to group reports. You can copy or cut a report from one folder and paste it into another.
  • Personalize the Portal - You can personalize the way data appears in Cognos Connection by changing your preferences. For example, you can set the number of entries you see in a menu. Changing the default format for reports is not recommended. It can conflict with settings in FIS Reports and I*Reports.

This document contains basic information on how to use Cognos Connection. For detailed information on how to use all of the features, refer to the following IBM Cognos Connection User Guide.

Entry Properties

You can control the way an entry appears and behaves by modifying its properties. The properties for entries vary depending upon the type of entry selected and your privileges.

General Properties

General properties appear on the General tab of the Set properties page.

  • Type - The type of entry.
  • Owner - The owner of the entry. By default, the owner is the person who created the entry. When the owner no longer exists, or is from a different namespace than the current user (like USSE System Administrator), the owner shows as Unknown.
  • Location - The location of the entry in the portal and its ID. Click View the search path, ID and URL to view the fully qualified location and the ID of the entry in the content store. Entries are assigned a unique identification (ID) number.
  • Created - The date the entry was created.
  • Modified - The most recent date that the entry was modified.
  • Icon - The icon for the entry. Click Edit to specify an alternative icon.
  • Disable this entry - When selected, users that do not have write permissions for this entry cannot access it. The entry is no longer visible in the portal. If an entry is disabled and you have write access to it, the disabled icon appears next to the entry.
  • Language - A list of languages that are available for the entry name, screen tip, and description according to the configuration set up by your administrator.
  • Name - The name of the entry for the selected language.
  • Screen tip - An optional description of the entry. The screen tip appears when you pause your pointer over the icon for the entry in the portal. Up to 100 characters can be used for a screen tip.
  • Description - An optional description of the entry. It appears in the portal when you set your preferences to use the details view. Details view appears only in Public Folders and My Folders.
  • Run history - The number of occurrences or period of time to retain run histories for the entry.
  • Report output versions - The number of occurrences or period of time to keep report outputs. Setting this value to zero (0) saves an unlimited number of versions.
  • Package - The package that is associated with the entry. If the source package was moved or deleted, the text reads "Unavailable." Click Link to a package to link the entry to a different package.
  • URL - A URL to either a file or Web site address. This field is visible only if you have read permissions for the entry. If you have write permissions without read permissions, this property is not visible.
  • Shortcut to - A path to the entry that the shortcut points to. If the referred entry no longer exists, the text reads "Source entry not found." Click Source Properties to view the properties of the source entry.
Permissions

Permissions appear on the Permissions tab of the Set properties page.

  • Override the access permissions - Whether to replace the permissions that are inherited from the parent entry.
  • Access permissions (Name, Type, Permissions) - The permissions that are set for the entry. You can grant or deny read, write, execute, set policy, and traverse permissions. Click Add to add more names to the list. Click Delete to delete names from the list.
  • Delete the access permissions of all child entries - Whether to remove the existing access permissions for all child entries so that they will use the access permissions for this entry.
Report, Query and Analysis Properties

Properties appear on the following tabs of the Set properties page:

  • Default action - The default action when the report is run.
  • Report options: Override the default values - Whether to override default run options for the report. When selected, the values that you can override appear.
  • Format - The default format, orientation, and paper size to use when the report runs. Appears only if Override the default values is selected.
  • Accessibility - Whether to create report output that supports accessibility. Enabling support creates report output that can be read by a screen reader.
  • Language - The default language to use for the report data when the report runs. Appears only if Override the default values is selected.
  • Prompt values - The values that are used to filter data when a report is run.
  • Run as the owner - Whether to use the owner credentials when the report is run.
  • Run as the owner: Capabilities only - Whether to use only the owner capabilities and not the owner credentials when the report is run.
  • HTML options: Open in design mode - Whether to open an HTML-format Series 7 PowerPlay report in design mode.
  • Number of rows per Web page in HTML reports - The number of rows you want to appear per Web page in HTML reports
  • Enable selection-based interactivity in HTML reports - Whether to enable the following in HTML reports that are viewed in Cognos Viewer: drill up and drill down, drill through, Cognos Search, watch rules, and agent notification. Note that to have watch rules evaluated in saved report output, you must select the Enable enhanced user features in saved output versions check box.
  • Enable alerts about new versions - Whether to allow report consumers to receive alerts about new versions of a saved report. If this check box is cleared, you are prompted whether to remove all users from the alert list.
  • Enable enhanced user features in saved output versions - Whether to create additional output formats so that watch rules can be evaluated and saved output versions can be imported into Cognos for Microsoft Office. Note that to enable watch rules, you must select the Enable selection-based interactivity in HTML reports check box.
  • Enable comments in saved output versions - Whether to allow users to add comments to saved reports.
  • Refresh the report cache - Create new cache data if none is available, when the report runs interactively.
  • Cache duration - The number of days or months before the report cache data expires. To enable the cache duration, select the Refresh the report cache check box.
Page Properties

Page properties appear on the Layout and Content and Page Style tabs of the Set properties page.

  • Number of columns - The number of columns used to organize the content of a page. Up to three columns can be used.
  • Content - Type of content added to a page. Use to add and remove portlets, distribute the portlets between the columns, change the order of columns and specify their width.
  • Language - The language in which the page title and instructions can be typed. It should match the product language.
  • Title - The page title. You can format the title by changing the font and character style, and the text alignment. To return to the default browser settings, click Return to default. To modify the default settings, click Custom. You can hide the title.
  • Instructions - Additional information about the page. You can format the text of instructions by changing the font and character style, and the text alignment. To return to the default browser settings, click Return to default. To modify the default settings, click Custom. You can hide the instructions.
  • Portlet style - The way a portlet appears on a page. To avoid cluttering the page, you can hide the portlet borders, title bars, and the edit button on the title bar.
Dropbox - Sharing Personal Reports with Others

If there is a report that you want to share with one or more people, you can use the dropbox folder to pass the report. This is a place to temporarily put reports that others can retrieve. This folder will occasionally be purged.

  1. Log into Cognos Connection.
  2. Go to your My Folders area.
  3. Locate the report you want to share. Click on the check box next to the report.
  4. Click on the Copy icon above the list of reports (to the right). It looks like two pages on top of each other.
  5. Go to the Public Folders by clicking on the Public Folders tab at the top.
  6. Click on the Dropbox link. It will open the Dropbox folder.
  7. Click on the Paste icon (to the right). It looks like a clipboard. Your report should now be in the Dropbox folder.
  8. The person who wants a copy of the report must now log into Cognos Connection to retrieve it.
  9. Open the Dropbox folder (under Public Folders).
  10. Click on the check box next to the report being retrieved.
  11. If multiple people are getting a copy of the file, click on the Copy icon. Otherwise click on the Cut icon (looks like scissors).
  12. Click on the My Folders tab. Go to the location you want to save the report (if you have added folders in your My Folders area).
  13. Click on the Paste icon.
Setting Up Reports to Run on a Schedule

Single or groups of reports can be scheduled to run on periodically with the results being emailed to you or a group of people. Before you can set up reports to be schedule, you will need your Cognos access modified to allow Scheduling. Create a helpdesk call requesting Scheduling ability in Cognos

To Schedule one report to run on a regular basis.

  1. Log into Cognos Connection.
  2. Go to the report you want to run regularly.
  3. Click on the Schedule icon. If you don't see the icon, click on More then select New Schedule.
  4. Set up the frequency.
  5. Under Options, click on Override the Default Values.
  6. Uncheck HTML (doesn't work in Gmail).
  7. Check the format you want (Excel 2007, PDF, Delimited text (CSV), etc.).
  8. Under delivery, leave Save checked if you want (can access report in Cognos).
  9. Click on Edit Options next to "Send a link to the report by email"
  10. You can type the email address in directly (easiest) or click on Select a Recipient.
    • If clicked Select a Recipient, Click on SOULDAP, click on Employees then click on the Search link in the upper right corner.
    • Type in part of the name and click Search.
    • Select the person who matches the click on To. to move it over.
    • Type in another name if you are sending to multiple people. (then move over)
    • Once done selecting, click on OK.
  11. Make the subject line and body of the message whatever you want it to say.
  12. Uncheck, include a link to the report (not working right now)
  13. Check Attach the report.
  14. Click OK.
  15. Under Prompt Values you can override the value being run.
  16. Click OK.

To run multiple jobs at once on a schedule.

  1. Click on the New Job icon above the list of reports.
  2. Put in a name (and description if you want) for the job. Click Next.
  3. Under the Steps box, click Add.
  4. Select the first job you want to run. Move it over to Select Entries and click OK.
  5. Click Add again to select the next job.
  6. You can set the defaults for each individual reports or create an overall default for all reports.
  7. To update individual defaults, click on the pencil icon (edit) for each report and update.
  8. To update the overall defaults, click on Set under “Defaults for all Steps”. Click Report options. Check Specify default values for all reports of this job. Update then click OK.
  9. Click Next.
  10. Click Save and Schedule then click Finish.
  11. Update the schedule to run the days and frequency you want. Click ok
  12. The job is now in your My Folder area.

To update the scheduled running of a report or job.

  1. Log into Cognos Connection.
  2. Go to the report or job you want modify the schedule for.
  3. Click on the Schedule icon. If you don't see the icon, click on More then select Modify the Schedule.
  4. Make changes and press OK.

To stop the scheduled running of a report or job.

  1. Log into Cognos Connection.
  2. Go to the report you want to run regularly.
  3. Click on the Schedule icon. If you don't see the icon, click on More then select Modify the schedule to just disable it or Remove from Schedule.
  4. If you clicked on icon or selected Modify the Schedule, Check "Disable the schedule".
  5. Click OK.

Back to Cognos Overview


Report Studio

Report Studio is a web-based tool used to author reports and analyze data. Report Studio allows you to create reports with relational or dimensional data sources, and show data in lists, crosstabs, and charts. You can also use your own external data source.

This document contains basic information on how to use Report Studio. For detailed information on how to use all of the features, refer to the following IBM Report Studio User Guide.

Launching Report Studio

There are several ways you can open Report Studio.

  • From Cognos Connection by selecting Launch Report Studio from the menu bar.
  • By clicking the button on an existing report in Cognos Connection that will open the report in Report Studio. The button looks similar like a triangle.
  • From the Cognos Connection Welcome page, select Author advanced reports.
  • From a Cognos Workspace page by selecting Launch Report Studio from the Action Menu button (circle icon with upside down triangle on the left side of the menu bar).
Working in Report Studio

To create reports in Report Studio, you must become familiar with the Report Studio environment, including the user interface, the basic report layout, and setting options.

The User Interface

The Report Studio user interface has a work area, content and properties panes, a page layers area, and a context filter area to help you create reports. We recommend that you use a screen resolution of at least 1024 by 768 pixels.

  • Content Pane - The content pane contains objects that you can add to a report. You add objects to a report by dragging them to the work area.
  • Source Tab - The Source tab of the content pane contains items from the package selected for your report, such as data items and calculations.
  • Data Items tab - describes the queries created in the report (items selected).
  • Toolbox Tab- The Toolbox tab of the content pane contains a variety of objects, such as calculations, prompts, text and graphics, that you can add to your report. To add an object, drag it to the work area or double-click on it from the Toolbox tab.
    • Text Item- Inserts a text item. The content can be static text or it can come from a query item or report expression.
    • Block - Inserts a container in which you can insert other objects. Allows you to organize objects in a grid fashion. This is useful for controlling where objects appear. Tip: You can use blocks to add space between objects. However, empty blocks are not rendered. You must insert an object or specify the height and width.
    • Table - Inserts a table, a container in which you can insert other objects (reports, graphs, etc.). This is useful for controlling where objects appear.
    • Field Set - Insert a container with a caption to it into which you can insert other objects. Similar to a Block.
    • Query Calculation - Inserts a new row or column whose value are base on a calculation.
    • Layout Calculation - Inserts a calculation into the report layout. User layout calculation to add runtime information to a report such as the current date or user name.
    • Image - Inserts link to an image file. Must be specified by a URL. We are currently only allowed to add images that exist on the SOU web server.
    • Crosstab Space - Inserts an empty cell on a crosstab edge. Allows for the insertion of non-data cells on an edge. Blank cells appear for the edge when the report is run.
    • Crosstab Space (with fact cells) - Inserts an empty cell on a crosstab edge. Allows for the insertion of non-data cells on an edge. The contents of the fact cells for the edge are rendered when a measure is added.
    • List - Inserts a list container that is used to present query results in a list fashion.
    • Crosstab - Inserts a crosstab container that is used to render the results of the query that aggregates data then arranges it in a two-dimensional grid.
    • Chart - Inserts a chart. You can insert multiple charts in your report layout.
    • Visualization - Inserts an extensible visualization in the report. (Not currently enabled.)
    • Map - Inserts a map in the report.
    • Repeater Table - Inserts a container that repeats items in a table structure.
    • Repeater - Inserts a container that repeats items across a single row without a particular structure.
    • Singleton - Inserts a single data item. A singleton can be inserted anywhere in a report where there is no query associated.
    • Conditional Blocks - Inserts an empty block that you can use for conditional formatting.
    • HTML Item - Inserts a container into which you can add HTML. HTML items will only appear when you run the report in HTML.
    • Rich Text Item - Inserts an object that is used to render a subset of HTML. Rich text items can render in PDF output.
    • Hyperlink - Inserts a hyperlink so that users can jump to another place, such as a Web site. There are no restrictions on this URL.
    • Hyperlink Button - Inserts a hyperlink that is formatted as a button.
    • Date - Inserts the date when the report runs.
    • Time - Inserts the time when the report runs.
    • As of Time Expression - Inserts an expression that produces a Date-Time value. The expression can be used to show report results for a specific time period.
    • Page Number - Inserts page numbers in the report.
    • Row Number - Inserts row numbers in a column.
    • Layout Component Reference - Inserts a reference to another layout object. Before you can reference an object, its Name property mush be set.
    • Metric Studio Diagram - Inserts a Metric Studio Diagram that is rendered as a static image.
    • Table of Contents - Inserts a Table of Contents that is generated in the rendered output.
    • Table of Contents Entry - Inserts an entry in a table of contents.
    • Bookmark - Inserts a link to another area within the same report. The link can be defined as a static value, a query item or as the results of a report expression.
    • Text Box Prompt - Inserts a text box prompt control where users type in values.
    • Value Prompt - Inserts a value prompt control where users select one or more values from a list.
    • Select and Search prompt - Inserts an advanced prompt control where users searches for values.
    • Date & Time Prompt - Inserts a date and time prompt control where users select a date and time value.
    • Date Prompt - Inserts a date prompt control where users select a date value.
    • Time Prompt - Inserts a time prompt control where users select a time value.
    • Interval Prompt - Inserts an advanced prompt control where users enter time duration values.
    • Tree Prompt - Inserts a data-driven prompt control that shows hierarchical information and users select one or more members.
    • Generated Prompt - Inserts a prompt control that acts as a placeholder. The report will replace this control with an appropriate generated prompt control as if it was on a generated prompt page.
    • Prompt Button - Inserts a predefined button used in prompt pages. Its usage changes according to its Type property, which can be set to Cancel, Back, Next, Finish or Reprompt.
  • Properties Pane - The Properties pane shows the formatting for an object in a report. You can change the formatting properties by using either the toolbar or the Properties pane.
Creating Reports

When you create a report, you are actually creating a report specification. The report specification defines the queries and prompts that are used to retrieve data, as well as the layouts and styles used to present the data. For simplicity, the report specification is named the report.

Specify the Package

Specify the package that will provide items for the report. A package contains a set of related objects, such as members, dimensions, filters, and calculations. When you open a package in Cognos Report Studio, these objects are visible in the Source tab.

  1. In Cognos Connection, from the Launch menu, select Report Studio (or in Cognos Workspace, select Launch Report Studio from the Action Menu). If there is more than one package available, the Select a package page appears. Otherwise, Report Studio starts.
  2. If more than one package exists, select on the one you want to use.
  3. In the Welcome dialog box, choose whether to open a new or existing report or template:
    • To create a new report, select Create a new report and choose a basic report layout.
    • To open an existing report or template, select Open an existing report and select a report.

Choose a Basic Report Layout

Report Studio includes several basic report layouts that include report objects, such as lists, crosstabs, charts and maps. You can also choose to start with a blank report or open an existing report or template.

  1. From the report actions button, select New.
  2. To change the package, click the ellipsis (...) button and select a different package.
  3. Choose a basic report layout:
    • To create a report using one of the predefined report layouts, select the layout then click OK.
    • To create a new report using another report, select Existing then click OK, locate the report, and click Open.

Search for a Specific Field

Use the Mozilla Firefox browser search to find a field within one of the views/tables.

  1. Get into Report Studio and specify the package and report type.
  2. Expand the table under Source that you want to search through (click on triangle next to table name).
  3. Click on the URL section and type <ctrl>F(the control button and the letter F together). This will bring up the browser Find in the lower left hand corner. Do not use the Report Studio Find from the menu. It does not work consistently.
  4. Type the field name you are searching for in the Find box (lower left hand corner). This will take you to matching fields as you are typing.
  5. Leave the Find box open so it can be used for later searches. Just expand the table you want to search in before typing.

Add data to a report:

  1. Select the data items that you want to appear in the report.
  2. From the Source tab, drag each data item to the work area location where you want it to appear.
  3. Note: A flashing black bar indicates where you can drop an item.
  4. Another way to insert a data item is to right-click each item and select Insert or double click on each item.
  5. Once an item is added to a report. You can drag it to other positions by holding the left mouse key on the item and dragging it to another location. Multiple fields can be selected by holding the Control or Shift key while selecting them.

Remove data from a report:

  1. If you want to remove the item from the report only (not the query), select the date item then right click and select Cut.
  2. If you want to remove the item from the query and the report, select the date item then press the delete button.

Sorting data

You can sort items to view them in your preferred order.

  1. Select the column or row to sort.
  2. Click the sort icon (or select Sort under the Data menu).
  3. Under Sort in Layout, select Ascending or Descending.
  4. To remove a sort order, select Don't Sort.

Sorting multiple rows or columns

If you want to sort more than one row or column, you can add items to sort or change the order in which they are sorted.

  1. Select a column or row.
  2. Click the sort icon (or select Sort under the Data menu) and click Edit Layout Sorting.
  3. To change the sort order when multiple columns are sorted, change the order of columns in the Detail Sort List folder.
  4. Add items to the Detail Sort List folder to sort additional items.

Filtering data

Use filters to remove unwanted data from reports. Data is displayed in the report only if it meets the filter criteria. You can combine two or more filters into a complex filter.

If you want to create a prompt/filter on a field included on the report.

  1. Select the data item on which you want to filter.
  2. Under the Tools menu, select Build Prompt Page
  3. Click on the prompt created then look at the properties pane.
  4. If you want to sort, click on the box next to Sort, then the ... Select how you want to sort and press OK. Sort Academic Periods Descending to put most recent on top.
  5. If you want to restrict the person running the report to only select one, change the value for multi-select to N.
  6. If you want to base this filter off of another filter, click on the box next to Cascade Source, then the ... Select the filter you want to build off of. This will allow only values to show that are included with the other filter.

If you want to filter on a field included on the report:

  1. Select the data item on which you want to filter. If you select two or more items, you can filter using a range.
  2. Click the filter icon (or select Filter under the Data menu).
  3. Select a filter condition from the list. Click OK.

If you want to filter on a field not on the report (good for filters that won't change):

  1. Click on the field you want to filter in the Source list.
  2. Right click on the field and select Filter for Report.
  3. Select the values you want to include and move them to Selected values. Press OK to complete the filter.
  4. If it is taking a long time to pull up the values and you know what you want to filter with, click on the + symbol under Selected Values. It will have you type the value in. Press Ok to add the value then OK again to complete the filter.

Editing filters

You can specify whether filters are mandatory and whether to apply them before or after automatic aggregation.

  1. On the toolbar, click the filter button.
  2. Click Edit filters.
  3. To edit an existing filter, select the filter that you want to edit and click the edit button.
  4. Click the new button to add new filters.
  5. To specify whether the filter is mandatory, in the Usage box, select an option. You can temporarily turn off a filter by changing the usage to disabled.
  6. To specify whether to apply filters before or after automatic aggregation, in the Application box, select an option.

Removing filters

You can remove a single filter or all filters for your report if they are no longer needed.

  1. On the toolbar, click the filter icon.
  2. To remove all the filters in your report, click Remove all filters.
  3. To remove a single filter, click Edit filters.
  4. Select the filter that you want to remove and click the delete icon.

Save a Report

Save your report to preserve the modifications you made. Reports are saved to the Cognos server.

  1. From the report actions button, select Save, or select Save As to save a copy of the report under a different name.
  2. Click on My Folders under Save in.
  3. If you are saving the report for the first time, specify where to save the report and type a file name.
  4. Under My Folders, you can create folders to organize your reports. Click on the Create New Folder icon to do this.
  5. Click Save.
Run Report

When you run a report in an export format such as PDF, delimited text (CSV) or Microsoft Excel spreadsheet (XLS), the Cognos report name is used as the exported file name.

  1. Open the report that you want.
  2. If you want to set run options, from the Run menu, select Run Options.
  3. The default values come from the run options in Cognos Connection.
  4. Change any values you want for the current session.
    • Paper size - Specify only if the output format is PDF.
    • Paper orientation - Specify only if the output format is PDF.
    • Data mode - Specify how much data is returned. All Data returns all data. Limited Data limits the amount of data returned. No Data returns artificial data instead of actual data from the data source.
    • Language- The content language sets the preferred language for the data, Cognos Viewer, dates, and so on.
    • Rows per page- Specifies the number of rows to appear on each page.
    • Prompt- Select to be prompted for each prompt defined, unless the prompt is defined in a report page. If you clear the check box, you are prompted only if the report cannot run without user intervention. For example, if a report has a single parameterized filter that is optional, you are not prompted when you run the report.
    • Include accessibility features - Specifies whether accessibility features, such as alternate text on images and charts and summary text in tables, are included in the report output.

Running Report in Different Formats

  1. From the Run menu, select one of the options to produce the report in the format you want.
  2. You can produce a report in HTML, PDF, CSV, various Microsoft Excel formats, and XML.
  3. The report runs in Cognos Viewer. Once the report has finished running, you can run the report again in the same format or in a different format. If you run the report again in CSV or XLS format, the report appears in a new browser window or tab.
Lists

Use list reports to show detailed information from your database, such as product lists and customer lists.

  • A list report is a report that shows data in rows and columns. Each column shows all the values for a data item in the database or a calculation based on data items in the database.
  • List reports automatically include an overall summary in a footer row. The default summary is used.

Group Data

Group data items in a list report to remove duplicate values. For example, you have a report that shows departments. For each department, the major is also shown. You group the department column to show only one instance of each department in the list.

  • Grouping a column automatically moves it to the left as the first column. Grouping a subsequent column moves it to the left until it follows the last grouped column. When you ungroup a column, it moves to the right until it follows the last grouped column.
  • After a column is grouped, you can move it elsewhere in the report.
  • In addition to grouping, you can specify the sort order of data items. In lists, you can sort data items within groups as well as ungrouped items. In crosstabs, you can sort row and column items.
    1. Click the column on which to group. You can click either the column heading or one of the column cells.
    2. Tip: To perform multiple groupings at once, use Ctrl+click or Shift+click.
    3. Click the group/ungroup button (or under the Structure Menu, select Group/Ungroup).
Crosstabs

Use crosstab reports, also known as matrix reports, to show the relationships between three or more data items. Crosstab reports show data in rows and columns with information summarized at the intersection points.

  • Working with Crosstab Reports - When you add data items to a crosstab, you create crosstab nodes and crosstab node members. These objects allow you to easily create crosstabs, using drag-and-drop operations.
  • Crosstabs are dimensional objects that have row edges and column edges. Each edge is composed of a set of crosstab nodes. Each crosstab node contains the following:
    • One or more crosstab node members.
    • Zero or one nested crosstab node, which contains one or more crosstab node members or nested crosstab nodes.
  • Each crosstab node member refers to a data item that contains an expression that defines the members that appear in the crosstab.
  • Create a Nested Crosstab - Nest data in a crosstab report to compare information by using more than one data item in a column or row. For example, a report shows the overall GPA average by department for the past five terms. You decide to add a data item to further break down the GPA by major.
  • When nesting columns in a crosstab report, there are four distinct drop zones where you can insert a new data item. The drop zone you choose will define the relationship between the data item and the column.
  • The following relationships are created when you insert a data item as a row:
    • Inserting a data item to the left or right of a column creates a parent-child relationship between them. When you insert a data item to the left of a column, the data item becomes a parent to the column. When you insert a data item to the right of a column, the data item becomes a child of the column.
    • Inserting a data item above or below a column creates a union relationship between them.
  • The following relationships are created when you insert a data item as a column:
    • Inserting a data item to the left or right of a column creates a union relationship between them.
    • Inserting a data item above or below a column creates a parent-child relationship between them. When you insert a data item above a column, the data item becomes a parent to the column. When you insert a data item below a column, the data item becomes a child of the column.

Swap Columns and Rows

Swap columns and rows to look at information from a different perspective. This may help you discover high and low points in the data that you hadn't previously noted.

  • You can only swap columns and rows in a crosstab or chart. In a chart, you swap the x- and y-axes.
  • From the toolbar, click the swap rows and columns button.
  • In the report, the rows become the columns and the columns become the rows.

Change a List into a Crosstab

Change a list into a crosstab to view your data from a different perspective.

  1. Click the columns to appear as columns or nested columns in the crosstab.
  2. From the Structure menu, click Pivot List to Crosstab.
  3. Results - The list becomes a crosstab with the columns you selected appearing as columns and nested columns. The unselected columns, except for measures, appear as rows and nested rows. If you have one measure, it becomes the cells of the crosstab. If you have more than one measure, they appear as columns.
  4. Tip: To make all measures appear as rows, swap columns and rows.

Adding Aggregate Data to a Crosstab.

Add totals and subtotals for the rows and overall totals for each column. .

  1. Click on the Crosstab.
  2. From the Data menu, click Summarize then how you want it summarized (i.e. Total).
  3. If you selected Total, the totals and subtotals will appear for each column will appear along with totals for each row.
  4. If you don't want all of the totals or subtotals automatically created, click on the total that you don't want, right click and select cut or delete.
Creating Charts

You can use Report Studio to create many chart types, such as column, bar, area, and line charts.

  • Before creating charts, review the available chart types to select the best chart for your needs. Also review the chart elements that make up charts.
  • To view the available chart types, from the File menu, select New, and then double-click the chart icon. You can also view the available chart types by adding a Chart object from the Toolbox tab to an existing report.
  • To create charts, drag data items from the Source tab to the measures, data series, and categories drop zones.
  • To help you when creating charts, you can do the following:
    • Resize your charts.
    • Move the chart drop zones into flyouts so that they appear only when you pause your pointer over the chart.
    • After you create a basic chart, modify the various chart objects to customize your chart.

Chart Types

Report Studio includes a number of chart types, such as column, bar, area, and line charts.

  • Column Charts - Column charts use vertical data markers to compare individual values.
  • Line Charts - Line charts are useful for showing trends over time and comparing many data series.
  • Pie Charts - Pie charts are useful for highlighting proportions.
  • Bar Charts - Bar charts are useful for showing trends over time and for plotting many data series.
  • Area Charts - Area charts are useful for emphasizing the magnitude of change over time. Stacked area charts are also used to show the relationship of parts to the whole.
  • Point Charts - Point charts are useful for showing quantitative data in an uncluttered fashion.
  • Combination Charts - Combination charts plot multiple data series by using combinations of columns, areas, and lines within one chart. They are useful for highlighting relationships between the various data series.
  • Scatter Charts - Scatter charts use data points to plot two measures anywhere along a scale, not only at regular tick marks.
  • Bubble Charts - Bubble charts, like scatter charts, use data points and bubbles to plot measures anywhere along a scale. The size of the bubble represents a third measure.
  • Quadrant Charts - Quadrant charts are bubble charts with a background that is divided into four equal sections. Quadrant charts are useful for plotting data that contains three measures using an X-axis, a Y-axis, and a bubble size that represents the value of the third measure.
  • Bullet Charts - Bullet charts are a variation of bar charts. They compare a featured measure (the bullet) to a targeted measure (the target). They also relate the compared measures against colored regions in the background that provide additional qualitative measurements, such as good, satisfactory, and poor.
  • Gauge Charts - Gauge charts, also known as dial charts or speedometer charts, use needles to show information as a reading on a dial.
  • Pareto Charts - Pareto charts help you to improve processes by identifying the primary causes of an event. They rank categories from the most frequent to the least frequent. These charts are frequently used for quality control data, so that you can identify and reduce the primary cause of problems.
  • Progressive Column Charts - Progressive column charts, also knows as waterfall charts, are like stacked charts with each segment of a single stack displaced vertically from the next segment.
  • Microcharts - Microcharts are smaller versions of column charts, bar charts and line charts that you can use in crosstabs and dashboards.
  • Marimekko Charts - Marimekko charts are 100 percent stacked charts in which the width of a column is proportional to the total of the column's values. Individual segment height is a percentage of the respective column total value.
  • Radar Charts - Radar charts integrate multiple axes into a single radial figure. For each figure, data is plotted along a separate axis that starts at the center of the chart.
  • Polar Charts - Polar charts are circular charts that use values and angles to show information as polar coordinates.
  • Range Indicator Charts - Range indicators, or metric range, charts are useful for showing a target range and tolerance range.

Chart Configurations

Chart configurations specify the grouping type of the columns, bars, lines, and areas in a chart. Some examples are standard, stacked, and 100 percent stacked charts.

  • Standard Charts - Standard or absolute charts are useful for comparing specific values and for representing discrete data, such as data for different regions or individual employees. For example, a standard column chart that plots regional sales emphasizes the actual value that each region achieves in sales.
  • Stacked Charts - Stacked charts are useful for comparing proportional contributions within a category. They plot the relative value that each data series contributes to the total. For example, a stacked column chart that plots product line sales will emphasize the proportion that each product line contributes to the total in each territory.
  • 100 Percent Stacked Charts - 100 percent stacked charts are useful for comparing proportional contributions across all categories. They plot the relative contribution of each data series to the total as a percentage. For example, a 100 percent stacked column chart that plots product line sales emphasizes the percentage within each region without referring to actual values.
  • Three-dimensional Charts - Three-dimensional charts provide a visually effective display that is suitable for presentations.

Convert Charts From One Type to Another

This procedure applies to converting charts from one type (for example, a bar chart) to another type (for example, a line chart).

  • When you convert a chart to a new chart type, Report Studio keeps the properties from the existing chart if they exist in the new chart type. For example, if you convert a donut chart to a bar chart, Report Studio maps your chart palette to the new chart, but does not map the hole size, because the hole size property does not exist in a bar chart.
    1. Right-click a chart and select Convert Chart.
    2. Select a new chart type, and click OK.
Using External Data Source for Reports

Report Studio allows an External Data Source to be created and used with Banner ODS for creating reports. You can import Microsoft Excel spreadsheet files or Delimited text files. The following is an example of setting up an Excel file of IDs as an external data source.

Create External Data File.

  1. Create an Excel file with your IDs in it. Put ID in the first row as a title.
  2. Save it in a place you will be able to get to when you run Cognos reports in the future.

Set Up External Data in Cognos

  1. Log into Cognos
  2. Launch Report Studio.
  3. Select whichever package you are creating your reports with (Student Detail, Active Registration, etc.).
  4. Select Create New.
  5. Select the type of report you are creating (List, Crosstab, etc.).
  6. On the right side under Source, look for the cylinder icon with a pencil on it (it's green). Click it.
  7. Browse for your external file.
  8. If there are multiple columns, select the columns you want loaded into Cognos. Should be at least ID.
  9. Change the name if you want.
  10. Click on Next.
  11. Click on the ... under Existing Query Subject/Report:
  12. Select Choose Query Subject.
  13. Find the main table you are going to pull data from (like Enrollment), select it and click OK.
  14. Find ID, select it then click on the "New Link" button above. If you brought in more than one column you will also need to select ID from your file before clicking on the button. This joins the fields.
  15. Click Next
  16. Change the Data type to Text.
  17. Click Next
  18. Click Finish
  19. Click Publish. What it has done is create a new package that has both the original tables from the package selected and the External Data Source. It is saved in the My Folders area.

Create a Report

  1. Select all of the fields from package you selected that you want to have included.
  2. Drag the ID field from your External Data Source (whatever its name is) to the report.
  3. This will cause the report to filter to the IDs in the External Data Source.
  4. Save the report.

Creating a new report using new package (with external data)

  1. If you are going to create a new report, Open Report Studio.
  2. When it asks you to select a package. Click on the Cognos link just below "List of all packages".
  3. Select My Folders then select the package you have External Data Source connected to (like Active Registration External Data)
  4. Build the report like before, making sure you use the IDs from your External Data Source.
  5. Save report.

Running Reports that use an External Data Source

  1. If you are still in the current Cognos session that you created the External Data Source, you can run reports without having to specify your external data file, but any changes made in the file will not show up until the next time you log into Cognos.
  2. The next time you log into Cognos and run the reports, the first one will ask you to browse to the external data file and it will read it in, refreshing the data. Locate the file using Browse, click on OK then it will run your report.
  3. You won't be asked to identify the external data file again until the next time you log into Cognos.

Back to Cognos Overview


Query Studio

Query Studio is a web-based reporting tool for creating simple queries and reports. This tool is going to be retired by IBM so any queries built in this tool needs to be switched to Report Studio or Cognos Workspace Advanced.

This document contains basic information on how to use Query Studio. For detailed information on how to use all of the features, refer to the following IBM Cognos Query Studio User Guide.

Launching Query Studio

There are several ways you can open Query Studio.

  • From a Cognos Workspace page by selecting Launch Query Studio from the Action Menu button.
  • From Cognos Connection by selecting Launch Query Studio from the menu bar.
  • By clicking the button on an existing Query Studio report in Cognos Connection that will open the report in Query Studio. The button looks similar to a pen.
  • From the Cognos Connection Welcome page, select Query my data.
Creating Reports

You can create a new report by inserting items from the data source into an empty report. You can also create a new report by opening an existing report, changing it, and saving it using another name. Do not create any new queries with this tool. Use Report Studio or Cognos Workspace Advanced to create new reports.

  1. Launch Query Studio.
  2. The Select a Package page will appears. Select the package you want to use to build your report.
  3. To exit Query Studio and return to Cognos Connection, click Return.
  4. The query items you can use are listed in the left pane. You can now add data and save the report.

Add Data to a Report

A new report contains no data. You choose the report items that you want to include in the report from the package. Included items appear as columns in list reports, and as rows and columns in crosstab reports.

  1. Open a report in Query Studio.
  2. Click the Insert Data menu command.
  3. In the left pane, double-click the items you want to add. The items appear in the work area. You can also drag item to specific locations in the work area.
  4. To simultaneously add several query items, use Ctrl+click to select multiple items, and then, at the bottom of the left pane, click Insert.
  5. To remove data permanently from your report, click the report item heading, then click the delete button on the toolbar or keyboard.

List Reports

A list report shows data in rows and columns. You can apply a filter, summary, or calculation to manipulate the data that appears in the report.

  • Query Studio defaults to automatically suppresses duplicates, summarizes detail values, and generates footer summaries for measures.
  • Query Studio defaults to build list reports when you create a report from scratch.

Crosstab Reports

Use a crosstab report to show summary information. Like list reports, crosstab reports show data in rows and columns. However, the values at the intersection points of rows and columns show summarized information rather than detailed information.

  1. Open a report in Query Studio.
  2. Click the heading of the report item you want to use as the top row.
  3. Click the pivot button on the toolbar.
  4. The values of the selected report item are now column headings. The other report items become row headings, and the measure is now at the intersection of the two.

Charts

Use charts to see patterns and trends in data. You can show just the chart, or the chart with the table appearing under the chart.

  1. Open a report in Query Studio.
  2. Reorder report items, if necessary.
  3. Click the chart button on the toolbar.
  4. In the Chart type box, click a chart style.
  5. Click a chart configuration.
  6. If you want to view only the chart, click Chart only.
  7. If you want the values to appear on the chart, select the Show the values on the chart check box.
  8. Click OK.

Swap Rows and Columns

You can interchange rows and columns in a crosstab, a chart based on a crosstab, or both. For example, if you have a crosstab report that has few rows and many columns, you can swap the rows and columns to make the report easier to read. If you have multiple rows or columns in a crosstab report, the outermost rows become the outermost columns, and the outermost columns become the outermost rows.

  1. Open a report in Query Studio.
  2. Click the swap rows and columns button on the toolbar. If you have both a chart and a crosstab report open, you can specify which to swap.

Filters

You can use a filter to specify the subset of records that the report retrieves. Any data that does not meet the criteria is eliminated from the report, which can improve performance.

  1. Open a report in Query Studio.
  2. Click the heading of the item you want to filter then click the filter button on the toolbar.
  3. You can also add filters directly from the data tree without first adding the data item to the report. To do so, right-click the data item and click Filter for report.
  4. If filters already exist for the item, do one of the following:
    • To edit the existing filter, click Modify the existing filter.
    • To create a new filter, click Add a filter to data item.
    • To create a combined filter, click Open the "Combine filters" dialog.
  5. Depending on the type of data you are filtering, select the items you want from a list or specify the range of values to include. If you are filtering text or alphanumeric values, click Search for values or Type in values.
  6. If you want to filter using a partial match (like a student attribute), choose the Type in values option (right upper corner of filter block) and click the type of operation you want to perform in the Operation box:
    • To filter on values that start with specific letters or numbers, click Starts With.
    • To filter on values that end with specific letters or numbers, click Ends With.
    • To filter on values that contain a specific word or number, click Contains.
  7. Click OK.

Use Prompt

Use a prompt when you want to use different criteria for the same report item each time the report runs. The report does not run until you choose the values or click the Finish button. If you click the Finish button without choosing any values, all data is returned. Using prompts is faster and easier than repeatedly changing the filter.

  1. Open a report in Query Studio.
  2. Click the heading of the column you want to filter.
  3. Click the filter button on the toolbar.
  4. Select the Prompt every time the report runs check box. Each time you open or run the report, you can choose or type in the desired filter values. If no filter values are specified, all data is returned.
  5. Click OK.
  6. Repeat steps 2 to 5 to add other prompts.

Sort Data

Sorting organizes your data in either ascending or descending alphabetical or numerical order.

  1. Open a report in Query Studio.
  2. Click the heading of the report item on which you want to sort.
  3. From the Edit Data menu, click Sort. Tip: You can also sort directly from the data tree without first adding the data item to the report. To do so, right-click the data item and click Sort for report.
  4. In the Sort dialog box, choose the desired sort options.
  5. Click OK. A small up or down arrow in the heading indicates sorted data.
  6. To remove sorting, from the Edit Data menu, click Sort, then under Sort order, click Don't sort, and click OK. Tip: You can delete a sorted column but keep the sort itself. Click the column you want to delete and click the delete button. The Delete dialog box appears, and you can choose to delete or keep filters and sorting associated with the column.

Add Summary

You can use predefined summaries to calculate the total, count, maximum, minimum, or average of the values in individual report items. The summaries available depend on the type of data in the selected report item. For example, the only summaries you can use with text data is Count or Count Distinct.

  1. Open a report in Query Studio.
  2. Click the heading of the report item you want to summarize.
  3. From the Edit Data menu, click Summarize.
  4. In the Summary for footers box, click the function you want. If you want to apply one summary calculation to the detail values and a different summary calculation to the footer values, or you want to change the default order of operations in a calculated column, click the Advanced link.
  5. Click OK. Tip: To remove a summary, in the Summary for footers box, click None.

Save Report

Save your report to preserve any changes. What you save in Query Studio is the query definition, which is a specific set of instructions for extracting particular data. It is not a snapshot of the data you retrieve at the time you save the report. For example, if you run a report that you saved two weeks ago, the data in the report reflects any changes in the updated data source.

  1. Click the save button on the toolbar.
  2. If you are saving the report for the first time, specify where you want to save the report and type a file name. If you want to include a description, type the information you want to add in the Description box.
  3. Click OK.
Run Report

You can run a report to retrieve any recently updated data from the data source. An Query Studio report also runs when you open it, or when you make any changes. Note: When you run a report in an export format such as PDF, delimited text (CSV), Microsoft Excel (XLS), the Cognos report name is used as the exported file name.

  1. Open a report in Query Studio.
  2. From the Run Report menu, choose how to run the report:
    • To run the report using all data, click Run with All Data.
    • To run the report using limited data, click Preview with Limited Data.

View Report in PDF Format

To save a snapshot of your report data, you can create a PDF version of your report. Note: When you want to print a report, use the PDF format for best results.

  1. Open a report in Query Studio.
  2. From the Run Report menu, click View in PDF Format.
  3. The report opens in PDF format in a new window.

View Report in Microsoft Excel Format

You can view your reports in Microsoft Excel spreadsheet software format (.xls).

  • Charts are rendered as static images.
  • Row height can change in the rendered report to achieve greater fidelity.
  • Column width that are explicitly specified in reports are ignored in Microsoft Excel 2007.
  • Merged cells are used to improve the appearance of reports.
  • The default size of worksheets is 65 536 rows by 256 columns.

Back to Cognos Overview


Cognos Workspace

Cognos Workspace allows you to build and use sophisticated, interactive workspaces (also known as dashboards) using Cognos content, as well as external data sources.

This document contains basic information on how to use Cognos Workspace. For detailed information on how to use all of the features, refer to the following IBM Cognos Workspace User Guide.

A workspace is a visual display of the important information that you want to quickly gain insight on. You can monitor a workspace at a glance. In Cognos Workspace, objects that you add to a workspace are displayed in widgets. These widgets contain content and interact with each other. They can show your data in table and graphical formats and give you direct access to run already created reports.

You can get to Cognos Workspace from Cognos Connection or define a workspace as your Home.

Launching Cognos Workspace
  • From the Cognos Business Intelligence Welcome page.
  • From Cognos Connection by clicking the new workspace button in the application bar or by selecting Launch Cognos Workspace from the menu bar.
  • By clicking the hyperlinked name of an existing workspace from Cognos Connection.
Create a new workspace
  • Update an existing workspace and save it in your My Folders area.
  • From an existing workspace press the new workspace button (second button on the left).
  • From Cognos Connection select Launch Cognos Workspace from the menu bar. If you see the Getting Started page select Create New.
  • From the Cognos Connection Welcome page, select Create my workspaces. If you see the Getting Started page select Create New.
Workspace

Use a workspace to combine data from various sources and gain insight into your business. A workspace is a collection of widgets that typically display tables or charts of data, text, images, HTML pages, or RSS feeds. Dotted guidelines appear when you insert, move, or resize widgets. They provide a visual aid to assist you in aligning widgets.

Resize individual widgets to fit content.

When you place a widget on the workspace, the widget is automatically sized to fit its content. As you interact with the widget, the content might change and the widget will not be resized to properly display the content. This results in either scrollbars or white space in the widget.

  • On the widget toolbar for the widget you want to resize, click the Widget Actions button.
  • Select Resize to Fit Content.
Layout Modification

Modify the layout of the widgets on a workspace. As widgets are added, moved, manipulated, and removed, the layout of the workspace might need to be corrected. Cognos Workspace provides the following layout actions that automatically arrange widgets on the workspace.

  1. Click the Layout and Style menu button on the application bar.
  2. From the drop-down list, select either Fit All Widgets to Window or Arrange All Widgets to Fit Content.
    • Fit All Widgets to Window - This layout action resizes all the widgets on the workspace to fit into the current workspace window. Scroll bars might appear on the individual widgets, depending on the number and size of the widgets. Widgets are resized proportionally; all of the widget resizing is done relative to the other widgets on the workspace.
    • Arrange All Widgets to Fit Content - This layout action arranges all the widgets on the workspace to best fit the content of each widget. Scroll bars might appear on the workspace, depending on the number and size of the widgets. Widgets are repositioned after resizing to prevent overlapping on the workspace.
  3. The widgets are rearranged on the workspace according the layout action you select.
Content Pane

The Content pane is available on-demand and displays the objects that you can add to the workspace. When you launch the Getting Started page, the Content pane, may be collapsed. You can expand the Content pane in the following ways:

  • On the Getting Started page, click the Create New button.
  • On the far right or left edge of the Getting Started page, click the middle of the collapsed Content pane (if it is hidden).
  • On the application bar, click the new button.
  • On the application bar, click the insert button, and select Insert Content.

The Content pane contains two tabs: Content and Toolbox. The Content tab displays Cognos content that you can add to the workspace. The Toolbox tab displays widgets that access other types of content such as, images and web pages, and widgets that control the data on the workspace. You insert objects by dragging them from the Content and Toolbox tabs to the workspace. Tip: In the Content pane, you can also right-click objects to insert them on the workspace.

Content Tab

The Content tab displays the Cognos content that can be added to a workspace and workspaces that can be opened. The content is the same content that is displayed in Cognos Connection, excluding any content that has been filtered out.

There are two expandable folders:

  • My Folders contains your personal content and workspaces.
  • Public Folders contains entries that are of interest to and can be viewed by many users.

You can filter the content you see. The available filters are accessed from the drop-down list at the top of the Content tab. You can filter by using the following criteria:

  • All Content displays all content in the content store, excluding any content that is not supported in Cognos Workspace. This is the default setting.
  • My Favorites displays workspaces and reports that have been marked as favorites.
  • My Folders displays only the content in your My Folders folder.
  • Search Results displays content based on search results. You must first perform a search, otherwise this filter is not available.
Toolbox Tab

The Toolbox tab displays additional widgets provided by Cognos Workspace. RSS feeds, Images and Web pages must be located on the SOU web server.

You can add toolbox widgets to the workspace from the Toolbox tab.

  • Image widget - The image widget is used to display images.
  • My Inbox widget - The My Inbox widget is used to show a Really Simple Syndication (RSS) feed of your secure approval requests, ad-hoc tasks, and notification requests from My Inbox in Cognos Connection.
  • RSS feed widget - The RSS feed widget is used to display RSS news feeds.
  • Select value filter widget - The select value filter widget is used to filter the data in other widgets; you select or deselect the data items you want to display or remove.
  • Slider filter widget - The slider filter widget is used to filter the data in other widgets; you display or remove data items using a range slider filter.
  • Text widget - The text widget is used to enter, format, and display text.
  • Web page widget - The web page widget is used to display HTML based content.
Widgets

Objects you add from the Content pane to the workspace are displayed in widgets. Widgets are containers that allow you to interact with and manipulate the content contained within them. Widgets have an on-demand toolbar that is displayed when the widget is selected or in focus. The available toolbar options depend on the type of widget and the content displayed in the widget. Slider filters and select value filters do not have a toolbar. To access the widget actions on a slider filter or select value filter, right-click on the widget. Widgets can also communicate with other widgets. For example, you can use a select value filter widget to control what data is dynamically filtered in a report widget.

Maximizing Widgets

You can maximize a widget to view the report content in more detail or to view the content that exceeds the size of the widget. Maximizing is useful for viewing report content in large complex tables and detailed charts that cannot be fully displayed in the widget within the constraints of the other workspace objects.

To maximize a widget, on the top right of the widget toolbar, click the maximize button. To restore the widget and view the workspace again, click the restore button. Tip: You can also modify the number of rows to display in a widget.

Content widgets

The following widgets are used when content objects are added to the workspace from the Content tab.

  • Report widget - When a report object (report or report part) is added to a workspace, it is displayed in a report widget. Report objects include reports created in Report Studio, Cognos Workspace Advanced and Analysis Studio.
  • Cognos Navigator widget - You can add an Cognos Navigator widget to the workspace by dragging a folder item from the Content tab to the workspace. Folder items include content folders and packages. Use this widget to browse a list of links that open published Cognos reports and other entries in Cognos Viewer or the associated Cognos tool.
Actions Menu

An action menu is available for the workspace and for each widget on the workspace. The items available in each menu depend on user capabilities and the type of widget selected.

The available actions at the application level include the following menu options:

  • New creates a new workspace.
  • Open opens an existing workspace.
  • Save saves changes to a workspace.
  • Save As saves a workspace with a new file name or new location.
  • Email Link sends the URL of the current workspace by email, or copies the URL to the clipboard so it can be pasted into other documents. (not currently recommended)
  • Copy Link to Clipboard copies the URL to the clipboard so it can be pasted into other documents.
  • Edit Workspace Style changes the visual appearance of the workspace style and widgets to customize the look of your workspace.
  • My Preferences sets personal preferences for accessibility support for reports, Getting Started page display, product and content language, and time zone.
  • Log On to launch Cognos Workspace. Log off to end your session.
  • Launch starts installed Cognos applications that you have permission to use.
  • Refresh All refreshes all workspace widgets.

The actions available for a widget depend on the widget content and widget type. All workspace widgets provide the following actions:

  • Remove from Workspace deletes the widget and content from the workspace.
  • Listen for Widget Events sets widget to widget communication.
  • Resize to Fit Content makes the widget the right size to display all of its content without excess white space or scrollbars.
  • Send to Back makes the selected widget appear behind other widgets when two or more widgets overlap.
  • Properties sets the available properties for the widget.

Report widgets also provide the following actions:

  • Print as PDF prints the selected widget content to a PDF document.
  • Export to creates PDF, Excel, CSV or XML format versions of the widget data.
  • Versions displays different versions of the report content if there are saved output versions available.
  • Refresh updates the widget content with the latest data.
  • Prompt Again displays the prompt values if the widget contains prompted report content.
  • Reset updates the report content to the most recent version.
  • Do More opens the report in the advanced mode. This mode allows you to change the report content and apply more advanced sorting, filtering, calculations, summaries, and formatting. (Any changes using this method would only effect the report for this specific workspace. Original report would not be modified.)
Setting a home page

You can set any saved workspace in Cognos Workspace as your home page. When you set a home page, you can click the home icon to return to your home page at anytime. You can log into your home workspace from the inside.sou.edu Cognos Home link under Online Services.

  1. Open the workspace you want to set as your new home page.
  2. On the application bar, next to the home icon, click the arrow and select Set Workspace as Home.
Saving workspaces

Save a workspace to preserve your changes. You can also save an existing workspace using a new filename or location as the basis of a new workspace. When you save a workspace for the first time, a copy of each report widget is created for the saved workspace. After you open and change the report (for example, you apply a sort), the changes are saved in this copy. The data in a report widget is not saved with the workspace. If the report widget is based on a live report, fresh data is retrieved from the data source when you open the workspace.

Editing the workspace style

You can change the visual appearance of the workspace and widgets to customize the look of your workspace. For the workspace, you can change the appearance of the background. For workspace widgets, you can change the appearance of the background, border, and title bar. Widget customizations are applied to all widgets on the workspace.

You can change the visual appearance of the workspace. Complete the following steps to set style properties for a workspace.

  1. On the application bar, click the Layout and Style menu button and select Edit Workspace Style. Tip: You can right-click a blank area on the workspace to access the Edit Workspace Style option from the context menu. You can also select the option from the workspace Actions Menu.
  2. Click the Page tab.
  3. Set the properties, and click OK.
    • Background - Specifies the workspace background. Note: A background image URL must be on the SOU web server.
Edit all workspace widgets
  • You can change the appearance of all the workspace widgets at the same time. Complete the following steps to set style properties globally for all widgets.
    1. On the application bar, click the Layout and Style menu button and select Edit Workspace Style.
    2. Click the Widgets tab.
    3. Set the properties, and click OK.
  • Specify to show or hide the title bar. The default is to hide the title bar. You can also specify the title bar font.
  • Specify to show or hide widget borders. You can also specify the widget borders formatting.

Back to Cognos Overview


Cognos Workspace Advanced

Cognos Workspace Advanced is a web-based tool used to author reports and analyze data. Cognos Workspace Advanced allows you to create reports with relational or dimensional data sources, and show data in lists, crosstabs, and charts. You can also use your own external data source.

This document contains basic information on how to use Cognos Workspace Advanced. For detailed information on how to use all of the features, refer to the following IBM Cognos Workspace Advanced User Guide.

Launching Cognos Workspace Advanced

There are several ways you can open Cognos Workspace Advanced.

  • From a Cognos Workspace page by selecting Launch Cognos Workspace Advanced from the Action Menu button (circle icon with upside down triangle on the left side of the menu bar).
  • From a report in Cognos Workspace, click on the report and on the title bar select Do more. The icon looks like a gear. Note: This method will only make changes to the report in the workspace. No changes will be made to the original report.
  • From Cognos Connection by selecting Launch Cognos Workspace Advanced from the menu bar.
  • By clicking the button on an existing report in Cognos Connection that will open the report in Cognos Workspace Advanced. The button looks similar to a compass.
  • From the Cognos Connection Welcome page, select Author business reports.
Working in Cognos Workspace Advanced

To create reports in Cognos Workspace Advanced, you must become familiar with the Cognos Workspace Advanced environment, including the user interface, the basic report layout, and setting options.

The User Interface

The Cognos Workspace Advanced user interface has a work area, content and properties panes, a page layers area, and a context filter area to help you create reports. We recommend that you use a screen resolution of at least 1024 by 768 pixels.

  • The Work Area - The work area contains the crosstab that you use to create your report. By default, you see live data as you create your report. You can switch to design mode where you see only placeholder data.
  • Content Pane - The content pane contains objects that you can add to a report. You add objects to a report by dragging them to the work area.
  • Source Tab - The Source tab of the content pane contains items from the package selected for your report, such as data items and calculations.
  • Toolbox Tab- The Toolbox tab of the content pane contains a variety of objects, such as text and graphics, that you can add to your report. To add an object, drag it to the work area or double-click on it from the Toolbox tab.
    • Text Item- Inserts text.
    • Block - Inserts an empty block, a container in which you can insert other objects. This is useful for controlling where objects appear. Tip: You can use blocks to add space between objects. However, empty blocks are not rendered. You must insert an object or specify the height and width.
    • Table - Inserts a table, a container in which you can insert other objects. This is useful for controlling where objects appear.
    • Query Calculation - Inserts a calculation.
    • Image - Inserts an image. Must be specified by a URL. We are currently only allowed to add images that exist on the SOU web server.
    • Crosstab Space - Inserts an empty cell on a crosstab edge. Allows for the insertion of non-data cells on an edge. Blank cells appear for the edge when the report is run. Insert this object when a crosstab edge does not produce useful data and you want blanks to appear in the cells instead.
    • Crosstab Space (with fact cells) - Inserts an empty cell on a crosstab edge. Allows for the insertion of non-data cells on an edge. The contents of the fact cells for the edge are rendered when a measure is added or the default measure is specified. If the crosstab space is nested, the scope of the fact cells is the scope of the item that is at the level before the space. If the crosstab space is not nested and there are no items nested below it, the scope of the fact cells is the default measure.
    • List - Inserts a list.
    • Crosstab - Inserts a crosstab. You can insert multiple crosstabs in your report layout.
    • Chart - Inserts a chart. You can insert multiple charts in your report layout.
    • Hyperlink - Inserts a hyperlink so that users can jump to another place, such as a Web site. There are no restrictions on this URL.
    • Date - Inserts the date when the report runs.
    • Time - Inserts the time when the report runs.
    • Page Number - Inserts page numbers that you can customize.
  • Properties Pane - The Properties pane shows the formatting for an object in a report. You can change the formatting properties by using either the toolbar or the Properties pane.

Work in Preview or Design Mode

By default, you see live data as you create your report. However, to see data, you must add enough information in your report to resolve the query. You can also switch to only see placeholder data, using the Page Design mode.

  1. From the View menu, select Page Design or Page Preview.
  2. To specify how many rows of data to show per page when working in Page Preview mode, from the View menu, select Preview Options and type a new value.
Creating Reports

When you create a report, you are actually creating a report specification. The report specification defines the queries and prompts that are used to retrieve data, as well as the layouts and styles used to present the data. For simplicity, the report specification is named the report.

Specify the Package

Specify the package that will provide items for the report. A package contains a set of related objects, such as members, dimensions, filters, and calculations. When you open a package in Cognos, these objects are visible in the Source tab.

  1. In Cognos Connection, from the Launch menu, select Cognos Workspace Advanced (or in Cognos Workspace, select Launch Cognos Workspace Advanced from the Action Menu). If there is more than one package available, the Select a package page appears. Otherwise, Cognos Workspace Advanced starts.
  2. If more than one package exists, select on the one you want to use.
  3. In the Welcome dialog box, choose whether to open a new or existing report or template:
    • To create a new report, select Create a new report and choose a basic report layout.
    • To open an existing report or template, select Open an existing report and select a report.

Choose a Basic Report Layout

Cognos Workspace Advanced includes several basic report layouts that include report objects, such as lists, crosstabs, and charts. You can also choose to start with a blank report or open an existing report.

  1. From the report actions button, select New.
  2. To change the package, click the ellipsis (...) button and select a different package.
  3. Choose a basic report layout:
    • To create a report using one of the predefined report layouts, select the layout then click OK.
    • To create a new report using another report, select Existing then click OK, locate the report, and click Open.

Add data to a report:

  1. Select the data items that you want to appear in the report.
  2. From the Source tab, drag each data item to the work area location where you want it to appear.
  3. Note: A flashing black bar indicates where you can drop an item.
  4. Another way to insert a data item is to right-click each item and select Insert.
  5. For more information about a data item, select the data item and from the Data menu, select Data Properties.

Remove data from a report:

  1. Select data item you want to remove.
  2. Press the delete button.

Sorting data

You can sort items to view them in your preferred order.

  1. Select the column or row to sort.
  2. Click the sort icon.
  3. Under Sort in Layout, select Ascending or Descending.
  4. To remove a sort order, select Don't Sort.

Sorting multiple rows or columns

If you want to sort more than one row or column, you can add items to sort or change the order in which they are sorted.

  1. Select a column or row.
  2. Click the sort icon and click Edit Layout Sorting.
  3. To change the sort order when multiple columns are sorted, change the order of columns in the Detail Sort List folder.
  4. Add items to the Detail Sort List folder to sort additional items.

Filtering data

Use filters to remove unwanted data from reports. Data is displayed in the report only if it meets the filter criteria. You can combine two or more filters into a complex filter.

  • If you want to filter on a field included on the report:
    1. Select the data item on which you want to filter. If you select two or more items, you can filter using a range.
    2. Click the filter icon.
    3. Select a filter condition from the list. Click OK.
  • If you want to filter on a field not on the report:
    1. Click on the field you want to filter in the Source list.
    2. Right click on the field and select Filter for Report.
    3. Select the values you want to include and move them to Selected values.
    4. If you want the report to prompt you for values each time you run it, check Prompt for Values.

Editing filters

You can specify whether filters are mandatory and whether to apply them before or after automatic aggregation.

  1. On the toolbar, click the filter button.
  2. Click Edit filters.
  3. To edit an existing filter, select the filter that you want to edit and click the edit button.
  4. Click the new button to add new filters.
  5. To specify whether the filter is mandatory, in the Usage box, select an option.
  6. To specify whether to apply filters before or after automatic aggregation, in the Application box, select an option.

Removing filters

You can remove a single filter or all filters for your report if they are no longer needed.

  1. On the toolbar, click the filter icon.
  2. To remove all the filters in your report, click Remove all filters.
  3. To remove a single filter, click Edit filters.
  4. Select the filter that you want to remove and click the delete icon.

Save a Report

Save your report to preserve the modifications you made. Reports are saved to the Cognos server.

  1. From the report actions button, select Save, or select Save As to save a copy of the report under a different name.
  2. Click on My Folders under Save in.
  3. If you are saving the report for the first time, specify where to save the report and type a file name.
  4. Under My Folders, you can create folders to organize your reports. Click on the Create New Folder icon to do this.
  5. Click Save.
Run Report

When you run a report in an export format such as PDF, delimited text (CSV) or Microsoft Excel spreadsheet (XLS), the Cognos report name is used as the exported file name.

  1. Open the report that you want.
  2. If you want to set run options, from the Run menu, select Run Options.
  3. The default values come from the run options in Cognos Connection.
  4. Note: The run options you set apply only to the current session. When you close Cognos Workspace Advanced, the options return to the default settings.
  5. Change any values you want for the current session.
    • Paper size - Specify only if the output format is PDF.
    • Paper orientation - Specify only if the output format is PDF.
    • Data mode - Specify how much data is returned. All Data returns all data. Limited Data limits the amount of data returned. No Data returns artificial data instead of actual data from the data source.
    • Language- The content language sets the preferred language for the data, Cognos Viewer, dates, and so on.
    • Rows per page- Specifies the number of rows to appear on each page.
    • Prompt- Select to be prompted for each prompt defined, unless the prompt is defined in a report page. If you clear the check box, you are prompted only if the report cannot run without user intervention. For example, if a report has a single parameterized filter that is optional, you are not prompted when you run the report.
    • Include accessibility features - Specifies whether accessibility features, such as alternate text on images and charts and summary text in tables, are included in the report output.

Running Report in Different Formats

  • From the Run menu, select one of the options to produce the report in the format you want.
  • You can produce a report in HTML, PDF, CSV, various Microsoft Excel formats, and XML.
  • The report runs in Cognos Viewer. Once the report has finished running, you can run the report again in the same format or in a different format. If you run the report again in CSV or XLS format, the report appears in a new browser window or tab.
Lists

Use list reports to show detailed information from your database, such as product lists and customer lists.

  • A list report is a report that shows data in rows and columns. Each column shows all the values for a data item in the database or a calculation based on data items in the database.
  • List reports automatically include an overall summary in a footer row. The default summary is used.

Group Data

Group data items in a list report to remove duplicate values. For example, you have a report that shows departments. For each department, the major is also shown. You group the department column to show only one instance of each department in the list.

  • Grouping a column automatically moves it to the left as the first column. Grouping a subsequent column moves it to the left until it follows the last grouped column. When you ungroup a column, it moves to the right until it follows the last grouped column.
  • After a column is grouped, you can move it elsewhere in the report.
  • In addition to grouping, you can specify the sort order of data items. In lists, you can sort data items within groups as well as ungrouped items. In crosstabs, you can sort row and column items.
    1. Click the column on which to group. You can click either the column heading or one of the column cells.
    2. Tip: To perform multiple groupings at once, use Ctrl+click or Shift+click.
    3. Click the group/ungroup button.
Crosstabs

Use crosstab reports, also known as matrix reports, to show the relationships between three or more data items. Crosstab reports show data in rows and columns with information summarized at the intersection points.

  • Working with Crosstab Reports - When you add data items to a crosstab, you create crosstab nodes and crosstab node members. These objects allow you to easily create crosstabs, using drag-and-drop operations.
  • Crosstabs are dimensional objects that have row edges and column edges. Each edge is composed of a set of crosstab nodes. Each crosstab node contains the following:
    • One or more crosstab node members.
    • Zero or one nested crosstab node, which contains one or more crosstab node members or nested crosstab nodes.
  • Each crosstab node member refers to a data item that contains an expression that defines the members that appear in the crosstab.
  • Create a Nested Crosstab - Nest data in a crosstab report to compare information by using more than one data item in a column or row. For example, a report shows the overall GPA average by department for the past five terms. You decide to add a data item to further break down the GPA by major.
  • When nesting columns in a crosstab report, there are four distinct drop zones where you can insert a new data item. The drop zone you choose will define the relationship between the data item and the column.
  • The following relationships are created when you insert a data item as a row:
    • Inserting a data item to the left or right of a column creates a parent-child relationship between them. When you insert a data item to the left of a column, the data item becomes a parent to the column. When you insert a data item to the right of a column, the data item becomes a child of the column.
    • Inserting a data item above or below a column creates a union relationship between them.
  • The following relationships are created when you insert a data item as a column:
    • Inserting a data item to the left or right of a column creates a union relationship between them.
    • Inserting a data item above or below a column creates a parent-child relationship between them. When you insert a data item above a column, the data item becomes a parent to the column. When you insert a data item below a column, the data item becomes a child of the column.

Swap Columns and Rows

Swap columns and rows to look at information from a different perspective. This may help you discover high and low points in the data that you hadn't previously noted.

  • You can only swap columns and rows in a crosstab or chart. In a chart, you swap the x- and y-axes.
  • From the toolbar, click the swap rows and columns button.
  • In the report, the rows become the columns and the columns become the rows.

Change a List into a Crosstab

Change a list into a crosstab to view your data from a different perspective.

  1. Click the columns to appear as columns or nested columns in the crosstab.
  2. From the Structure menu, click Pivot List to Crosstab.
  3. Results - The list becomes a crosstab with the columns you selected appearing as columns and nested columns. The unselected columns, except for measures, appear as rows and nested rows. If you have one measure, it becomes the cells of the crosstab. If you have more than one measure, they appear as columns.
  4. Tip: To make all measures appear as rows, swap columns and rows.
Creating Charts

You can use Cognos Workspace Advanced to create many chart types, such as column, bar, area, and line charts.

  • Before creating charts, review the available chart types to select the best chart for your needs. Also review the chart elements that make up charts.
  • To view the available chart types, from the File menu, select New, and then double-click the chart icon. You can also view the available chart types by adding a Chart object from the Toolbox tab to an existing report.
  • To create charts, drag data items from the Source tab to the measures, data series, and categories drop zones.
  • To help you when creating charts, you can do the following:
    • Resize your charts.
    • Move the chart drop zones into flyouts so that they appear only when you pause your pointer over the chart.
    • After you create a basic chart, modify the various chart objects to customize your chart.

Chart Types

Cognos Workspace Advanced includes a number of chart types, such as column, bar, area, and line charts.

  • Column Charts - Column charts use vertical data markers to compare individual values.
  • Line Charts - Line charts are useful for showing trends over time and comparing many data series.
  • Pie Charts - Pie charts are useful for highlighting proportions.
  • Bar Charts - Bar charts are useful for showing trends over time and for plotting many data series.
  • Area Charts - Area charts are useful for emphasizing the magnitude of change over time. Stacked area charts are also used to show the relationship of parts to the whole.
  • Point Charts - Point charts are useful for showing quantitative data in an uncluttered fashion.
  • Combination Charts - Combination charts plot multiple data series by using combinations of columns, areas, and lines within one chart. They are useful for highlighting relationships between the various data series.
  • Scatter Charts - Scatter charts use data points to plot two measures anywhere along a scale, not only at regular tick marks.
  • Bubble Charts - Bubble charts, like scatter charts, use data points and bubbles to plot measures anywhere along a scale. The size of the bubble represents a third measure.
  • Bullet Charts - Bullet charts are a variation of bar charts. They compare a featured measure (the bullet) to a targeted measure (the target). They also relate the compared measures against colored regions in the background that provide additional qualitative measurements, such as good, satisfactory, and poor.
  • Gauge Charts - Gauge charts, also known as dial charts or speedometer charts, use needles to show information as a reading on a dial.
  • Pareto Charts - Pareto charts help you to improve processes by identifying the primary causes of an event. They rank categories from the most frequent to the least frequent. These charts are frequently used for quality control data, so that you can identify and reduce the primary cause of problems.
  • Progressive Column Charts - Progressive column charts, also knows as waterfall charts, are like stacked charts with each segment of a single stack displaced vertically from the next segment.
  • Quadrant Charts - Quadrant charts are bubble charts with a background that is divided into four equal sections. Quadrant charts are useful for plotting data that contains three measures using an X-axis, a Y-axis, and a bubble size that represents the value of the third measure.
  • Marimekko Charts - Marimekko charts are 100 percent stacked charts in which the width of a column is proportional to the total of the column's values. Individual segment height is a percentage of the respective column total value.
  • Radar Charts - Radar charts integrate multiple axes into a single radial figure. For each figure, data is plotted along a separate axis that starts at the center of the chart.
  • Win-loss Charts - Win-loss charts are microcharts in which the value of each column is either 1 or -1, often denoting a win or loss.
  • Polar Charts - Polar charts are circular charts that use values and angles to show information as polar coordinates.

Chart Configurations

Chart configurations specify the grouping type of the columns, bars, lines, and areas in a chart. Some examples are standard, stacked, and 100 percent stacked charts.

  • Standard Charts - Standard or absolute charts are useful for comparing specific values and for representing discrete data, such as data for different regions or individual employees. For example, a standard column chart that plots regional sales emphasizes the actual value that each region achieves in sales.
  • Stacked Charts - Stacked charts are useful for comparing proportional contributions within a category. They plot the relative value that each data series contributes to the total. For example, a stacked column chart that plots product line sales will emphasize the proportion that each product line contributes to the total in each territory.
  • 100 Percent Stacked Charts - 100 percent stacked charts are useful for comparing proportional contributions across all categories. They plot the relative contribution of each data series to the total as a percentage. For example, a 100 percent stacked column chart that plots product line sales emphasizes the percentage within each region without referring to actual values.
  • Three-dimensional Charts - Three-dimensional charts provide a visually effective display that is suitable for presentations.

Convert Charts From One Type to Another

This procedure applies to converting charts from one type (for example, a bar chart) to another type (for example, a line chart).

  • When you convert a chart to a new chart type, Cognos Workspace Advanced keeps the properties from the existing chart if they exist in the new chart type. For example, if you convert a donut chart to a bar chart, Cognos Workspace Advanced maps your chart palette to the new chart, but does not map the hole size, because the hole size property does not exist in a bar chart.
    1. Right-click a chart and select Convert Chart.
    2. Select a new chart type, and click OK.
Using External Data Source for Reports

Cognos Workspace Advanced allows an External Data Source to be created and used with Banner ODS for creating reports. The following is an example of setting up an Excel file of IDs as an external data source.

Create External Data File

  1. Create an Excel file with your IDs in it. Put ID in the first row as a title.
  2. Save it in a place you will be able to get to when you run Cognos reports in the future.

Set Up External Data in Cognos

  1. Log into Cognos
  2. Launch Cognos Workspace Advanced.
  3. Select whichever package you are creating your reports with (Student Detail, Active Registration, etc).
  4. Select Create New.
  5. Select the type of report you are creating (List, Crosstab, etc.).
  6. On the right side under Source, look for the cylinder icon with a pencil on it (it's green). Click it.
  7. Browse for your external file.
  8. If there are multiple columns, select the columns you want loaded into Cognos. Should be at least ID.
  9. Change the name if you want.
  10. Click on Next.
  11. Click on the ... under Existing Query Subject/Report:
  12. Select Choose Query Subject.
  13. Find the main table you are going to build the report on (like Enrollment), select it and click OK.
  14. Find ID, select it then click on the "New Link" button above. If you brought in more than one column you will also need to select ID from your file before clicking on the button. This joins the fields.
  15. Click Next
  16. Change the Data type to Text.
  17. Click Next
  18. Click Finish
  19. Click Publish. What it has done is create a new package that has both the original tables from the package selected and the External Data Source. It is saved in the My Folders area.

Create a Report

  1. Select all of the fields from package you selected that you want to have included.
  2. Drag the ID field from your External Data Source (whatever its name is) to the report.
  3. This will cause the report to filter to the IDs in the External Data Source.
  4. Save the report.

Creating a new report using new package (with external data)

  1. If you are going to create a new report, Open Cognos Workspace Advanced.
  2. When it asks you to select a package. Click on the Cognos link just below "List of all packages".
  3. Select My Folders then select the package you have External Data Source connected to (like Active Registration External Data)
  4. Build the report like before, making sure you use the IDs from your External Data Source.
  5. Save report.

Running Reports that use an External Data Source

  • If you are still in the current Cognos session that you created the External Data Source, you can run reports without having to specify your external data file, but any changes made in the file will not show up until the next time you log into Cognos.
  • The next time you log into Cognos and run the reports, the first one will ask you to browse to the external data file and it will read it in, refreshing the data. Locate the file using Browse, click on OK then it will run your report.
  • You won't be asked to identify the external data file again until the next time you log into Cognos.

Back to Cognos Overview