COGNOS User-Defined Prompts And Maps User Guide - Kent State University

1y ago
25 Views
1 Downloads
1.30 MB
24 Pages
Last View : 1d ago
Last Download : 4m ago
Upload by : Brady Himes
Transcription

Cognos – User-Defined Prompts and Maps COGNOS User-Defined Prompts and Maps User Guide Introduction This user guide will walk you through the steps of creating a user-defined prompt and maps in Cognos. The package we are using for this user guide is not open to the public, but is a genuine example of packages in Cognos. We are using this package because it contains address information, which will be used for creating a map. A user-defined prompt is a prompt where the report author can create his or her own prompt values. Insert Data Items The first step in creating a report is to insert the data items you want to use in your report. In this example, we will be using both the Academic Study and KSU Address Slot from the KSU Active Registration Training package. 1. Open Query Explorer 2. Open Query1 Page 1 of 24 Updated - January 2013

Cognos – User-Defined Prompts and Maps 3. Insert Data Items into the Data Items Pane Page 2 of 24 Updated - January 2013

Cognos – User-Defined Prompts and Maps Create Filters 1. 2. 3. 4. Drag and drop the filter Data Item into the Details Filter Pane Detail Filter Expression will open Enter the filter details (in this example we are filtering on Academic Period ‘201180’) Click OK Page 3 of 24 Updated - January 2013

Cognos – User-Defined Prompts and Maps 5. Create the next filter – using ADDR RULE – ‘UNIVSLOT’ Page 4 of 24 Updated - January 2013

Cognos – User-Defined Prompts and Maps Create Data Item 1. 2. 3. 4. 5. Select the Toolbox Tab Insert a Data Item into the Data Items Pane Select the Data Items Tab from the Data Item Expression Window Enter expression (in this example count ([PERSON UID] for [STATE PROVINCE DESC 1])) Click OK 6. In the Name field of the Properties Pane change the name of the Data Item to “Count” Page 5 of 24 Updated - January 2013

Cognos – User-Defined Prompts and Maps Adding Upper Function The Upper Function will reformate all characters up uppercase. 1. Double click on the data item to convert to all uppercase (in this example it is STATE PROVINCE DESC 1) 2. The Data Item Expression Window will open 3. Select the Functions Tabs 4. Locate the Upper Function in the Common Functions Folder R-Z 5. Insert the Upper Function into the Expression Definition Pane – NOTE: Be sure to close the data item with a right parenthesis “)” 6. Click OK Page 6 of 24 Updated - January 2013

Cognos – User-Defined Prompts and Maps Prompt Page 1. Place your cursor over the Page Explorer 2. Select Prompt Pages 3. Create the Prompt Page as usual a. Insert Table b. Insert Text Item c. Insert Value Prompt 4. The Prompt Wizard will open 5. Rename the parameter to Report type 6. Click Next Page 7 of 24 Updated - January 2013

Cognos – User-Defined Prompts and Maps 7. Uncheck the Create a parameterized filter checkbox 8. Click Next 9. Uncheck the Create new query checkbox 10. Click Finish Page 8 of 24 Updated - January 2013

Cognos – User-Defined Prompts and Maps Define Prompt 1. Highlight the Prompt by clicking inside 2. Select Static Choices from the Properties Pane 3. The Static Choices Window will open 4. Select the Add icon Page 9 of 24 Updated - January 2013

Cognos – User-Defined Prompts and Maps 5. Enter “D” in the Use field 6. Enter “Detail” in the Display field 7. Click OK 8. Select the Add icon 9. Enter “M” in the Use field 10. Enter “Map” in the Display field Page 10 of 24 Updated - January 2013

Cognos – User-Defined Prompts and Maps Create Report Pages and Rename 1. Place your cursor over the Page Explorer 2. Select Report Pages Page 11 of 24 Updated - January 2013

