cognos user group
play

COGNOS USER GROUP November 12, 2019 Agenda BICC Updates- Kelsie - PowerPoint PPT Presentation

COGNOS USER GROUP November 12, 2019 Agenda BICC Updates- Kelsie Newberry Current Community Issues Zach Yater Reference Queries - Sabrina Tanner Data Module Demo Josh Newberry Authoring Organizational Ideas -


  1. COGNOS USER GROUP November 12, 2019

  2. Agenda • BICC Updates- Kelsie Newberry • Current Community Issues – Zach Yater • Reference Queries - Sabrina Tanner • Data Module Demo – Josh Newberry • Authoring Organizational Ideas - Leslie Rody • Q&A

  3. BICC Updates Kelsie Newberry

  4. BoilerAD • Cognos migrated to the BoilerAD domain on 10/12 • Departmental Admin Guide

  5. Cognos Resources Upcoming Cognos Tool Trainings ● COG 401 - Cognos Analytics Authoring - 1/27 & 1/28 ● Cognos Resources Page ● December Grade Roll ● ○ Prompt Blank Row Workaround Reminder of the Maintenance Window ●

  6. Boiler Insight Enhancement Releases • Updated release schedule • Occur every 4 weeks (except holiday periods) • Next up is December 3rd • Changes of each release will be communicated once release is in Production

  7. WHO DO I CONTACT? Data Questions/Issues: Email: Boiler Finance: treasreporting@purdue.edu Data-related questions/issues should first be directed to your supervisor. GM: spsrept@groups.purdue.edu Insight HR: HR Data Request Form Data Questions/Issues: Email: Student CognosStudentHelp@purdue.edu Data-related questions/issues should first be directed to your supervisor. Reporting Tool Questions/Issues: Email: BICC BICC@purdue.edu Cognos tool issues - error messages, unexpected behavior, etc.

  8. Current Community Issues Zach Yater

  9. Enrollment Summary & List - Census Performance Issues

  10. One Query Crosstab Calculations Biggest Problem Using one query for all crosstabs

  11. Some Improvement Using Subqueries No crosstab calculations in Final

  12. Dramatic Improvement Individual Queries (require filters on each one)

  13. Reference Queries Sabrina Tanner

  14. Reference Query / Subquery / Feeder Query ● Control the order in which items are queried from the underlying data ○ Ensure calculations & filters are applied in the order you want ○ Useful for complex computations that need executed in a certain order ● Allows a report writer to build the query only once and be able to write different reports from it

  15. Build a base query ‘Main’ contains total campus credits across all student levels

  16. Drag a new query from the Toolbox pane

  17. Create a link between the child query and the parent query by dragging the parent query to the right side of the child query

  18. Undergrad is referencing Main

  19. Drag desired fields from Main into the data items for Undergrad When creating the child query, you can reference items only from the parent query or from other queries defined in the report

  20. Create a filter for Undergrad - Student_Level

  21. Repeat these steps for Graduate and Professional queries Main = gets total campus credits across all levels Undergrad = referenced from Main with a filter of [Student Level] = ‘UG’ Graduate = referenced from Main with a filter of [Student Level] = ‘GR’ Professional = referenced from Main with a filter on Student Classification

  22. Uploaded File and Data Module Creation Demo Josh Newberry

  23. Cognos 11 New Features ● Ability to Upload a File ● Create a Dashboard ● Create a Data Module ● Create a Data Set ● CQM to DQM

  24. Important Points to Know up Front ● Chrome is your best browser for Data Modules ○ IE will work but very slow, new update with Firefox has issues with Data Modules. ● Beware of security ○ Uploaded Files have no security as default (like Data Sets). Data modules will have lowest level security of the package being used ● Have all your components accessible to whomever is going to run it ○ If you use an Uploaded File and that file is in your My Content, the others are not going to be able to run it

  25. Personal Use Cases ● Take a file and outer join it to the data warehouse ○ Bursar private awards example ● Use a file as a way to pass in more than a 1000 filter objects ○ Bursar email example for 40k students ● Creative way to solve reporting issues outside of what has been possible before ○ DRC example

  26. Adding Uploaded File ● Once you upload your file, the file will automatically be placed in your My Content. (Remember that if anyone else is going to run this report you will need to move this file out of My Content) ● At any time you want to update the file just right click the file and say “Refresh”

  27. Creating a Data Module ● Data Modules can be built with any of the listed combinations. For this purpose we are using a Package and an Uploaded File. ● By clicking on each of them you get the full listing of options that you have access to.

  28. Building the Data Module ● Click the “Diagram Icon” and drag and drop the sources onto the space. ○ Here is where you can do modeling by right clicking a source in the space and saying “Create Relationship”. Unless you are confident in what you are doing I recommend against modeling and leave them as “Stand Alone”. ● Save the Data Module in the desired location.

  29. Building the Report ● Navigate to your Module and say “Create Report” ● When you first come into the design mode your package will be fully expanded which you can collapse. ● You will have to join your file at some point with the package in the report. (the lower the join the more efficiency it will have)

  30. Organizational Ideas Leslie Rody

  31. Authoring Organizational Ideas ● Notes ○ #/* Note Here */# ○ Examples of use: ■ #/*Past 5 fall semesters*/# [ACADEMIC_PERIOD] IN (‘202010’, ‘201910’, ‘201810’, ‘201710’, ‘201610’) ■ Large Calculation within Data item ● Calculated/changed Data Item ■ An indicator that a field has been changed benefits future report writers/editors, including future you! ■ As simple as an asterisk (*) preceding the name of the data item can indicate a change.

  32. Community Feedback Questions?

  33. THANK YOU Sue Wilder Monique Rawles Leslie Rody Sabrina Tanner Julie Jang Katie Hendryx Kelsie Newberry Zach Yater

Recommend


More recommend