Introduction to Cognos Connection

Introduction to Cognos Connection

Introduction to Cognos Connection Cognos BI 8 1 2 Instructor Dave Campen Contact info: Email: [email protected] Phone: 651-999-6312 ...

2MB Sizes 2 Downloads 23 Views

Introduction to Cognos Connection

Cognos BI 8

1

2

Instructor

Dave Campen Contact info: Email: [email protected] Phone: 651-999-6312

3

Introduction to Cognos Connection Manage Reports in Cognos Connection

4

Objectives  In this module, we will: – examine Cognos Connection – organize content in Cognos Connection – personalize Cognos Connection – explore reports in Cognos Connection – create a report view – view report outputs

5

What is Cognos Connection?

ReportCenter =Cognos Connection  Cognos Connection is a Web application used to: – create and run reports – perform administrative tasks, such as scheduling reports – organize data by creating entries and storing the entries in folders

6

Cognos and Reporting Capabilities HR

Finance

Student

Other Data Sources

“Operations” Data

ETL

Real-time Reporting

Data Warehouse (EPMS)

Business Intelligence Tool

Reports Cubes Dashboards Portal

Users

7

What is Report Center?  Report Center is the Web-based business intelligence reporting solution from Cognos. Query Studio

Report Studio

Web Interfaces for Report Creation & Management

Data Warehouse (EPMS Data)

PowerPlay Web

Cognos Viewer

Cognos Connection

Future additional data warehouse

Operational Data (HR/Pay Data)

Operational Data (TSIS – in Operational Data (TFS Data)

development)

8

Cognos System requirements

 Internet access For full functionality,  PC - Internet Explorer (6.0 +)  Mac – Firefox is recommended  If you use a popup blocker, you need to allow popup for Cognos Connection

9

What is Business Intelligence?  Business intelligence allows you to: – use district data to support decision-making – explore and analyze data to reveal trends within a school/your district

Raw Data

Organized Information

Better School Decisions

10

Centralized Access  You can access all BI content in Cognos Connection from the TIES portal. PowerPlay Web Content Analysis

Reports

ReportNet Content

11

Organize Content with Folders  You can arrange reports and other content in Cognos Connection by creating folders.  Ensure that your folders are logically labeled and organized to make locating reports quick and easy.

12

Organize Content with Report Views  Create a Report View to point to another entry in Cognos Connection, such as a report or Web link.  You can organize information that you use regularly. For example, if you frequently use a report in Public Folders, you can create a Report View in My Folders.

13

Specify Properties of an Entry  In Cognos Connection, you can set the default properties for an entry.

14

Delete Entries  Delete an entry from your My Folders list if you want to permanently remove it from the portal. For example, you may want to remove your entries that are outdated.

15

Search for Entries  You can search for entries in Cognos Connection whose name, description, or both, match the string entered in the search criteria.

16

Personalize Cognos Connection  You can change your preferences to customize the way entries appear.

17

Demo 1  Explore Cognos Connection

18

Open Cognos Connection



From the Start menu, point to Programs, and then click Internet Explorer.



Internet Explorer opens.



In the Address box, type https://reportcenter8.ties.k12.mn.us/cognos8, and then press Enter. Click “Yes” to proceed when a security certificate dialog box appears.



The Log on screen appears.



In the User ID box, enter < d3999300###> (##=training number , in the Password box, type and then click OK.



Cognos Connection opens. From here, we can manage schedules, set personal preferences, log off, and access Help. We can also set the default portal view, add folders and pages, copy and paste, and search for entries using the Cognos Connection toolbar.



Click the Cognos Connection link.



By default, entries on the Public Folders tab are accessible to all users.



Click EPMS Data Warehouse.



This folder contains reports previously created in Query Studio or Report Studio.

19

Create a folder to hold reports



Create a folder to hold reports



Click the My Folders tab, and then on the toolbar, click New Folder .



The New Folder Wizard page appears.



In the Name box, type , and then in the Description and Screen tip boxes, type Reports created for .



In the Screen Tip field, enter



Click Finish.



Your named folder is added to My Folders.



Create a subfolder for more organization.



From the My Folders tab, click on your named folder, and then click New Folder .



The New Folder Wizard page appears.



In the Name box, type , and then in the Description and Screen tip boxes, type .



In the Screen Tip field, enter



Click Finish.



The subfolder is added to your named folder.

20

Create a shortcut



Create a shortcut.



Beside My Subfolder, under Actions, click More, and then click Create a shortcut to this entry.



Then specify a name and description - New Shortcut Wizard page appears.



Under Location, click Select another location, and then click the My Folders link.



Click OK.



Click Finish, and then click the My Folders link (not the My Folders tab).



A shortcut to the My Subfolder folder was added to the My Folders subfolder. Notice the shortcut icon that appears beside the folder name.

21

Define Reports  A report can refer to either: – a specification that says which information to include in a report (template) – the report information itself (output)  You can access reports from Cognos Connection.

22

Run Reports  Click a report name to run a report and view data.  Run a report with options to run, print, or save it, using chosen options.

Run reports

Run a report with options

23

Run a Report with Options  Run a report with options: – to override the default run options set for the report – to view data

24

