{"id":1354,"date":"2018-03-16T15:50:10","date_gmt":"2018-03-16T19:50:10","guid":{"rendered":"http:\/\/www.montclair.edu\/red-hawk-central\/?page_id=1354"},"modified":"2021-10-18T11:20:44","modified_gmt":"2021-10-18T15:20:44","slug":"cognos-reports-user-guide","status":"publish","type":"page","link":"https:\/\/www.montclair.edu\/red-hawk-central\/how-to-guides\/cognos-reports-user-guide\/","title":{"rendered":"Cognos Reports User Guide"},"content":{"rendered":"

1. Navigate to Cognos<\/a>.
\n2. Login with your Montclair State University NetID and password.<\/p>\n

<\/figure><\/figcaption><\/figure>\n

3. Once in Cognos, we recommend that users check out the \u201cHow-to videos\u201d and \u201cAccelerator catalog\u201d menus provided by IBM to get familiar with new features and tutorials, especially if you will be designing your own reports.<\/p>\n

<\/figure><\/figcaption><\/figure>\n

4. There are several ways of locating a report.<\/p>\n

    \n
  • From the Top Left<\/em> menu, click on the (1) Search<\/strong> icon and (2) type<\/strong> in the name of the report. Cognos will list any objects that meet the search criteria. Icons on the left of the objects indicate if they are folders, reports or other objects. You can use the (3) Save<\/strong> button to save searches that you use frequently.<\/li>\n<\/ul>\n
    <\/figure><\/figcaption><\/figure>\n
      \n
    • Or from Top Left<\/em> menu, click on Team Content<\/strong>, then select Banner Reports<\/strong>.<\/li>\n<\/ul>\n
      <\/p><\/figcaption><\/figure>\n
        \n
      • Within Banner Reports<\/em> folder, reports are categorized by Colleges and Schools, Departments, and registration\/enrollment<\/em> related reports are under University Reports<\/em>.<\/li>\n<\/ul>\n
        <\/p><\/figcaption><\/figure>\n

        5. For this demo, we will be running \u201cClass Schedule\u201d. Click on University Reports<\/strong> folder, and then select Registration and Enrollment<\/strong>.<\/p>\n

        NOTE:<\/strong> As you navigate through the Cognos folders, a (1) breadcrumb trail is created to show the folder hierarchy. If you want to go to the previous folder, click the (2) back arrow next to the breadcrumb trail, not the back arrow of the browser.<\/p>\n

        <\/figure><\/figcaption><\/figure>\n

        6. Scroll down or user Filter<\/strong> to find and select \u201cClass Schedule\u201d report.<\/p>\n

        <\/figure><\/figcaption><\/figure>\n

        7. Many reports are built with prompts<\/strong> (as in the case of \u201cClass Schedule\u201d) to make it easy for the users to narrow down their report to display only the information they are interested in.
        \nNote: Prompts with asterisk (*) are required.<\/p>\n

          \n
        • Select \u201cFall 2021\u201d from the drop-down next to Academic Period<\/em> prompt; select \u201cHumanities and Social Sciences\u201d for College<\/em> prompt and \u201cAnthropology\u201d for Department prompt. We will leave Subject prompt unselected because it is not required and also because we will like our report to display all subjects under anthropology department.<\/li>\n
        • Once all the necessary values are selected (1) especially the required prompt\u2019s, click on (2)
          \nFinish.<\/li>\n<\/ul>\n
          <\/figure><\/figcaption><\/figure>\n
            \n
          • Once the finish button is clicked, the message below will appear, indicating the report is being executed. You have several options to receive the report. You can wait until the report finish running and display it on the screen or export to other predefined formats (e.g. Excel, PDF etc.)<\/li>\n<\/ul>\n
            <\/p><\/figcaption><\/figure>\n
              \n
            • Or you can click on the \u201cSelect a delivery method\u201d hyperlink (indicated by the arrow in the image above) to save it in the system (1, 2) for you to access it later or even to have the report emailed (3) to you.<\/li>\n<\/ul>\n
              <\/p><\/figcaption><\/figure>\n
                \n
              • If you click Save Report<\/strong> or Save as Report View<\/strong> (which will allow you to save it in a location of your choice and rename it), the message box will close and return you to Home screen. Once the report is done running, you can check to see the output by clicking on the Ellipses<\/strong> (1) next to the name of the report, and then click on View Versions<\/strong>, you will see a list of reports that were saved (3).<\/li>\n<\/ul>\n
                <\/p><\/figcaption><\/figure>\n
                  \n
                • If you choose to let the report run on its own without selecting a delivery method, then it will display as the image below.<\/li>\n<\/ul>\n

                  Note:<\/strong> If the report spans more than one page (as in the example below), use the navigation controls in the lower left<\/em> of the screen to see subsequent report pages.<\/p>\n

                  <\/p><\/figcaption><\/figure>\n

                  8. If you wish you export the report in a different format outside of the browser, click on Run as<\/strong> button. It will open up a list of report output options<\/em> such as Excel, PDF etc.<\/p>\n

                  <\/figure><\/figcaption><\/figure>\n

                  9. For instance, if you select Excel<\/strong> (which is often preferred by many for familiar filtering experiences), the report will run in excel and prompt you with the standard dialog asking if you want to open or save the excel.<\/p>\n

                  <\/figure><\/figcaption><\/figure>\n

                  Congratulations!<\/strong> You have now run a filtered Cognos report. Once you have extracted report data, you must handle it in a manner consistent with MSU data security standards. *<\/p>\n

                  NOTE:<\/strong> As a reminder, the Family Educational Rights and Privacy Act (FERPA) requires that student record information be used only for \u201clegitimate educational interest\u201d and not be dispersed to any third party outside of Montclair State University.<\/p>\n

                  And Always remember to log off<\/strong> when you are done with Cognos Reporting activity.<\/p>\n

                   <\/p>\n

                   <\/p>\n","protected":false},"excerpt":{"rendered":"

                  1. Navigate to Cognos. 2. Login with your Montclair State University NetID and password. 3. Once in Cognos, we recommend that users check out the \u201cHow-to videos\u201d and \u201cAccelerator catalog\u201d menus provided by IBM to get familiar with new features and tutorials, especially if you will be designing your own reports. 4. There are several […]<\/p>\n","protected":false},"author":15,"featured_media":1349,"parent":1310,"menu_order":34,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"footnotes":""},"class_list":["post-1354","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/www.montclair.edu\/red-hawk-central\/wp-json\/wp\/v2\/pages\/1354","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.montclair.edu\/red-hawk-central\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.montclair.edu\/red-hawk-central\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.montclair.edu\/red-hawk-central\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.montclair.edu\/red-hawk-central\/wp-json\/wp\/v2\/comments?post=1354"}],"version-history":[{"count":12,"href":"https:\/\/www.montclair.edu\/red-hawk-central\/wp-json\/wp\/v2\/pages\/1354\/revisions"}],"predecessor-version":[{"id":5419,"href":"https:\/\/www.montclair.edu\/red-hawk-central\/wp-json\/wp\/v2\/pages\/1354\/revisions\/5419"}],"up":[{"embeddable":true,"href":"https:\/\/www.montclair.edu\/red-hawk-central\/wp-json\/wp\/v2\/pages\/1310"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.montclair.edu\/red-hawk-central\/wp-json\/wp\/v2\/media\/1349"}],"wp:attachment":[{"href":"https:\/\/www.montclair.edu\/red-hawk-central\/wp-json\/wp\/v2\/media?parent=1354"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}