Preview

Cognos Guide

Powerful Essays
Open Document
Open Document
12882 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Cognos Guide
Cognos Report Studio

Session Document

INTRODUCTION: 4

WORKING IN REPORT STUDIO: 4

THE USER INTERFACE: 4 Insertable objects pane: 5 Properties pane: 6 Explorer bar: 6 Work Area: 6

Basic Report Structure: 6

Layout 6 Pages 7 Objects 7 Creating a report: 8 Specify the Package 8 Choose a Report Template 9 Add Data to a Report 10 Running a Report Against a Dimensional Data Source 11 Convert a Report to a Template 12 Create a Query Studio Template 13 Types of Reports 13 List Reports: 13 Group Data: 14 Crosstab Reports: 16 Crosstab Nodes and Crosstab Node Members: 17 Moving Crosstab Nodes 17 Crosstab Node Creation Option: 18 Create a Nested Crosstab Report 19 Rows 19 Columns 19 Create a Discontinuous Crosstab 20 Change a List into a Crosstab 22 Add Aggregate Data to a Crosstab Report 24 Charts 25 Create a Column Chart to Plot Order Trends 26 Customize a Chart 28 Customize the Colors of a Chart 29 Change a Chart Background 29 Add a Baseline to a Chart 30 Create a Drill-through Chart 32 Steps to Create the Target Report 32 Steps to Create the Source Chart 33 Create a Drill-up and Drill-down Chart 35 Customize the Axis Titles 36 Repeaters 37 Convert a List into a Repeater 38 Create Mailing Labels 38 Add a Header or Footer 41 Add Borders 42 Add Text 42 Specify the Font 43 Add Color 43 Insert an Image 44 Insert a Background Image 44 Add a Bookmark 45 Add a Multimedia File to a Report 48 Apply a Table Style 50 Apply Padding 51 Add a Page 51 Create Page Sets 52 Join Nested Page Sets 52 Preparing a Product List Report 53 Swap Columns and Rows 55



Links: http://support.cognos.com www.datawarehouse.com http://www.cognos.com/products http://support.cognos.com/en/support/knowledgebase/index.html