Perform Report Actions in Cognos Viewer  While viewing a report in Cognos Viewer, you can perform many actions that are available from the Run with options and the Run with advanced options pages.

25

View a Previously Run Report  In your “My Folders”, Click a report name to view the most recently saved copy of the report.

26

View Report Output Versions  You can analyze older data in a report by viewing previous report output versions.

Previously saved versions of the School Performance by Special Populations Group report in HTML, Excel 2002 and PDF formats

27

View the Run History of Reports  You can view the run history of a report to examine: – when the report was requested – the start time and completion time for the report – whether the report executed successfully

28

Create Report Views  Create a report view to produce a customized version of a report.

29

Demo 2  Create a Report View and Report Outputs

30

Run Report in Cognos Viewer to PDF



View a Student report in Cognos Viewer.



Click the Public Folders tab, and then click EPMS Data Warehouse.



Select the Student Performance folder



Click on School Performance by Special Population Groups report name



Select the following options (Select Year: 2007, School: Elementary – 0106, Select Test Subject: READ, Select all grades) then click Finish



Convert report to a PDF file



Select the view in PDF format icon – the report will run with the same options as you originally requested.

31

Run Report in Cognos Viewer to Excel



View a Student report in Cognos Viewer.



Click the Public Folders tab, and then click EPMS Data Warehouse.



Select the Grades folder



Click on Grade Analysis by Department and Term with Average GPA report



Select the following options (Select School: Sr High - 0105, Select School Year: 2007, Select Grade Type: Final Grade, Select Enrolled Grades: 09-12) then click Finish



Convert report to a Excel file



Select the “View in Excel 2000 single sheet format” icon – the report will run with the same options as you originally requested.

32

Create a Report View in My Folders

 Open Public Folders > EPMS Data Warehouse > Grades  Under Actions on the report Grade Analysis by Department and Term with Average GPA, click on the Window pane icon.  Then Specify a name and description - New Report View Wizard page appears.  In the Name box, type My copied Grade Report, under Location, click the link Select My Folders, and then click Finish.  A Report View of the report is saved to My Folders.

33

Create multiple outputs of a report

 Create multiple outputs of a report.  Beside My copied Grade Report, under Actions, click Run with options – My copied report .  The Run with options – My copied Grade Report page appears.  Click Advanced options.  The Run with advanced options page appears.  In the Delivery section, click the button beside Save the report, and then ensure that the Save box is selected.  In the Time section, ensure that the button beside Now is selected, and then under Formats, clear the HTML check box, and then select the PDF and the Excel 2000 Single Sheet check boxes.  Click Run,  Select options: (Select School: Sr High - 0105, Select School Year: 2007, Select Grade Type: Final Grade, Select Enrolled Grades: 09-12)  Review options and then click OK.  The report outputs will be generated at the specified time.  View report output versions.  On the toolbar, click Refresh .  Beside My copied Grade Report, under Actions, click View the output versions for this report – My copied Grade Report .  The View report output versions – My copied Grade Report page appears.

34

View report output versions

 View report output versions  On the toolbar, click Refresh .  Beside My copied report, under Actions, click View the output versions for this report – My copied Grade Report .  The View report output versions – My copied report page appears.

35

Summary  In this module, we have: – examined Cognos Connection – organized content in Cognos Connection – personalized Cognos Connection – explored reports in Cognos Connection – created a Report View – viewed report outputs

36

Question How can you customize Cognos Connection?

37

Manage Reports in Cognos Connection

Cognos BI 8

38

Objectives  In this module, we will:

– view the run history of reports – Discuss email and print options – schedule reports

39

Distribute Reports  You can distribute reports to other users to share information with them.  You can distribute reports by: – saving them where other users can access them – sending them to other users by email – printing them

40

Save Reports

 You can share reports with others by saving them in a location that is accessible to other users, such as the public folders.  Public folders typically contain reports that are of interest to many users.

41

Send Reports by Email 

You can send the report by email for a report you have scheduled as a reminder. Using a link requires a user to have access to the location that the report is generated from – i.e. District reports folder would be the best location unless you are sending to yourself.

42

Print Reports  You can print a PDF version of a report to obtain a hard copy of the information.  Print a report if your computer is not available, or if you want to take a copy of a report to a meeting.

Print

43

Schedule Reports  You can schedule reports to run at a time that is convenient for you, such as during off hours when demands on the system are low.  You can schedule reports individually or by using a job.  You can schedule reports to run by minute, hourly, daily, weekly, monthly, or yearly.  After you create a schedule, the report or job runs at the date and time specified.

44

Demo 3  Schedule a Report

45

Schedule a Single Report

 You can schedule a single report to run at a later time or on a recurring date and time.

46

Demo 4  Schedule Multiple Reports

47

Schedule Multiple Reports  You can set the same schedule for multiple reports by creating a job.

A job identifies a collection of reports, report views, and other jobs that are scheduled to run together and share the same schedule settings

48

View and Manage Schedules  You can use the Schedule Management tool to view and manage the schedules you have created.

49

Summary  In this module, we have: – viewed the run history for reports – saved reports to a publicly accessible location – printed reports – scheduled reports

50

Question Why would you view the run history of a report?

51

Question Why would you create a job?

52