IBM Cognos 10 report studio cookbook /:
Annotation
Gespeichert in:
1. Verfasser: | |
---|---|
Weitere Verfasser: | |
Format: | Elektronisch E-Book |
Sprache: | English |
Veröffentlicht: |
Birmingham :
Packt Publishing,
[2013]
|
Ausgabe: | Second edition. |
Schlagworte: | |
Online-Zugang: | Volltext |
Zusammenfassung: | Annotation |
Beschreibung: | Includes index. |
Beschreibung: | 1 online resource (364 pages) : illustrations |
ISBN: | 9781849688215 1849688214 1849688206 9781849688208 |
Internformat
MARC
LEADER | 00000cam a2200000 i 4500 | ||
---|---|---|---|
001 | ZDB-4-EBA-ocn861526456 | ||
003 | OCoLC | ||
005 | 20240705115654.0 | ||
006 | m o d | ||
007 | cr cn||||||||| | ||
008 | 111102s2013 enka o 001 0 eng d | ||
040 | |a E7B |b eng |e rda |e pn |c E7B |d OCLCO |d N$T |d OCLCO |d OCLCF |d COO |d REB |d OCLCO |d OCLCQ |d OCLCO |d DEBSZ |d OCLCO |d AGLDB |d OCLCQ |d CNNOR |d OCLCQ |d MOR |d PIFAG |d OCLCQ |d U3W |d STF |d NRAMU |d CRU |d OCLCQ |d INT |d VT2 |d OCLCQ |d WYU |d G3B |d TKN |d OCLCQ |d QGK |d OCLCO |d OCLCQ |d OCLCO |d OCLCL | ||
019 | |a 890379567 |a 961554867 |a 962582932 |a 1259207884 | ||
020 | |a 9781849688215 |q (electronic bk.) | ||
020 | |a 1849688214 |q (electronic bk.) | ||
020 | |a 1849688206 | ||
020 | |a 9781849688208 | ||
020 | |z 9781849688208 | ||
024 | 3 | |a 9781849688208 | |
035 | |a (OCoLC)861526456 |z (OCoLC)890379567 |z (OCoLC)961554867 |z (OCoLC)962582932 |z (OCoLC)1259207884 | ||
037 | |b 01201872 | ||
050 | 4 | |a HF5719 |b .L37 2013eb | |
072 | 7 | |a BUS |x 082000 |2 bisacsh | |
072 | 7 | |a BUS |x 041000 |2 bisacsh | |
072 | 7 | |a BUS |x 042000 |2 bisacsh | |
072 | 7 | |a BUS |x 085000 |2 bisacsh | |
082 | 7 | |a 658.472028553 | |
049 | |a MAIN | ||
100 | 1 | |a Lashin, Ahmed. | |
245 | 1 | 0 | |a IBM Cognos 10 report studio cookbook / |c Ahmed Lashin, Abhishek Sanghani. |
250 | |a Second edition. | ||
264 | 1 | |a Birmingham : |b Packt Publishing, |c [2013] | |
264 | 4 | |c ©2013 | |
300 | |a 1 online resource (364 pages) : |b illustrations | ||
336 | |a text |b txt |2 rdacontent | ||
337 | |a computer |b c |2 rdamedia | ||
338 | |a online resource |b cr |2 rdacarrier | ||
347 | |a text file | ||
500 | |a Includes index. | ||
588 | 0 | |a Online resource; title from PDF title page (ebrary, viewed September 24, 2013). | |
520 | 8 | |a Annotation |b 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. | |
505 | 0 | |a Cover -- Copyright -- Credits -- About the Authors -- About the Reviewers -- www.PacktPub.com -- Preface -- Table of Contents -- Chapter 1: Report Authoring Basic Concepts -- Introduction -- Summary filters and detail filters -- Sorting grouped values -- Aggregation and rollup aggregation -- Implementing if-then-else in filters -- Formatting data -- dates, numbers, and percentages -- Creating sections -- Hiding columns in crosstabs -- Prompts -- display value versus use value -- Chapter 2 : Advanced Report Authoring -- Introduction -- Adding cascaded prompts -- Creating a nested report -- defining the master detail relationship -- Writing back to the database -- Adding conditional formatting -- Formatting negative values -- Playing with conditional styles -- Using conditional blocks -- many reports in one -- Defining drill-through from crosstab intersection -- Overriding crosstab intersection drill-through definitions -- Chapter 3 : Using JavaScript Files -- Tips and Tricks -- Introduction -- Defining dynamic default values for prompts -- Changing the title of the value prompt -- Validating textbox prompts -- Showing/hiding prompt controls at runtime -- Selecting and submitting values automatically -- Manipulating the Date Time control -- Creating a variable width bar chart using JavaScript -- Chapter 4 : The Report Page -- Tips and Tricks -- Introduction -- Showing images dynamically (traffic light report) -- Handling the missing image issue -- Dynamic links to an external website (a Google Maps example) -- Alternating drill links -- Showing tooltips on reports -- Merged cells in Excel output -- Worksheet name in Excel output -- Conditional column titles -- Chapter 5 : Working with XML -- Introduction -- Changing drill targets quickly -- Copying and pasting drill links -- Removing references to old packages or items. | |
505 | 8 | |a A hidden gem in XML -- row level formatting -- Chapter 6 : Writing Printable Reports -- Introduction -- Controlling the container size and rows per page -- Eliminating orphan rows -- Defining page orientation and size (and overriding them for one page) -- Avoiding page title repetition -- Horizontal pagination -- Page numbering with horizontal pagination -- Choosing the output format from a prompt -- Choosing the right colors -- Defining page sets -- Cautions about HTML items and JavaScript files -- Displaying the report name in a footer -- Chapter 7 : Working with Dimensional Models -- Introduction -- List report or crosstab report -- Filtering rows or columns -- Filtering a whole report -- Adding a prompt into Slicer and its limitations -- Achieving zero suppression -- Aggregation versus preaggregated values -- The roleValue() function -- Swapping dimensions using MUN manipulation -- Chapter 8 : Working with Macros -- Introduction -- Adding data-level security using the CSVIdentityMap macro -- Using the Prompt macro in native SQL -- Making prompts optional -- Adding a token using macros -- Using the prompt() and promptmany() macros in query subjects -- Showing the prompt values in a report based on security -- String operations to get it right -- Showing a username in the footer -- Chapter 9 : Using Report Studio Efficiently -- Introduction -- Using Report Studio's environmental options -- Copying and pasting partial or full reports -- Upgrading report specifications -- Setting the execution timeout -- Setting the maximum row limit -- Handling slow report validation -- Capturing a query -- Browsing values from the data expression window -- Viewing the page structure -- Picking up and applying styles -- Using the "grab them all" practice -- Using Default Data Formats -- Chapter 10 : Working with Active Reports -- Introduction. | |
505 | 8 | |a Building tabbed reports -- Working with Decks -- Working with the Data Deck -- Filtering data using Data Check Box Group -- Chapter 11 : Charts and New Chart Features -- Introduction -- Chart formatting options -- Converting a chart to another chart type -- Working with pie charts -- Getting started with bullet charts -- Getting started with scatter charts -- Chapter 12 : More Useful Recipes -- Introduction -- Timing report execution -- Missing values versus zero values -- Overriding data formatting using patterns -- Setting up conditional drill-throughs -- Dynamically switching between reports using an iFrame -- Freezing column titles -- Chapter 13 : Best Practices -- Introduction -- Reducing the number of query items -- Highlighting hidden items -- Using relative paths for images -- Controlling JavaScript file execution -- Customizing classes for report-wide effect -- Creating templates -- Regression testing -- Commenting the code -- Naming data containers (lists, crosstabs, and charts) for use in Cognos Workspace -- Enabling a larger worksheet size for Excel 2007 -- Appendix: Recommendations and References -- Introduction -- Version controlling -- Recommendations for prompt types -- Cognos Mashup Service -- SDK and third-party tools for Cognos -- IBM Cognos Analysis For Excel (CAFE) -- IBM Cognos for Microsoft Office -- IBM Cognos Workspace -- IBM Cognos Workspace Advanced -- IBM Cognos Cloud -- Index. | |
546 | |a English. | ||
650 | 0 | |a Business report writing |x Computer programs. | |
650 | 0 | |a Database management |x Computer programs. |0 http://id.loc.gov/authorities/subjects/sh85035849 | |
650 | 2 | |a Database Management Systems |0 https://id.nlm.nih.gov/mesh/D003628 | |
650 | 6 | |a Style commercial |x Logiciels. | |
650 | 6 | |a Bases de données |x Gestion |x Logiciels. | |
650 | 7 | |a BUSINESS & ECONOMICS |x Industrial Management. |2 bisacsh | |
650 | 7 | |a BUSINESS & ECONOMICS |x Management. |2 bisacsh | |
650 | 7 | |a BUSINESS & ECONOMICS |x Management Science. |2 bisacsh | |
650 | 7 | |a BUSINESS & ECONOMICS |x Organizational Behavior. |2 bisacsh | |
650 | 7 | |a Business report writing |x Computer programs |2 fast | |
650 | 7 | |a Database management |x Computer programs |2 fast | |
700 | 1 | |a Sanghani, Abhishek. | |
758 | |i has work: |a IBM Cognos 10 Report Studio Cookbook (Text) |1 https://id.oclc.org/worldcat/entity/E39PCYdxvcwkbcy7XfrqR8vwVK |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
776 | 0 | |z 1849688206 | |
776 | 0 | |z 1299832474 | |
856 | 1 | |l FWS01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=637272 |3 Volltext | |
856 | 1 | |l CBO01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=637272 |3 Volltext | |
936 | |a BATCHLOAD | ||
938 | |a ebrary |b EBRY |n ebr10754160 | ||
938 | |a EBSCOhost |b EBSC |n 637272 | ||
994 | |a 92 |b GEBAY | ||
912 | |a ZDB-4-EBA |
Datensatz im Suchindex
DE-BY-FWS_katkey | ZDB-4-EBA-ocn861526456 |
---|---|
_version_ | 1813903624877637632 |
adam_text | |
any_adam_object | |
author | Lashin, Ahmed |
author2 | Sanghani, Abhishek |
author2_role | |
author2_variant | a s as |
author_facet | Lashin, Ahmed Sanghani, Abhishek |
author_role | |
author_sort | Lashin, Ahmed |
author_variant | a l al |
building | Verbundindex |
bvnumber | localFWS |
callnumber-first | H - Social Science |
callnumber-label | HF5719 |
callnumber-raw | HF5719 .L37 2013eb |
callnumber-search | HF5719 .L37 2013eb |
callnumber-sort | HF 45719 L37 42013EB |
callnumber-subject | HF - Commerce |
collection | ZDB-4-EBA |
contents | Cover -- Copyright -- Credits -- About the Authors -- About the Reviewers -- www.PacktPub.com -- Preface -- Table of Contents -- Chapter 1: Report Authoring Basic Concepts -- Introduction -- Summary filters and detail filters -- Sorting grouped values -- Aggregation and rollup aggregation -- Implementing if-then-else in filters -- Formatting data -- dates, numbers, and percentages -- Creating sections -- Hiding columns in crosstabs -- Prompts -- display value versus use value -- Chapter 2 : Advanced Report Authoring -- Introduction -- Adding cascaded prompts -- Creating a nested report -- defining the master detail relationship -- Writing back to the database -- Adding conditional formatting -- Formatting negative values -- Playing with conditional styles -- Using conditional blocks -- many reports in one -- Defining drill-through from crosstab intersection -- Overriding crosstab intersection drill-through definitions -- Chapter 3 : Using JavaScript Files -- Tips and Tricks -- Introduction -- Defining dynamic default values for prompts -- Changing the title of the value prompt -- Validating textbox prompts -- Showing/hiding prompt controls at runtime -- Selecting and submitting values automatically -- Manipulating the Date Time control -- Creating a variable width bar chart using JavaScript -- Chapter 4 : The Report Page -- Tips and Tricks -- Introduction -- Showing images dynamically (traffic light report) -- Handling the missing image issue -- Dynamic links to an external website (a Google Maps example) -- Alternating drill links -- Showing tooltips on reports -- Merged cells in Excel output -- Worksheet name in Excel output -- Conditional column titles -- Chapter 5 : Working with XML -- Introduction -- Changing drill targets quickly -- Copying and pasting drill links -- Removing references to old packages or items. A hidden gem in XML -- row level formatting -- Chapter 6 : Writing Printable Reports -- Introduction -- Controlling the container size and rows per page -- Eliminating orphan rows -- Defining page orientation and size (and overriding them for one page) -- Avoiding page title repetition -- Horizontal pagination -- Page numbering with horizontal pagination -- Choosing the output format from a prompt -- Choosing the right colors -- Defining page sets -- Cautions about HTML items and JavaScript files -- Displaying the report name in a footer -- Chapter 7 : Working with Dimensional Models -- Introduction -- List report or crosstab report -- Filtering rows or columns -- Filtering a whole report -- Adding a prompt into Slicer and its limitations -- Achieving zero suppression -- Aggregation versus preaggregated values -- The roleValue() function -- Swapping dimensions using MUN manipulation -- Chapter 8 : Working with Macros -- Introduction -- Adding data-level security using the CSVIdentityMap macro -- Using the Prompt macro in native SQL -- Making prompts optional -- Adding a token using macros -- Using the prompt() and promptmany() macros in query subjects -- Showing the prompt values in a report based on security -- String operations to get it right -- Showing a username in the footer -- Chapter 9 : Using Report Studio Efficiently -- Introduction -- Using Report Studio's environmental options -- Copying and pasting partial or full reports -- Upgrading report specifications -- Setting the execution timeout -- Setting the maximum row limit -- Handling slow report validation -- Capturing a query -- Browsing values from the data expression window -- Viewing the page structure -- Picking up and applying styles -- Using the "grab them all" practice -- Using Default Data Formats -- Chapter 10 : Working with Active Reports -- Introduction. Building tabbed reports -- Working with Decks -- Working with the Data Deck -- Filtering data using Data Check Box Group -- Chapter 11 : Charts and New Chart Features -- Introduction -- Chart formatting options -- Converting a chart to another chart type -- Working with pie charts -- Getting started with bullet charts -- Getting started with scatter charts -- Chapter 12 : More Useful Recipes -- Introduction -- Timing report execution -- Missing values versus zero values -- Overriding data formatting using patterns -- Setting up conditional drill-throughs -- Dynamically switching between reports using an iFrame -- Freezing column titles -- Chapter 13 : Best Practices -- Introduction -- Reducing the number of query items -- Highlighting hidden items -- Using relative paths for images -- Controlling JavaScript file execution -- Customizing classes for report-wide effect -- Creating templates -- Regression testing -- Commenting the code -- Naming data containers (lists, crosstabs, and charts) for use in Cognos Workspace -- Enabling a larger worksheet size for Excel 2007 -- Appendix: Recommendations and References -- Introduction -- Version controlling -- Recommendations for prompt types -- Cognos Mashup Service -- SDK and third-party tools for Cognos -- IBM Cognos Analysis For Excel (CAFE) -- IBM Cognos for Microsoft Office -- IBM Cognos Workspace -- IBM Cognos Workspace Advanced -- IBM Cognos Cloud -- Index. |
ctrlnum | (OCoLC)861526456 |
dewey-full | 658.472028553 |
dewey-hundreds | 600 - Technology (Applied sciences) |
dewey-ones | 658 - General management |
dewey-raw | 658.472028553 |
dewey-search | 658.472028553 |
dewey-sort | 3658.472028553 |
dewey-tens | 650 - Management and auxiliary services |
discipline | Wirtschaftswissenschaften |
edition | Second edition. |
format | Electronic eBook |
fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>10229cam a2200745 i 4500</leader><controlfield tag="001">ZDB-4-EBA-ocn861526456</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20240705115654.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr cn|||||||||</controlfield><controlfield tag="008">111102s2013 enka o 001 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">E7B</subfield><subfield code="b">eng</subfield><subfield code="e">rda</subfield><subfield code="e">pn</subfield><subfield code="c">E7B</subfield><subfield code="d">OCLCO</subfield><subfield code="d">N$T</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCF</subfield><subfield code="d">COO</subfield><subfield code="d">REB</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">DEBSZ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">AGLDB</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">CNNOR</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">MOR</subfield><subfield code="d">PIFAG</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">U3W</subfield><subfield code="d">STF</subfield><subfield code="d">NRAMU</subfield><subfield code="d">CRU</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">INT</subfield><subfield code="d">VT2</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">WYU</subfield><subfield code="d">G3B</subfield><subfield code="d">TKN</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">QGK</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCL</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">890379567</subfield><subfield code="a">961554867</subfield><subfield code="a">962582932</subfield><subfield code="a">1259207884</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781849688215</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1849688214</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1849688206</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781849688208</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9781849688208</subfield></datafield><datafield tag="024" ind1="3" ind2=" "><subfield code="a">9781849688208</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)861526456</subfield><subfield code="z">(OCoLC)890379567</subfield><subfield code="z">(OCoLC)961554867</subfield><subfield code="z">(OCoLC)962582932</subfield><subfield code="z">(OCoLC)1259207884</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="b">01201872</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">HF5719</subfield><subfield code="b">.L37 2013eb</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">BUS</subfield><subfield code="x">082000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">BUS</subfield><subfield code="x">041000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">BUS</subfield><subfield code="x">042000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">BUS</subfield><subfield code="x">085000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">658.472028553</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Lashin, Ahmed.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">IBM Cognos 10 report studio cookbook /</subfield><subfield code="c">Ahmed Lashin, Abhishek Sanghani.</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">Second edition.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Birmingham :</subfield><subfield code="b">Packt Publishing,</subfield><subfield code="c">[2013]</subfield></datafield><datafield tag="264" ind1=" " ind2="4"><subfield code="c">©2013</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (364 pages) :</subfield><subfield code="b">illustrations</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="347" ind1=" " ind2=" "><subfield code="a">text file</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index.</subfield></datafield><datafield tag="588" ind1="0" ind2=" "><subfield code="a">Online resource; title from PDF title page (ebrary, viewed September 24, 2013).</subfield></datafield><datafield tag="520" ind1="8" ind2=" "><subfield code="a">Annotation</subfield><subfield code="b">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.</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="a">Cover -- Copyright -- Credits -- About the Authors -- About the Reviewers -- www.PacktPub.com -- Preface -- Table of Contents -- Chapter 1: Report Authoring Basic Concepts -- Introduction -- Summary filters and detail filters -- Sorting grouped values -- Aggregation and rollup aggregation -- Implementing if-then-else in filters -- Formatting data -- dates, numbers, and percentages -- Creating sections -- Hiding columns in crosstabs -- Prompts -- display value versus use value -- Chapter 2 : Advanced Report Authoring -- Introduction -- Adding cascaded prompts -- Creating a nested report -- defining the master detail relationship -- Writing back to the database -- Adding conditional formatting -- Formatting negative values -- Playing with conditional styles -- Using conditional blocks -- many reports in one -- Defining drill-through from crosstab intersection -- Overriding crosstab intersection drill-through definitions -- Chapter 3 : Using JavaScript Files -- Tips and Tricks -- Introduction -- Defining dynamic default values for prompts -- Changing the title of the value prompt -- Validating textbox prompts -- Showing/hiding prompt controls at runtime -- Selecting and submitting values automatically -- Manipulating the Date Time control -- Creating a variable width bar chart using JavaScript -- Chapter 4 : The Report Page -- Tips and Tricks -- Introduction -- Showing images dynamically (traffic light report) -- Handling the missing image issue -- Dynamic links to an external website (a Google Maps example) -- Alternating drill links -- Showing tooltips on reports -- Merged cells in Excel output -- Worksheet name in Excel output -- Conditional column titles -- Chapter 5 : Working with XML -- Introduction -- Changing drill targets quickly -- Copying and pasting drill links -- Removing references to old packages or items.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">A hidden gem in XML -- row level formatting -- Chapter 6 : Writing Printable Reports -- Introduction -- Controlling the container size and rows per page -- Eliminating orphan rows -- Defining page orientation and size (and overriding them for one page) -- Avoiding page title repetition -- Horizontal pagination -- Page numbering with horizontal pagination -- Choosing the output format from a prompt -- Choosing the right colors -- Defining page sets -- Cautions about HTML items and JavaScript files -- Displaying the report name in a footer -- Chapter 7 : Working with Dimensional Models -- Introduction -- List report or crosstab report -- Filtering rows or columns -- Filtering a whole report -- Adding a prompt into Slicer and its limitations -- Achieving zero suppression -- Aggregation versus preaggregated values -- The roleValue() function -- Swapping dimensions using MUN manipulation -- Chapter 8 : Working with Macros -- Introduction -- Adding data-level security using the CSVIdentityMap macro -- Using the Prompt macro in native SQL -- Making prompts optional -- Adding a token using macros -- Using the prompt() and promptmany() macros in query subjects -- Showing the prompt values in a report based on security -- String operations to get it right -- Showing a username in the footer -- Chapter 9 : Using Report Studio Efficiently -- Introduction -- Using Report Studio's environmental options -- Copying and pasting partial or full reports -- Upgrading report specifications -- Setting the execution timeout -- Setting the maximum row limit -- Handling slow report validation -- Capturing a query -- Browsing values from the data expression window -- Viewing the page structure -- Picking up and applying styles -- Using the "grab them all" practice -- Using Default Data Formats -- Chapter 10 : Working with Active Reports -- Introduction.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Building tabbed reports -- Working with Decks -- Working with the Data Deck -- Filtering data using Data Check Box Group -- Chapter 11 : Charts and New Chart Features -- Introduction -- Chart formatting options -- Converting a chart to another chart type -- Working with pie charts -- Getting started with bullet charts -- Getting started with scatter charts -- Chapter 12 : More Useful Recipes -- Introduction -- Timing report execution -- Missing values versus zero values -- Overriding data formatting using patterns -- Setting up conditional drill-throughs -- Dynamically switching between reports using an iFrame -- Freezing column titles -- Chapter 13 : Best Practices -- Introduction -- Reducing the number of query items -- Highlighting hidden items -- Using relative paths for images -- Controlling JavaScript file execution -- Customizing classes for report-wide effect -- Creating templates -- Regression testing -- Commenting the code -- Naming data containers (lists, crosstabs, and charts) for use in Cognos Workspace -- Enabling a larger worksheet size for Excel 2007 -- Appendix: Recommendations and References -- Introduction -- Version controlling -- Recommendations for prompt types -- Cognos Mashup Service -- SDK and third-party tools for Cognos -- IBM Cognos Analysis For Excel (CAFE) -- IBM Cognos for Microsoft Office -- IBM Cognos Workspace -- IBM Cognos Workspace Advanced -- IBM Cognos Cloud -- Index.</subfield></datafield><datafield tag="546" ind1=" " ind2=" "><subfield code="a">English.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Business report writing</subfield><subfield code="x">Computer programs.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database management</subfield><subfield code="x">Computer programs.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh85035849</subfield></datafield><datafield tag="650" ind1=" " ind2="2"><subfield code="a">Database Management Systems</subfield><subfield code="0">https://id.nlm.nih.gov/mesh/D003628</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Style commercial</subfield><subfield code="x">Logiciels.</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Bases de données</subfield><subfield code="x">Gestion</subfield><subfield code="x">Logiciels.</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">BUSINESS & ECONOMICS</subfield><subfield code="x">Industrial Management.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">BUSINESS & ECONOMICS</subfield><subfield code="x">Management.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">BUSINESS & ECONOMICS</subfield><subfield code="x">Management Science.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">BUSINESS & ECONOMICS</subfield><subfield code="x">Organizational Behavior.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Business report writing</subfield><subfield code="x">Computer programs</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Database management</subfield><subfield code="x">Computer programs</subfield><subfield code="2">fast</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Sanghani, Abhishek.</subfield></datafield><datafield tag="758" ind1=" " ind2=" "><subfield code="i">has work:</subfield><subfield code="a">IBM Cognos 10 Report Studio Cookbook (Text)</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PCYdxvcwkbcy7XfrqR8vwVK</subfield><subfield code="4">https://id.oclc.org/worldcat/ontology/hasWork</subfield></datafield><datafield tag="776" ind1="0" ind2=" "><subfield code="z">1849688206</subfield></datafield><datafield tag="776" ind1="0" ind2=" "><subfield code="z">1299832474</subfield></datafield><datafield tag="856" ind1="1" ind2=" "><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=637272</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="856" ind1="1" ind2=" "><subfield code="l">CBO01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=637272</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="936" ind1=" " ind2=" "><subfield code="a">BATCHLOAD</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ebrary</subfield><subfield code="b">EBRY</subfield><subfield code="n">ebr10754160</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">637272</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield></record></collection> |
id | ZDB-4-EBA-ocn861526456 |
illustrated | Illustrated |
indexdate | 2024-10-25T16:21:39Z |
institution | BVB |
isbn | 9781849688215 1849688214 1849688206 9781849688208 |
language | English |
oclc_num | 861526456 |
open_access_boolean | |
owner | MAIN |
owner_facet | MAIN |
physical | 1 online resource (364 pages) : illustrations |
psigel | ZDB-4-EBA |
publishDate | 2013 |
publishDateSearch | 2013 |
publishDateSort | 2013 |
publisher | Packt Publishing, |
record_format | marc |
spelling | Lashin, Ahmed. IBM Cognos 10 report studio cookbook / Ahmed Lashin, Abhishek Sanghani. Second edition. Birmingham : Packt Publishing, [2013] ©2013 1 online resource (364 pages) : illustrations text txt rdacontent computer c rdamedia online resource cr rdacarrier text file Includes index. Online resource; title from PDF title page (ebrary, viewed September 24, 2013). Annotation 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. Cover -- Copyright -- Credits -- About the Authors -- About the Reviewers -- www.PacktPub.com -- Preface -- Table of Contents -- Chapter 1: Report Authoring Basic Concepts -- Introduction -- Summary filters and detail filters -- Sorting grouped values -- Aggregation and rollup aggregation -- Implementing if-then-else in filters -- Formatting data -- dates, numbers, and percentages -- Creating sections -- Hiding columns in crosstabs -- Prompts -- display value versus use value -- Chapter 2 : Advanced Report Authoring -- Introduction -- Adding cascaded prompts -- Creating a nested report -- defining the master detail relationship -- Writing back to the database -- Adding conditional formatting -- Formatting negative values -- Playing with conditional styles -- Using conditional blocks -- many reports in one -- Defining drill-through from crosstab intersection -- Overriding crosstab intersection drill-through definitions -- Chapter 3 : Using JavaScript Files -- Tips and Tricks -- Introduction -- Defining dynamic default values for prompts -- Changing the title of the value prompt -- Validating textbox prompts -- Showing/hiding prompt controls at runtime -- Selecting and submitting values automatically -- Manipulating the Date Time control -- Creating a variable width bar chart using JavaScript -- Chapter 4 : The Report Page -- Tips and Tricks -- Introduction -- Showing images dynamically (traffic light report) -- Handling the missing image issue -- Dynamic links to an external website (a Google Maps example) -- Alternating drill links -- Showing tooltips on reports -- Merged cells in Excel output -- Worksheet name in Excel output -- Conditional column titles -- Chapter 5 : Working with XML -- Introduction -- Changing drill targets quickly -- Copying and pasting drill links -- Removing references to old packages or items. A hidden gem in XML -- row level formatting -- Chapter 6 : Writing Printable Reports -- Introduction -- Controlling the container size and rows per page -- Eliminating orphan rows -- Defining page orientation and size (and overriding them for one page) -- Avoiding page title repetition -- Horizontal pagination -- Page numbering with horizontal pagination -- Choosing the output format from a prompt -- Choosing the right colors -- Defining page sets -- Cautions about HTML items and JavaScript files -- Displaying the report name in a footer -- Chapter 7 : Working with Dimensional Models -- Introduction -- List report or crosstab report -- Filtering rows or columns -- Filtering a whole report -- Adding a prompt into Slicer and its limitations -- Achieving zero suppression -- Aggregation versus preaggregated values -- The roleValue() function -- Swapping dimensions using MUN manipulation -- Chapter 8 : Working with Macros -- Introduction -- Adding data-level security using the CSVIdentityMap macro -- Using the Prompt macro in native SQL -- Making prompts optional -- Adding a token using macros -- Using the prompt() and promptmany() macros in query subjects -- Showing the prompt values in a report based on security -- String operations to get it right -- Showing a username in the footer -- Chapter 9 : Using Report Studio Efficiently -- Introduction -- Using Report Studio's environmental options -- Copying and pasting partial or full reports -- Upgrading report specifications -- Setting the execution timeout -- Setting the maximum row limit -- Handling slow report validation -- Capturing a query -- Browsing values from the data expression window -- Viewing the page structure -- Picking up and applying styles -- Using the "grab them all" practice -- Using Default Data Formats -- Chapter 10 : Working with Active Reports -- Introduction. Building tabbed reports -- Working with Decks -- Working with the Data Deck -- Filtering data using Data Check Box Group -- Chapter 11 : Charts and New Chart Features -- Introduction -- Chart formatting options -- Converting a chart to another chart type -- Working with pie charts -- Getting started with bullet charts -- Getting started with scatter charts -- Chapter 12 : More Useful Recipes -- Introduction -- Timing report execution -- Missing values versus zero values -- Overriding data formatting using patterns -- Setting up conditional drill-throughs -- Dynamically switching between reports using an iFrame -- Freezing column titles -- Chapter 13 : Best Practices -- Introduction -- Reducing the number of query items -- Highlighting hidden items -- Using relative paths for images -- Controlling JavaScript file execution -- Customizing classes for report-wide effect -- Creating templates -- Regression testing -- Commenting the code -- Naming data containers (lists, crosstabs, and charts) for use in Cognos Workspace -- Enabling a larger worksheet size for Excel 2007 -- Appendix: Recommendations and References -- Introduction -- Version controlling -- Recommendations for prompt types -- Cognos Mashup Service -- SDK and third-party tools for Cognos -- IBM Cognos Analysis For Excel (CAFE) -- IBM Cognos for Microsoft Office -- IBM Cognos Workspace -- IBM Cognos Workspace Advanced -- IBM Cognos Cloud -- Index. English. Business report writing Computer programs. Database management Computer programs. http://id.loc.gov/authorities/subjects/sh85035849 Database Management Systems https://id.nlm.nih.gov/mesh/D003628 Style commercial Logiciels. Bases de données Gestion Logiciels. BUSINESS & ECONOMICS Industrial Management. bisacsh BUSINESS & ECONOMICS Management. bisacsh BUSINESS & ECONOMICS Management Science. bisacsh BUSINESS & ECONOMICS Organizational Behavior. bisacsh Business report writing Computer programs fast Database management Computer programs fast Sanghani, Abhishek. has work: IBM Cognos 10 Report Studio Cookbook (Text) https://id.oclc.org/worldcat/entity/E39PCYdxvcwkbcy7XfrqR8vwVK https://id.oclc.org/worldcat/ontology/hasWork 1849688206 1299832474 FWS01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=637272 Volltext CBO01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=637272 Volltext |
spellingShingle | Lashin, Ahmed IBM Cognos 10 report studio cookbook / Cover -- Copyright -- Credits -- About the Authors -- About the Reviewers -- www.PacktPub.com -- Preface -- Table of Contents -- Chapter 1: Report Authoring Basic Concepts -- Introduction -- Summary filters and detail filters -- Sorting grouped values -- Aggregation and rollup aggregation -- Implementing if-then-else in filters -- Formatting data -- dates, numbers, and percentages -- Creating sections -- Hiding columns in crosstabs -- Prompts -- display value versus use value -- Chapter 2 : Advanced Report Authoring -- Introduction -- Adding cascaded prompts -- Creating a nested report -- defining the master detail relationship -- Writing back to the database -- Adding conditional formatting -- Formatting negative values -- Playing with conditional styles -- Using conditional blocks -- many reports in one -- Defining drill-through from crosstab intersection -- Overriding crosstab intersection drill-through definitions -- Chapter 3 : Using JavaScript Files -- Tips and Tricks -- Introduction -- Defining dynamic default values for prompts -- Changing the title of the value prompt -- Validating textbox prompts -- Showing/hiding prompt controls at runtime -- Selecting and submitting values automatically -- Manipulating the Date Time control -- Creating a variable width bar chart using JavaScript -- Chapter 4 : The Report Page -- Tips and Tricks -- Introduction -- Showing images dynamically (traffic light report) -- Handling the missing image issue -- Dynamic links to an external website (a Google Maps example) -- Alternating drill links -- Showing tooltips on reports -- Merged cells in Excel output -- Worksheet name in Excel output -- Conditional column titles -- Chapter 5 : Working with XML -- Introduction -- Changing drill targets quickly -- Copying and pasting drill links -- Removing references to old packages or items. A hidden gem in XML -- row level formatting -- Chapter 6 : Writing Printable Reports -- Introduction -- Controlling the container size and rows per page -- Eliminating orphan rows -- Defining page orientation and size (and overriding them for one page) -- Avoiding page title repetition -- Horizontal pagination -- Page numbering with horizontal pagination -- Choosing the output format from a prompt -- Choosing the right colors -- Defining page sets -- Cautions about HTML items and JavaScript files -- Displaying the report name in a footer -- Chapter 7 : Working with Dimensional Models -- Introduction -- List report or crosstab report -- Filtering rows or columns -- Filtering a whole report -- Adding a prompt into Slicer and its limitations -- Achieving zero suppression -- Aggregation versus preaggregated values -- The roleValue() function -- Swapping dimensions using MUN manipulation -- Chapter 8 : Working with Macros -- Introduction -- Adding data-level security using the CSVIdentityMap macro -- Using the Prompt macro in native SQL -- Making prompts optional -- Adding a token using macros -- Using the prompt() and promptmany() macros in query subjects -- Showing the prompt values in a report based on security -- String operations to get it right -- Showing a username in the footer -- Chapter 9 : Using Report Studio Efficiently -- Introduction -- Using Report Studio's environmental options -- Copying and pasting partial or full reports -- Upgrading report specifications -- Setting the execution timeout -- Setting the maximum row limit -- Handling slow report validation -- Capturing a query -- Browsing values from the data expression window -- Viewing the page structure -- Picking up and applying styles -- Using the "grab them all" practice -- Using Default Data Formats -- Chapter 10 : Working with Active Reports -- Introduction. Building tabbed reports -- Working with Decks -- Working with the Data Deck -- Filtering data using Data Check Box Group -- Chapter 11 : Charts and New Chart Features -- Introduction -- Chart formatting options -- Converting a chart to another chart type -- Working with pie charts -- Getting started with bullet charts -- Getting started with scatter charts -- Chapter 12 : More Useful Recipes -- Introduction -- Timing report execution -- Missing values versus zero values -- Overriding data formatting using patterns -- Setting up conditional drill-throughs -- Dynamically switching between reports using an iFrame -- Freezing column titles -- Chapter 13 : Best Practices -- Introduction -- Reducing the number of query items -- Highlighting hidden items -- Using relative paths for images -- Controlling JavaScript file execution -- Customizing classes for report-wide effect -- Creating templates -- Regression testing -- Commenting the code -- Naming data containers (lists, crosstabs, and charts) for use in Cognos Workspace -- Enabling a larger worksheet size for Excel 2007 -- Appendix: Recommendations and References -- Introduction -- Version controlling -- Recommendations for prompt types -- Cognos Mashup Service -- SDK and third-party tools for Cognos -- IBM Cognos Analysis For Excel (CAFE) -- IBM Cognos for Microsoft Office -- IBM Cognos Workspace -- IBM Cognos Workspace Advanced -- IBM Cognos Cloud -- Index. Business report writing Computer programs. Database management Computer programs. http://id.loc.gov/authorities/subjects/sh85035849 Database Management Systems https://id.nlm.nih.gov/mesh/D003628 Style commercial Logiciels. Bases de données Gestion Logiciels. BUSINESS & ECONOMICS Industrial Management. bisacsh BUSINESS & ECONOMICS Management. bisacsh BUSINESS & ECONOMICS Management Science. bisacsh BUSINESS & ECONOMICS Organizational Behavior. bisacsh Business report writing Computer programs fast Database management Computer programs fast |
subject_GND | http://id.loc.gov/authorities/subjects/sh85035849 https://id.nlm.nih.gov/mesh/D003628 |
title | IBM Cognos 10 report studio cookbook / |
title_auth | IBM Cognos 10 report studio cookbook / |
title_exact_search | IBM Cognos 10 report studio cookbook / |
title_full | IBM Cognos 10 report studio cookbook / Ahmed Lashin, Abhishek Sanghani. |
title_fullStr | IBM Cognos 10 report studio cookbook / Ahmed Lashin, Abhishek Sanghani. |
title_full_unstemmed | IBM Cognos 10 report studio cookbook / Ahmed Lashin, Abhishek Sanghani. |
title_short | IBM Cognos 10 report studio cookbook / |
title_sort | ibm cognos 10 report studio cookbook |
topic | Business report writing Computer programs. Database management Computer programs. http://id.loc.gov/authorities/subjects/sh85035849 Database Management Systems https://id.nlm.nih.gov/mesh/D003628 Style commercial Logiciels. Bases de données Gestion Logiciels. BUSINESS & ECONOMICS Industrial Management. bisacsh BUSINESS & ECONOMICS Management. bisacsh BUSINESS & ECONOMICS Management Science. bisacsh BUSINESS & ECONOMICS Organizational Behavior. bisacsh Business report writing Computer programs fast Database management Computer programs fast |
topic_facet | Business report writing Computer programs. Database management Computer programs. Database Management Systems Style commercial Logiciels. Bases de données Gestion Logiciels. BUSINESS & ECONOMICS Industrial Management. BUSINESS & ECONOMICS Management. BUSINESS & ECONOMICS Management Science. BUSINESS & ECONOMICS Organizational Behavior. Business report writing Computer programs Database management Computer programs |
url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=637272 |
work_keys_str_mv | AT lashinahmed ibmcognos10reportstudiocookbook AT sanghaniabhishek ibmcognos10reportstudiocookbook |