Book Image

IBM Cognos 10 Report Studio Cookbook, Second Edition - Second Edition

Book Image

IBM Cognos 10 Report Studio Cookbook, Second Edition - Second Edition

Overview of this book

IBM Cognos Report Studio is widely used for creating and managing business reports in medium to large companies. It is simple enough for any business analyst, power user, or developer to pick up and start developing basic reports. However, this book is designed to take the reader beyond the basics and into the world of creating more sophisticated, functional business reports.IBM Cognos 10 Report Studio Cookbook, Second Edition helps you understand and use all the features provided by Report Studio to generate impressive deliverables. It will take you from being a beginner to a professional report author. It bridges the gap between basic training provided by manuals or trainers and the practical techniques learned over years of practice.Written in a recipe style, this book offers step-by-step instructions for IBM Cognos Report Studio users to author reports effectively, allowing a reader to dip in and out of the chapters as they desire. You will see a new fictional business case in each recipe that will relate to a real-life problem and then you will learn how to crack it in Report Studio. This book covers all the basic and advanced features of Report Authoring. It introduces the fundamental features useful across any level of reporting. Then it ascends to advanced techniques and tricks to overcome Studio limitations. Develop excellent reports using dimensional data sources by following best practices that development work requires in Report Studio. You will also learn about editing the report outside the Studio by directly editing the XML specifications. You will discover how to build and use Cognos Active Reports, a new addition in IBM Cognos 10. Provide richness to the user interface by adding JavaScript and HTML tags and using the different chart types introduced in IBM Cognos 10. The main focus is on the practical use of various powerful features that Report Studio has to offer to suit your business requirements. Learn numerous techniques and hacks that will allow you to make the best out of your IBM Cognos 10 Report Studio.
Table of Contents (21 chapters)
IBM Cognos 10 Report Studio Cookbook Second Edition
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Index

A

  • Absolute / How it works...
  • Active Reports
    • about /
  • Advanced Conditional Style option /
  • Aggregate button /
  • aggregation
    • about /
    • versus pre-aggregated values /
  • aggregation mode
    • about /
  • Alias member unique name / How to do it..., Alias member unique name
  • Alias member unique names option /
  • Allow horizontal pagination option /
  • Ancestor button /
  • Apply Style button /
  • auto-submit property /

B

  • Background Color dialog /
  • Background Effects Presets /
  • Block Variable dialog /
  • Blue liner gradient with blue border preset /
  • boolean variable /
  • Box Type property /
  • BSP Software
    • URL /
  • bullet charts
    • about /
    • components /
    • creating /

C

  • <conditionalStyles> tag /
  • <crosstabColumns> tag /
  • @Comments parameter /
  • CAFÉ
    • about /
  • CanSubmitPrompt() function /
  • cascaded prompts
    • adding /
    • working /
    • cascade source /
    • auto-submit property /
  • cells
    • merging, in Excel /
  • chart
    • types /
    • formatting, options /
    • Palette Presets /
    • Background Effects Presets /
    • converting, to another chart type /
  • Chart Palette Presets /
  • Chart report /
  • charts
    • about /
  • CheckData() function /
  • classes
  • Clustered Column with 3-D Effects chart /
  • Clustered Cylinder Bar with 3-D Effects chart /
  • CMS
    • about /
  • code
  • Cognos
    • SDK /
    • third-party tools /
  • Cognos PowerCube-based /
  • Cognos Workspace
    • about /
  • Cognos Workspace Advanced /
  • Colored Regions property /
  • column
    • hiding, in crosstabs /
  • columns
    • filtering /
  • column titles
  • comments
  • conditional block
    • about /
    • using /
  • conditional column titles
    • about /
    • working /
  • conditional formatting
    • about /
    • adding /
    • string variable /
    • boolean variable /
    • report language variable /
  • conditional styles
    • playing /
    • unreferenced conditional styles, deleting /
  • Connect button /
  • container size
    • controlling /
  • Copy Report to Clipboard option /
  • Create a parameterized filter option /
  • Create new query option /
  • crosstab
    • column, hiding /
  • crosstab intersection
    • drill through, defining /
  • crosstab intersection drill-through definition
    • overriding /
  • crosstab report
    • using, instead of list report /
  • CSVIdentityMap macro
    • used, for data level security adding /
  • CSVIdentityNameList function /
  • current_timestamp parameter /

D

  • database
    • writing, back to /
  • Data Button Bar Query /
  • Data Check Box Group
    • used, for data filteration /
  • data containers
  • Data Deck
    • about /
    • working with /
  • data expression window
    • values, browsing from /
  • data format
    • default data format, using /
  • data formatting
  • Data Items pane
  • data level security
    • adding, CSVIdentityMap macro used /
  • Data Tab control /
  • Data Toggle Button Bar control /
  • dates
    • formatting /
  • Date Time control
    • about /
    • manipulating /
    • working /
  • Deck
    • working with /
  • Deck Control /
  • Define content option /
  • detail
    • about /
    • before aggregation, applying /
    • after aggregation, applying /
  • detail filters
    • about /
    • working /
  • Dimensionally Modeled Relational (DMR) schemas /
  • dimensions
    • swapping, MUN manipulation used /
  • DimTime crosstab /
  • display value property /
    • versus value property /
  • DMR
    • about /
  • drill-through
  • Drill-through Definition1 button /
  • drill link
    • alternating /
    • render variable /
    • copying /
    • pasting /
  • drill targets
    • changing /
  • dynamic default values
    • defining, for prompt /
    • Span /
    • GetElementsByTagName /
    • SelectedIndex /
    • CanSubmitPrompt /

