Filter by products, topics, and types of content

(28 Products)

(149 Topics)

(16 Industries)

(6 Types)

1 - 72 of 72 results
Show Summaries | Hide Summaries
View Results
Title up Type none Date none
Advanced Multidimensional Reporting with IBM Cognos 8 BI
Advanced report authors will learn techniques to reduce large sets of data into smaller, more readable reports, as well as advanced filtering techniques that will render more useful data.
Articles 01 Jan 2009
Advanced Prompting and Prompt Performance Tuning
This document shows report authors how to deal with prompt page performance issues. This material was presented at the 2007 User Forum as presentation 1562.
Articles 01 Jan 2009
Advanced Prompting with Supporting Files
This document discusses the changes to Prompting in IBM Cognos 8.4 as well as custom prompt controls.
Articles 01 Jan 2009
Auto-Size Select and Search Prompt within IBM Cognos 8 Report Studio
This document details an optional switch which may be used to make the display areas dynamically re-size to meet the demands of the wider data.
Articles 02 Mar 2010
Creating Mailing Lables in IBM Cognos 8 Report Studio
This document will outline how to create mailing labels in IBM Cognos 8 Report Studio.
Articles 03 Nov 2009
Displaying Dates in Crosstabs within IBM Cognos 8 Report Studio
This document describes a technique that can be used to display dates as the measure values in a crosstab.
Articles 03 Mar 2010
Drill Up/Down
How Member Sets and Advanced Drill behaviours can be leveraged within Report Studio. Descriptions and examples of the advanced drill behaviours are provided.
Articles 01 Jan 2009
Dynamic Dashboarding
This document will demonstrate how to create a dashboard style report so that when a user drills down on a Query Subject in one chart, the other charts in the report are filtered by that context.
Articles 01 Jan 2009
Dynamic Reporting with Tokens and Member Unique Names
How to use token and member unique name prompts to extend the prompting capabilities of a report to reference metadata rather than the normal prompting behavior of supplying data values only.
Articles 01 Jan 2009
Ensure Non-Null Values for Calculations in IBM Cognos 8 Report Studio
This document will illustrate some techniques that can be used to handle null values in calculations for various situations and with various data source types.
Articles 18 Dec 2009
Formatting Report Parameters using layout Calculations
This document was created in response to a customer enhancement request for the ability to format parameter values displayed as Layout Calculations.
Articles 01 Jan 2009
Hide In-Body Prompts
Using Javascript to collapse or expand an HTML div block to hide or show a set of prompts within rendered HTML output.
Articles 01 Jan 2009
Hiding Headers and Toolbars for Individual Reports in IBM Cognos 8 BI version 8.2
This document provides step by step instructions on how to hide elements of the Header by overriding the default CSS properties using report level an HTML item.
Articles 01 Jan 2009
How to Create Sparkline Charts
This document demonstrates how a user can create a report displaying Sparklines using a line chart.
Articles 01 Jan 2009
IBM Business Analytics Proven Practices: Auto Cascading Multi and Single Value Prompts without Page Refresh in IBM Cognos 10 Report Studio
This document provides a technique to auto-cascade single or multi select value prompts without refreshing the page, or re-running the prompt queries.
Also available in: Chinese   Russian  
Articles 26 Mar 2015
IBM Business Analytics Proven Practices: IBM Cognos Active Report 10.2 Cookbook
A description of the various features available within IBM Cognos Active Report and how they can be used to create and distribute interactive reporting applications.
Also available in: Chinese   Russian  
Articles 23 Jul 2015
IBM Business Analytics Proven Practices: Implementing an Interactive Map Widget in IBM Cognos Workspace
This document provides the steps required to implement an Interactive Map Widget for use with IBM Cognos Workspace 10.2.1 and 10.2.2.
Also available in: Russian  
Articles 12 Feb 2015
IBM Business Analytics Proven Practices: Setting Dynamic Date Prompt Values within IBM Cognos 10.2 Report Studio
This document describes a technique to set dynamic default values for date prompts using a combination of prompt macros and JavaScript.
Articles 14 Nov 2012
IBM Business Analytics Proven Practices: Dynamic reporting in Cognos using jQuery
This document shows how an author can leverage the jquery libraries to enhance IBM Cognos report design.
Also available in: Portuguese  
Articles 27 Mar 2013
IBM Business Analytics Proven Practices: Hide and Show Fields without SQL Projection within IBM Cognos 10 Report Studio
A technique which hides columns based on prompt values. Using this approach, the hidden columns are not projected in the underlying database query.
Also available in: Russian  
Articles 02 May 2014
IBM Business Analytics Proven Practices: IBM Cognos BI Report Studio - Measure Based Value Prompt
Create a value prompt on a measure data item in an IBM Cognos BI Report Studio report using a relational package and prevent the aggregation of those values in the prompt selection, using the steps described in this article.
Also available in: Russian  
Articles 15 May 2014
IBM Business Analytics Proven Practices: Portrait Aware Mobile Reports Using IBM Cognos Active Report
You can optimize your reports to run in either landscape or portrait orientation on a supported mobile device. Use these tips to ensure that your reports appear as intended.
Also available in: Russian   Spanish  
Articles 05 Mar 2014
IBM Business Analytics Proven Practices: Steps to Design a Histogram in IBM Cognos Report Studio
A description of the design and development of a histogram chart, which is a statistical process control chart. Report authors can use the steps in this article as a template for designing their customized histogram.
Also available in: Russian  
Articles 13 May 2014
IBM Business Analytics Proven Practices: Using a Template within IBM Cognos 10 Query Studio
This document provides the step by step instructions on how to create an IBM Cognos Report Studio template and apply it as a default template within IBM Cognos 10.2 Query Studio.
Articles 16 Nov 2012
IBM Business Analytics Proven Practices: Using OpenStreetMap In IBM Cognos BI Reports
Using OpenStreetMap in IBM Cognos BI reports as an alternative to built-in mapping, Google Maps or Bing Maps.
Also available in: Russian  
Articles 25 Feb 2014
IBM Cognos 8 BI - Multiple Aligned Column Headers in Lists and Crosstabs
This document will show step-by-step how to create list and crosstab reports in Report Studio that contain multiple aligned header rows to ‘group’ column information together and display additional information about the items displayed in the report.
Articles 01 Jan 2009
IBM Cognos BI - Hide and Show Fields Based on Prompt Values
This document aims to clarify the properties, functionality, and techniques available to report authors to conditionally hide or display items on a report.
Articles 01 Jan 2009
IBM Cognos BI Dimensional Functions
A list of the available dimensional functions in Cognos BI with supporting example usage and output.
Articles 25 Feb 2011
IBM Cognos Proven Practices: Auto Cascading Prompts without Page Refresh in IBM Cognos Report Studio
This document provides technique to implement auto-cascading of Value prompts without having to do a page refresh.
Also available in: Chinese  
Articles 10 Dec 2012
IBM Cognos Proven Practices: Conditional Business Reporting Based on Relative and Absolute Dates within IBM Cognos Report Studio
An approach to presenting a ‘relative date’ to a report consumer within a prompt or set of prompts. Many organizations might need relative date activity such as the activity in the last 7 days, Month to date, Year to Date.
Also available in: Chinese  
Articles 28 Jan 2011
IBM Cognos Proven Practices: Dynamic Selection of Columns in IBM Report Studio
How to build a Report Studio report that allows the user to select from a prompt which columns to include in the report.
Articles 17 Jun 2011
IBM Cognos Proven Practices: Dynamic Sort on a Numerical Column in IBM Cognos 8
This document describes an approach that can be used to dynamically sort on a Numerical Column.
Also available in: Chinese   Spanish  
Articles 29 Jun 2010
IBM Cognos Proven Practices: Dynamic Sorting of a List within IBM Cognos Report Studio
A technique which applies dynamic column sorting on a list using custom IBM Cognos Report Studio toolbox items.
Also available in: Chinese   Russian  
Articles 19 Jul 2013
IBM Cognos Proven Practices: Fit PDF Report Output to Page in IBM Cognos BI Report Studio
This short guide demonstrates an easy method of making a report PDF output fit to page, both vertically and horizontally, without impacting the HTML view.
Also available in: Chinese  
Articles 25 Aug 2011
IBM Cognos Proven Practices: IBM Cognos 8 BI – Query Across Dimensional Data Sources
A technique in which two dimensional sources can be compared to one another using a union and conditional formatting.
Also available in: Chinese   Spanish  
Articles 20 May 2010
IBM Cognos Proven Practices: IBM Cognos BI - Create Side-by-Side Chart Comparisons with IBM Cognos Active Report
A brief video illustrating how to create two side-by-side charts that allow you to compare data from various cities in an IBM Cognos Active Report.
Also available in: Chinese  
Articles 03 Nov 2011
IBM Cognos Proven Practices: IBM Cognos BI - Global Filters for a Multi-Page Dashboard
This document will illustrate how to implement global filters that filter reports in a Multi-page portlet in an IBM Cognos portal page.
Also available in: Chinese  
Articles 09 Nov 2010
IBM Cognos Proven Practices: IBM Cognos BI - Restrict Tree Prompt Selection with JavaScript
A technique for report developers that wish to utilize a Tree Prompt but require that the value submitted be restricted to a designated level within a hierarchy.
Also available in: Chinese  
Articles 22 Dec 2010
IBM Cognos Proven Practices: IBM Cognos BI - Unexpected Results When Performing Multi-Fact Queries (Stitch Queries)
This document discusses a number of issues that advanced report authors may encounter when they create reports that generate a stitch query (queries that include facts from multiple fact tables).
Articles 07 Mar 2012
IBM Cognos Proven Practices: IBM Cognos BI - Working with Tab Controls in IBM Cognos Active Report
A brief video illustrating how to use tab controls in an IBM Cognos Active Report.
Also available in: Chinese  
Articles 03 Nov 2011
IBM Cognos Proven Practices: IBM Cognos BI – Active Report Tree Control
A brief video illustrating how to create a tree control using IBM Cognos Active Report.
Articles 09 Nov 2011
IBM Cognos Proven Practices: IBM Cognos BI – Auto Submit a Tree Prompt Using JavaScript
A brief video illustrating how to automatically submit a single select tree prompt selection using JavaScript.
Articles 22 Jun 2011
IBM Cognos Proven Practices: IBM Cognos BI – Define Independent Drill-Through Definitions for Crosstab Fact Cells
This document will illustrate how to implement independent drill-through definitions for different measures in crosstab fact cells.
Articles 12 May 2011
IBM Cognos Proven Practices: IBM Cognos BI – Dynamically Change Columns in a Report with One Prompt Selection
A brief video illustrating how to dynamically change multiple columns in a report based on one prompt selection.
Articles 17 May 2011
IBM Cognos Proven Practices: IBM Cognos BI – Use the Member Function or a Calculated Measure to Enhance a Dimensional Report
A brief video illustrating how to use the Member function or a Calculated Measure to ensure the output of a calculation returns a member which can be referenced in another dimensional function.
Articles 24 Jun 2011
IBM Cognos Proven Practices: IBM Cognos BI – Using Dimensional Functions to Determine Current Period
A technique using dimensional functions to determine the current period for a multidimensional data source, OLAP or Dimensionally Modeled Relational (DMR), where the current period has not been defined in the data source itself.
Articles 02 May 2011
IBM Cognos Proven Practices: Improving IBM Cognos Report Studio Master Detail Report Performance
This document describes an IBM Cognos Report Studio report design technique that can be used for master-detail style reports running against a relational data source.
Also available in: Chinese   Spanish  
Articles 03 Aug 2011
IBM Cognos Proven Practices: Mimicking IBM Cognos Series 7 Drill-Through in IBM Cognos BI
This document is to assist customers to migrate IBM Cognos PowerPlay Cube to relational drill through reports from IBM Cognos 7.4 to IBM Cognos BI.
Articles 30 May 2011
IBM Cognos Proven Practices: Performance Tips when using Cross JoinQueries against a TM1 Datasource
The purpose of this document is to provide performance guidance when querying large datasets from a TM1 Datasource.
Also available in: Chinese   Spanish  
Articles 19 Nov 2012
IBM Cognos Proven Practices: Using Active Report Variables in Cognos 10
A demonstration of enabling the ability to view variables for Active Reports and monitor their behavior in a working report.
Also available in: Chinese   Spanish  
Articles 11 Jan 2011
IBM Cognos Proven Practices: Using JavaScript to Pass Multiple Values to a Textbox Prompt within IBM Cognos 8 Report Studio
This technique uses JavaScript to allow a user to pass multiple values provided to an IBM Cognos 8 Report Studio textbox prompt.
Also available in: Chinese   Spanish  
Articles 11 Aug 2010
IBM Cognos Proven Practices: Using Relative Time Categories within Report Studio Prompts
This guide demonstrates a method of using transformer's relative time categories within Report Studio Prompts. The guide shows how to create prompts that default to a relative time category value whilst also allowing the user to use any other time category. The methods shown do not require any Javascript.
Also available in: Chinese  
Articles 30 Aug 2011
IBM Cognos Proven Practices: Using the periodsToDate function within IBM Cognos 10 Report Studio to Calculate an OLAP Running-Total
A description of how the dimensional function periodsToDate can be used outside of a time dimension to calculate a running total against on online analytical processing (OLAP) data source.
Also available in: Russian  
Articles 24 May 2012
Image Indicators in a Crosstab
How to unlock the contents of your crosstab fact cells to include an image. The image is conditionally displayed based on the data included in the crosstab and can be used as a metric indicator for the measure values.
Articles 01 Jan 2009
In_Range Filters and Character Fields within IBM Cognos 8 Report Studio
This document details an optional setting which may be used to have a report return data within a range regardless if the From value is greater than the To.
Articles 02 Mar 2010
Notes on Report Bursting in Cognos 8.3
Details on using one or more queries to burst list and crosstab reports. The additional queries can be used to separate the data for the burst groups, recipients, and report data. A new feature to IBM Cognos 8.3 for multiple recipients is also described.
Articles 01 Jan 2009
Passing Use and Display Values on a URL
This document focuses on passing 'Display values' as the primary value, and also includes details on how to pass complex parameters such as ranges.
Articles 18 Aug 2009
Pasting Values into Report Prompts
A multi-line text box prompt can allow users to paste in multiple values from their clipboard. When the values are separated by line feeds or carriage returns then they will be considered to be individual values when passed to the query.
Articles 01 Jan 2009
Performing Tasks using Parameterized URLs in IBM Cognos 8
How to launch all Cognos components (Cognos Connection and all studios) and objects (reports, folders, pages) from URLs. Useful for embedding content into other applications and providing drill-through between studios and other applications.
Articles 01 Jan 2009
Prompts and Parameterized SQL
Using a "token" prompt macro to give users the ability to select the filter expression to use at run-time. This extends the existing prompting capabilities by allowing the query to be defined dynamically. This method can be extended to other expressions.
Articles 01 Jan 2009
Repeat Crosstab Labels in CSV
Details on how to modify the Report Service and Batch Report Service to change the generation of CSV output files to include an instance of the row or column labels for each column rather than one label per set of child rows or child columns.
Articles 01 Jan 2009
Report Studio Freeze Panes with Scripting
A client-side JavaScript technique to "freeze" the columns of a list or the rows and columns of a crosstab when scrolling frames with extensive content.
Articles 01 Jan 2009
Report Studio Workshop - Maps
An outline of Map properties such as Points, Regions, Layers, Titles, Custom Palettes, Data Dictionary, Translations, Map Manager, and Drill through.
Articles 01 Jan 2009
Report Studio Workshop - Shared Layout Components
An overview of the shared layout components that can be shared both within a single report and between multiple reports. The Layout Cache is also described and how it allows for automatic or manual updates of shared objects.
Articles 01 Jan 2009
Report Studio: Dynamically Filtering Data Based on the Column Selected
This technique describes how to create a report that allows users to dynamically filter a report based on a field selection.
Articles 01 Jan 2009
Scenario2 - Native vs Cognos SQL
This document outlines how to optimize a specific report by evaluating the difference between the Native and Cognos SQL generated by a specific query.
Articles 01 Jan 2009
Tree Prompts
This document describes how you can build a dimension and use it to create a tree prompt to filter against a relational datasource. The zip file contains the document, model, report specification and an export of the MS SQL Server2005 datasource.
Articles 01 Jan 2009
Using a Crosstab to Produce Gantt Charts
This document outlines how to create Gantt charts, useful in displaying project timelines, as formatted crosstabs for IBM Cognos 8 and IBM Cognos ReportNet. Discussion is limited to the IBM Cognos 8 implementation of this technique.
Articles 01 Jan 2009
Using Multi-Page Report View in IBM Cognos 8 BI
This document will show the best way to create a multi-tab report veiw in the IBM Cognos 8 Portal.
Articles 08 Mar 2010
Using the AT and FOR Options with Relational Summary Functions
How to use the AT and FOR to control the aggregate behavior of relational summary functions. These allow the scope/grouping (regular aggregates) and the level of pre-aggregation to be set (running aggregates). A crosstab running-total example is supplied.
Articles 01 Jan 2009
Using the script option to rename PDF files to the Burst Key value
Burst output can be directed to a file system rather than being stored within the Content Store. This process produces uniquely named output files created with a generated key. A script can be used to rename these files according to the burst key value.
Articles 19 Oct 2011
Writing Efficient OLAP Queries
Discussion on some of the common pitfalls that result in poorly performing reports. These are resolved using more appropriate filter expressions and by reducing the potential size of intermediate result sets through the use of filter functions.
Articles 01 Jan 2009
1 - 72 of 72 results
Show Summaries | Hide Summaries