Cognos – User-Defined Prompts and Maps 3. Highlight Page 1 4. In the Properties Pane change the Name to “Detail” Page 12 of 24 Updated - January 2013

Cognos – User-Defined Prompts and Maps 5. From the Insertable Objects Pane insert a new Page 6. In the Properties Pane change the Name to “Map” 7. Highlight Detail Page 8. Select Render Variable 9. Select New String Variable Page 13 of 24 Updated - January 2013

Cognos – User-Defined Prompts and Maps 10. Rename to “Report Type” 11. Click New icon 12. Name “Detail” 13. Click OK Page 14 of 24 Updated - January 2013

Cognos – User-Defined Prompts and Maps 14. Click New Icon 15. Name “Map” 16. Click OK Page 15 of 24 Updated - January 2013

Cognos – User-Defined Prompts and Maps 17. 18. 19. 20. Report Expression Window will open Select Parameters Tab Insert Report Type Click OK Page 16 of 24 Updated - January 2013

Cognos – User-Defined Prompts and Maps 21. Uncheck Map 22. Click OK Page 17 of 24 Updated - January 2013

Cognos – User-Defined Prompts and Maps 23. Highlight Map Page 24. Select Render Variable 25. Select Report Type Page 18 of 24 Updated - January 2013

Cognos – User-Defined Prompts and Maps 26. Uncheck Detail 27. Click OK Insert Data Items to Detail Report Page 1. 2. 3. 4. Place Cursor over Page Explorer Open Detail Page Select Date Items tab Insert all Data Items Page 19 of 24 Updated - January 2013

Cognos – User-Defined Prompts and Maps Map Report Page 1. Place your cursor over the Page Explorer 2. Select Map 3. Select the Toolbox Tab 4. Locate Map from the Insertable Objects Pane Page 20 of 24 Updated - January 2013

Cognos – User-Defined Prompts and Maps 5. Open the Americas folder 6. Select United States (Continental 48) 7. Change Query Name to Query1 8. Select the Data Items Tab 9. Insert “Count” into the Color item in the map Page 21 of 24 Updated - January 2013

Cognos – User-Defined Prompts and Maps 10. Insert STATE PROVINCE DESC 1 into the Location item in the map 11. Change Ignore Date with No Features (from Properties Pane) to Yes Page 22 of 24 Updated - January 2013

Cognos – User-Defined Prompts and Maps Customizing Color Palette 1. Highlight Region Layers 2. Select Palette 3. Change the range numbers accordingly Page 23 of 24 Updated - January 2013

Cognos – User-Defined Prompts and Maps Data Dictionary If you do not change the map setting “Ignore Data with No Features to Yes, Cognos may throw an error if the query returned has a data point that is not also in the map. You can either change the setting to “Yes” to ignore the data or add the data point manually if it is in the map file. In the Dictionary Entry box, the “Name:’ corresponds to the data point in the map file. The “Alias:’ corresponds to the name as it appears in the data source. Page 24 of 24 Updated - January 2013

Cognos - User-Defined Prompts and Maps Page 1 of 24 Updated - January 2013 COGNOS User-Defined Prompts and Maps User Guide Introduction This user guide will walk you through the steps of creating a user-defined prompt and maps in Cognos. The package we are using for this user guide is not open to the public, but is a genuine example of

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

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

Mobile administrators, one of the predefined roles in the Cognos namespace, can be used to specify access permissions for this functionality. Cognos Mobile uses the same set of users as Cognos Business Intelligence. For information about managing Cognos BI, see other sections of the IBM Cognos Business Intelligence Administration and Security .

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.

Accounting for Nature: A Natural Capital Account of the RSPB’s estate in England 77. Puffin by Chris Gomersall (rspb-images.com) 8. Humans depend on nature, not only for the provision of drinking water and food production, but also through the inspiring landscapes and amazing wildlife spectacles that enrich our lives. It is increasingly understood that protecting and enhancing the natural .