E

F

  • filter function /
  • filtering, Report Studio
    • detail /
    • summary /
    • slicer /
  • filters /
    • if then else, implementing /
  • Finish button /
  • First Slice Angle property /
  • footer
    • report name, displaying /
    • user name, displaying /

G

  • GetElementsByTagName function /
  • GO Data Warehouse (query) /
  • GO Data Warehouse (query) package
    • using /
  • Google Map example /
  • grab them all
    • about /
    • using /
  • great_outdoor_warehouse /
  • grouped values
    • sorting /
    • working /

H

  • hidden items
  • Hide Adornment property /
  • horizontal pagination
    • about /
    • steps /
    • used, for page numbering /
  • HTML items
    • execution error /
  • Hyperlink component
    • using, for linking /
    /

I

J

L

  • Limit on inserted individual members option /
  • List data container / How to do it...
  • List Query /
  • list report
    • line chart, nesting /
    /

M

  • % margin
    • formatting /
  • macro
    • used, for token adding /
  • Macros
    • about /
  • master detail relationship
    • defining /
  • Maximum Execution Time property /
  • maximum row limit
    • setting, for query /
  • MHT (Microsoft Hypertext Archive) /
  • missing image issue
    • handling /
  • missing values
  • MONTH YEAR format /
  • Multidimensional Expressions (MDX) /
  • multiple aggregation /
  • MUN manipulation
    • used, for dimension swapping /

N

  • (nnn) nnn-nnnn format /
  • negative values
    • formatting /
    • Running difference function /
    • marking /
  • No. of Decimal Places property / How it works...
  • numbers
    • formatting /
  • numerical format
    • formatting /
  • Numeric Baseline property /

O

  • OM /
  • Open Report from Clipboard option /
  • Optional_defaultValue /
  • orphan rows
    • about /
    • eliminating /

P

  • page
    • numbering, horizontal pagination used /
    • structure, viewing /
  • Page Explorer /
  • page orientation
    • specifying /
  • Page Set properties /
  • page sets
    • defining /
  • page size
    • specifying /
  • page title repetition
    • avoiding /
  • Pagination property /
  • ParamDisplayValue (parameter name) function /
  • ParamValue (parameter name) function /
  • patterns
  • PDF Page Setup property /
  • percentages
    • formatting /
  • Pick-Up Style button /
  • pie charts
    • about /
    • creating /
  • PL /
  • Plot Area Fill property /
  • pre-aggregated values
    • versus aggregation /
  • ProductKey parameter /
  • prompt
    • output format, choosing /
    • adding, to Slicer /
    • making optional /
  • Prompt() function /
  • PROMPT() function /
  • prompt() macros
    • using /
  • promptButtonFinish() function /
  • prompt controls
    • showing, at runtime /
    • hiding, at runtime /
  • prompt macro
    • using, in SQL /
  • Prompt Macro functions /
  • promptmany()macros
    • using /
  • prompt types /
  • prompt values
    • dispalying, in security based report /
  • Properties pane /
  • Pure_Optional /

Q

R

S

  • sales report
    • creating /
  • scatter charts
  • Section button /
  • sections
    • creating /
    • creating, advantages /
  • security based report
    • prompt values, dispalying /
  • SelectedIndex property /
  • Select Multiple Values button /
  • Set () function /
  • SET() function / How to do it...
  • setValue function /
  • Show Hidden Objects / Highlighting hidden items
  • Size and Overflow property /
  • Slicer
    • prompt, adding /
  • slicers /
  • Slide Animation Direction property /
  • slow report
    • validation, handling /
  • SM /
  • Source type property /
  • SQL
    • prompt macro, using in /
  • Stored Procedure Query Subject /
  • string variable /
  • Structure | Create Crosstab Nodes /
  • style.display property /
  • style variable property /
  • Substitute() function /
  • Summarize Small Slices property /
  • summary /
  • summary filters
    • about /
    • working /
  • Suppress icon /
  • Suppression property /

T

  • tabbed reports
    • building /
  • Tabs Definition button /
  • Target revenue /
  • templates
  • textbox prompts
    • validating /
  • Text property /
  • text source variable property /
  • Text Source Variable property /
  • Time (ship date) dimension /
  • Time dimension /
  • timestampMask() function /
  • TOAD /
  • token
    • adding, macro used /
  • Tools | CopyReporttoClipboard option /
  • Tools | OpenReportfromClipboard option /
  • Tools | Options | View | Reuse IBM Cognos Viewer window /
  • Tools | Show Generated SQL/MDX option /
  • traffic light report /

U

  • URL Source Variable dialog /
  • user name
    • dispalying, in footer /
  • use value property /

V

  • value prompt title
    • changing /
  • value property
    • versus display value property /
  • values
    • selecting automatically /
    • submitting automatically /
  • variable width bar chart
    • creating, JavaScript used /
  • View | Visual Aids /

W

X

  • XML
    • about /
    • feature, row level formatting /

Z