You May Also Find These Documents Helpful

  • Good Essays

    Management 340 Week 5

    • 568 Words
    • 3 Pages

    A report is a business document containing only predefined data; it is a passive document used solely for reading or viewing. Examples of reports are invoices, weekly sales summaries by region and salesperson, and a pie chart of population by age categories. Bad reports are reports that have incorrect data and non-user friendly designs which…

    • 568 Words
    • 3 Pages
    Good Essays
  • Good Essays

    E. Coli survived the first ten seconds of emergence in boiling water. S. Marcescens survived the first ten seconds of emergence in boiling water. B. Cereus survived 10 seconds, 30 seconds, 60 seconds, and 300 seconds of emergence in boiling water.…

    • 873 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    The diagnosis category I would choose in this case would be Diseases of the Skin and Subcutaneous Tissue—Codes 680–709. The reasoning for this is that the patient’s problem is a wound that is not healing on her foot. The fact that the patient suffers from diabetes is not a diagnosis of why the wound is not…

    • 263 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Com 107 Final Study Guide

    • 2669 Words
    • 11 Pages

    * How did “packaging” of products allow manufacturers (and advertisers) to demand more money for the product? When consumers began demanding certain products either because of quality or because of advertising manufacturers were able to raise the prices of their goods.…

    • 2669 Words
    • 11 Pages
    Powerful Essays
  • Good Essays

    CIS510 STUDENT GUIDE

    • 6331 Words
    • 26 Pages

    This course provides an integrated approach to system analysis and design processes. Students will explore advanced topics to evaluate and select system development methodologies and design system solutions. The role of effective interpersonal communication techniques and integration practices with users and user systems is emphasized.…

    • 6331 Words
    • 26 Pages
    Good Essays
  • Good Essays

    The purpose of this lab is to isolate a bacterial population from the normal throat flora. A streak plate method will be used to obtain a pure culture of a Gram positive coccus genus of bacteria. Several biochemical tests will be performed to aid in the identification of this unknown bacterium. Biochemical tests are a series of tests used to identify certain bacterium The various tests that are used in this lab are the catalase test, oxidase test, blood hemolytic test, MSA, blood agar, and PEA/ab sens test. A known Gram positive coccus bacteria will be used alongside an isolated Gram positive unknown bacteria for comparison to aid in the ability to identify the isolated organism to the genus level.…

    • 368 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    As part of your research plan, you must first draft a research question for your research paper that will guide the rest of your writing. A research question, which is more specific and focused than a general topic, is the question that your research paper will be answering. For example, if your general area of interest is social security, a possible research question might ask “How can low-income families save more money if the United States had a reformed social security plan that includes personal retirement accounts?”…

    • 748 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Exam Guide

    • 1366 Words
    • 6 Pages

    b. The act of buying stock of a corporation amounts to buying a part of that corporation.…

    • 1366 Words
    • 6 Pages
    Good Essays
  • Satisfactory Essays

    Content Guide

    • 361 Words
    • 2 Pages

    US Government – Regular and Honors Chapter 18 – The Judicial System (17 Points Total) Chapter 18, Section 1 (6 Points) For the following chart, fill in the appropriate information |Term |Define | | |Cases can be heard only in the federal courts. | |Exclusive Jurisdiction | | | |Share the power to hear a federal court or a state court. | |Concurrent Jurisdiction | | | |The person who file the suit | |Plaintiff | | | |The person whom the complaint is against | |Defendant | | | |A court in which a case is first heard | |Original Jurisdiction | | | |A court that hears a case on appeal form a lower court | |Appellate Jurisdiction | | Chapter 18, Section 3 (6 Points)…

    • 361 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Mos Guide

    • 31662 Words
    • 127 Pages

    This document was written to provide a personal overview of each Marine Officer Military Occupational Specialty (MOS). Its primary purpose is to give Marine lieutenants an overview of officer’s MOSs to assist them in deciding their preferences for MOS selection at The Basic School (TBS).…

    • 31662 Words
    • 127 Pages
    Powerful Essays
  • Powerful Essays

    COGS Q Final Study Guide

    • 1540 Words
    • 7 Pages

    A4. People's ideas about their own and others' mental states -- about their feelings, perceptions, and thoughts and the behavior these might predict…

    • 1540 Words
    • 7 Pages
    Powerful Essays
  • Powerful Essays

    c200 pacing guide

    • 1177 Words
    • 14 Pages

    If you engage in all of the learning activities to develop your competence, this course of…

    • 1177 Words
    • 14 Pages
    Powerful Essays
  • Powerful Essays

    own dwelling. It is the nurse responsibility to foster this thirst for information and help guide our…

    • 1351 Words
    • 6 Pages
    Powerful Essays
  • Good Essays

    guide

    • 710 Words
    • 3 Pages

    The case method is a crucial learning tool in education by allowing students to “bring to life” events and conceptual materials that are difficult to understand without application. Case method also aids in integrating tools and concepts students have learned in previous coursework by applying that knowledge to relevant decision-making situations. The HBR cases selected for this course are issues and problems actually faced by managers, with supporting facts, opinions, and financial data on which decisions were based. In these “real-life” situations, case writers provide you with the relevant information that would have been available to the decision makers involved at that time. You might feel that the information presented is incomplete, but remember this is the way that managers would in reality have to make decisions based on limited information. Obtaining more information costs time and money, resources, or may not be feasible. Each case is unique and the environment may not be the same now. Since there is no one best procedure for solving problems or making decisions, there is no right or wrong answers in case analysis. Each of you will approach the case in a different manner. However, you can use the following procedure as a rough guide to your analysis which can be fine-tuned to personal preferences:…

    • 710 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    To make the examples extra easy to follow, they're all formatted with the Report 5 format, which you can apply…

    • 2047 Words
    • 9 Pages
    Powerful Essays