COGNOS Multiple Queries - Kent State University

3y ago
47 Views
2 Downloads
1.09 MB
21 Pages
Last View : 5d ago
Last Download : 9m ago
Upload by : Ellie Forte
Transcription

Multiple QueriesCOGNOSMultiple QueriesIn Cognos Report Studio, it is possible to include multiple queries on a report. In the Applicants reportbelow, we will add a query for Admissions information.Page 1 of 21RevisedJuly 2012

Multiple QueriesFollow these steps to create a report with multiple queries:1. Open the reportPage 2 of 21RevisedJuly 2012

Multiple Queries1.2.3.4.5.Highlight the report body areaSelect the Table menu itemSelect InsertSelect TableChange the table size to three (3) columns and four (4) rows6. Click OKPage 3 of 21RevisedJuly 2012

Multiple Queries7.8.9.Highlight the College columnSelect the List Column Body link at the top of the Properties PaneSelect ListPage 4 of 21RevisedJuly 2012

Multiple Queries10.11.Drag the columns to the bottom left cellClick inside the cell12.Select the CenterPage 5 of 21iconRevisedJuly 2012

Multiple Queries13.14.15.Click the Toolbox tabfrom the Insertable Objects PaneSelect List itemDrag the List item to the bottom right space of the tablePage 6 of 21RevisedJuly 2012

Multiple Queries16.17.Select the Source tab from the Insertable Objects PaneDrag the data items COLLEGE DESC and PERSON UID into the NEW list report framePage 7 of 21RevisedJuly 2012

Multiple Queries18.19.20.21.22.23.24.Double click inside the PERSON UID columnThe Data Item Expression dialogue box will openClick before the Query Item DefinitionEnter the word count space open parenthesis (Click at the end of the Query Item DefinitionEnter close parenthesis )Click OKPage 8 of 21RevisedJuly 2012

Multiple Queries25.Click inside the COLLEGE DESC column26.Click the GroupPage 9 of 21iconRevisedJuly 2012

Multiple Queries27.Highlight the PERSON UID column28.29.Click the AggregateSelect TotalPage 10 of 21iconRevisedJuly 2012

Multiple Queries30.31.Click inside the subtotal lineClick the Delete key on your keyboardPage 11 of 21RevisedJuly 2012

Multiple Queries32.33.34.Mouse over the Explorer BarMouse over Query ExplorerSelect Query 1Page 12 of 21RevisedJuly 2012

Multiple Queries35.36.37.38.Select the second filter in the Detail Filters windowThe Detail Filter Expression dialogue box will openHighlight and copy the contents in the Expression Definition windowClick the Cancel buttonPage 13 of 21RevisedJuly 2012

Multiple Queries39.40.Mouse over the Query ExplorerSelect Query2Page 14 of 21RevisedJuly 2012

Multiple Queries41.42.43.Click the Toolbox tab from the Insertable Objects paneDrag and drop the Filter item to the Detail Filters windowPaste the copied statement into the Expression Definition windowPage 15 of 21RevisedJuly 2012

Multiple Queries44.45.46.47.Click the Source tab from the Insertable Objects paneScroll through the tree hierarchy until you find the Filters folderOpen the Filters folderDrag and drop the Admit Select filter to the Detail Filters windowPage 16 of 21RevisedJuly 2012

Multiple Queries48.49.Open Page 1 by opening the Page Explorer from the Explorer BarClick inside the right side of the report to highlight it50.Select the CenterPage 17 of 21iconRevisedJuly 2012

Multiple Queries51.52.53.Highlight the column heading for COLLEGE DESCSelect Source Type from the Properties PaneSelect TextPage 18 of 21RevisedJuly 2012

Multiple Queries54.55.56.57.58.Double click inside the column headingThe Text box will openType the word CollegeClick OKRepeat steps 56 - 62 for the PERSON UID column, except change the word to AdmissionsPage 19 of 21RevisedJuly 2012

Multiple Queries59.Select the PERSON UID column60.Select the right justifyicon61. Run the report to view the resultsPage 20 of 21RevisedJuly 2012

Multiple QueriesFor additional information regarding Cognos, policies and access, or modifications to the ODS, contactthe Business Intelligence Team at cognos@kent.edu. For technical assistance, contact the IS Help Deskat 672-HELP (4357).www.kent.edu/is/trainingistraining@kent.edu 2012 This information is provided by the Division of Information Services, Kent State University and is proprietary and confidential. Thesematerials are made available for the exclusive use of Kent State University employees, and shall not be duplicated, published or disclosed forother purposes without written permission.Page 21 of 21RevisedJuly 2012

In Cognos Report Studio, it is possible to include multiple queries on a report. In the Applicants report below, we will add a query for Admissions information. Multiple Queries Page 2 of 21 Revised July 2012 Follow these steps to create a report with multiple queries: 1. Open the report . Multiple Queries

Related Documents:

found in the Cognos Connection User Guide, a link to which can be found on the Resources tab in the IIT Cognos portal. 2. About the Cognos Portal The IIT Cognos Portal (aka "Cognos Connection") allows users to access Cognos reports and launch the various Cognos tools for authoring reports and queries based on data stored

2 IBM Cognos Business Intelligence Version 10.1.1: Using IBM Cognos Series 7 and IBM Cognos Business Intelligence in the Same Environment. Chapter 2. Set up Interoperability Between IBM Cognos Series 7 and IBM Cognos BI Set up interoperability before and during migration to provide continuity to your

IBM Cognos ReportNet Model Upgrade 367 Verifying the Model in IBM Cognos ReportNet 367 Opening and Upgrading the Model 368 Verifying and Repairing the Upgraded IBM Cognos ReportNet Model 370 IBM Cognos 8.1 or 8.2 Model Upgrade 374 Verifying the Model in IBM Cognos 8.1 or 8.2 374 Opening and Upgrading the IBM Cognos 8.1 or 8.2 Model 375

Rachel Foot, KENT STATE UNIVERSITY, rfoot@kent.edu Alicia, R. Crowe, KENT STATE UNIVERSITY, acrowe@kent.edu Karen Andrus Tollafield, KENT STATE UNIVERSITY, ktollafi@kent.edu Chad Everett Allan,KENT STATE UNIVERSITY, callan1@kent.edu Exploring Doctoral Student I

In this guide, the current Cognos version 10 user interface is called the Cognos 10 UI. The Cognos version 11 user interface is called Cognos 11 UI. . Query Studio, and Workspace. HINTS The green dot displayed in the Cognos 11 UI indicates a UI hint is available for that feature. Clicking the green dot opens a brief description of the feature.

IBM Cognos Analysis for Microsoft Excel 10.2.0 has feature enhancements in several key areas: v IBM Cognos Analysis for Microsoft Excel is now integrated with IBM Cognos TM1 data sources. Use IBM Cognos Analysis for Microsoft Excel with IBM Cognos TM1 data sources to enter and write back values to TM1 cubes. For more information, see

used outside of Cognos. The xml can be opened, modified, or copied from one Cognos environment to another. The follow steps can be used to copy your Cognos 10 BI Reports over to Cognos 11 Analytics: 1) In Cognos 10 - In order to view a reports specification (spec), open it up to view in Reports Studio.

Business-Level Strategies 23.11.2010 4. What is a Strategic Business Area? Demand Demand potential (size, growth rate, market share) Customers Customer potential customer structure, buying motives and criteria) Competition Structure of the competition, the competitors' objectives and strategies, competitive position Specific resources and competences (the strategic capabilities) Organisation .