Blog

What's happening? What's new? What can I do? Find answers to these questions in the blog.

Archive Results

Blog

New Base Samples for IBM #Cognos Analytics 11.0.12

There are two types of samples that have been created exclusively for IBM Cognos Analytics. The Extended Samples require the use of a database and database connections to host the sample Great Outdoors data. They must be installed and configured. Here are the instructions for installing the Extended samples. We have also created a set of Base Samples in a deployment that can be easily imported in one step. These samples exclusively use Data Modules as their underlying data sources (no cubes, databases, or packages). Here is a video that explains how to find and import the Samples_for_Install_11_0_12.zip deployment file. After you import the deployment, you will see the following new Base Samples: Team content > Samples > Dashboards Storm events This sample dashboard showcases the new custom polygon mapping functionality in the context of storm event data. You can read the full details in this Blog post. Related posts: Mapbox hosted custom polygons in reports and dashboards IBM Knowledge Center: Setting up Mapbox to work with IBM Cognos Analytics IBM Knowledge Center: Using custom point or region information from Mapbox in a map vizualization in a dashboard IBM Knowledge Center: Using custom point or region information from Mapbox in a map visualization in a report Samples landing page Guide to IBM Cognos Analytics sample data sets Library of How-To Videos for IBM Cognos Analytics Please visit our IBM Business Analytics Support channel on YouTube.

Blog

IBM #Cognos Analytics 11 JavaScript: What is the difference between a Custom Control and a Page Module?

A scriptable interface is available in IBM Cognos Analytics 11 for many objects in the report output. Reports can be scripted using two types of RequireJS AMD modules: A module that implements the CustomControl Module Interface A module that implements the Page Module Interface When to use a Custom Control To provide your own user interface for: a prompt-like control that reads and sets parameters page navigation buttons (Next, Finish, etc.) authored data such as a list or visualization When to use a Page Module To set the initial state of prompt controls To set prompt control custom validation functions To read current selections from a prompt control (possibly to store) before going to the next page Code (using HTML Item) from a previous release that was executed globally on the page will likely move into the "load" method When to use an HTML Item To insert static HTML into the output To insert static CSS into the output For more information, please view the online documentation. Custom Control Example In the sample named App Bar, we demonstrate how to use a Custom Control: Page Module Example In the sample named Validate Type-In Product Line Code, we demonstrate how to use a Page Module: The instructions for installing and configuring the JavaScript samples can be found at the bottom of this Blog post. Related posts: Scriptable Reports JavaScript Online Documentation Video: Cognos 10 JavaScript Prompt API samples in IBM Cognos Analytics 11 Blog: Cognos 10 JavaScript Prompt API samples in IBM Cognos Analytics 11 JavaScript support in the Interactive Viewer Video: Overview: Scriptable reports (11.0.4+) How to use a custom control with JavaScript to hide and show a filter panel in IBM #Cognos Analytics 11.0.7+ IBM Knowledge Center: Prompt API for IBM Cognos BI IBM Knowledge Center: Adding JavaScript to a report Library of How-To Videos for IBM Cognos Analytics Samples Landing Page Guide to IBM Cognos Analytics sample data sets Please visit our IBM Cognos Analytics channel on YouTube.

Blog

New Base Samples for IBM #Cognos Analytics 11.0.11

There are two types of samples that have been created exclusively for IBM Cognos Analytics. The Extended Samples require the use of a database and database connections to host the sample Great Outdoors data. They must be installed and configured. Here are the instructions for installing the Extended samples. We have also created a set of Base Samples in a deployment that can be easily imported in one step. These samples exclusively use Data Modules as their underlying data sources (no cubes, databases, or packages). Here is a video that explains how to find and import the Samples_for_Install_11_0_11.zip deployment file. After you import the deployment, you will see the following new Base Samples: Team content > Samples > Reports Storm events 2015 This sample report showcases the new custom polygon and point mapping functionality in the context of storm event data. You can read the full details in this Blog post Team content > Samples > Data Sample data module This sample data has been updated to include a new column for Product Number. SampleFile_GOSales.xls This sample data has been updated to include a new column for Product Number. Storm events 2015 This sample data module has been updated to include a new calculated column for Region (Northeast, Midwest, South, and West). JavaScript Samples The existing IBM Cognos Business Intelligence 10 JavaScript Prompt API samples have been migrated to IBM Cognos Analytics 11. You can read the full details in this Blog post. All of the JavaScript samples now use data modules as their data source, rather than the Sample Outdoors Company database. Related posts: Mapbox hosted custom polygons in reports and dashboards Cognos 10 JavaScript Prompt API samples in IBM Cognos Analytics 11 IBM Knowledge Center: Setting up Mapbox to work with IBM Cognos Analytics IBM Knowledge Center: Using custom point or region information from Mapbox in a map vizualization in a dashboard IBM Knowledge Center: Using custom point or region information from Mapbox in a map visualization in a report Samples landing page Guide to IBM Cognos Analytics sample data sets Library of How-To Videos for IBM Cognos Analytics Please visit our IBM Business Analytics Support channel on YouTube.

Blog

Cognos 10 JavaScript Prompt API samples in IBM #Cognos Analytics 11

In Cognos Business Intelligence 10.2.2, the JavaScript Prompt API provided report authors with a method of customizing prompt interactions in the reports they authored. Fifteen samples were created to demonstrate how to use the Prompt API. After you install the Extended Samples, you will find the Prompt API samples in the Samples_Prompt_API folder. In Cognos Analytics 11.0.4, embedded JavaScript support changed and improved. Consequently, the 10.2.2 Prompt API samples have been re-written for 11.0.11, using this new approach. What has changed? Cognos Business Intelligence 10.2.2 used HTML Items, JavaScript, and the Prompt API. The report is rendered in the Classic Viewer only. IBM Cognos Analytics 11.0.4+ uses Custom Controls (instead of HTML items) and JavaScript modules. The report is rendered in the Interactive Viewer. Here is a list of the original Prompt API samples that have been updated in 11.0.11: Clear prompt selections Date prompt presets Display all prompt values ignoring user selections Display user selected prompt values Filter country by letter (now called HTML select and HTML slider) Limit numeric prompt selection by database value Limit time between two dates Limit user selection to two items Personal default prompt selections - set selections Personal default prompt selections - use selections Validate prompt values when button pushed Validate type-in postal code values Validate type-in product line code Coming soon: Date time prompt presets Limit date prompt selection by database value Deprecated: Pass parameter via hidden prompt Note: You can also successfully open and use all the version 10.2.2 samples in their original form in Cognos Analytics 11. They will be rendered in the Classic Viewer only. How to install the 11.0.11 JavaScript Samples The setup instructions and JavaScript sample files are installed (but not configured or imported) with the product in an Easy installation, and if the Samples option is selected in a Custom installation. After product installation, you can find the files here: <Cognos Analytics installation location>\samples\JavaScript\ Please open the file JavaScript_setup_instructions.pdf and follow the steps. All the JavaScript samples now use a data module as their data source, making them much easier to import. Related posts: Scriptable Reports JavaScript Documentation Video: Cognos 10 JavaScript Prompt API samples in IBM Cognos Analytics 11 JavaScript support in the Interactive Viewer Video: Overview: Scriptable reports (11.0.4+) How to use a custom control with JavaScript to hide and show a filter panel in IBM #Cognos Analytics 11.0.7+ IBM Knowledge Center: Prompt API for IBM Cognos BI IBM Knowledge Center: Adding JavaScript to a report Library of How-To Videos for IBM Cognos Analytics Samples Landing Page Please visit our IBM Cognos Analytics channel on YouTube.

Blog

Video: How to share the URL to a specific content object (11.0.5+)

Welcome to our video about how to share the URL to a specific content object in IBM Cognos Analytics 11.0.5 and up, where we'll cover how to share a content object, provide an example with hyperlinks, and discuss relative paths and gateways. Related posts: Library of How-To Videos for IBM Cognos Analytics Samples Landing Page Guide to IBM Cognos Analytics sample data sets Please visit our IBM Cognos Analytics channel on YouTube.

Blog

Video: What's new in reporting, dashboarding, stories and the portal for IBM #Cognos Analytics 11.0.11?

Welcome to our video about what's new in reporting, dashboarding, stories and the portal for IBM Cognos Analytics 11.0.11, where we'll cover using custom polygons and points for mapping, data caching in dashboards and stories, support for Portal Pages, and controlling object visibility. Related posts: Library of How-To Videos for IBM Cognos Analytics Samples Landing Page Guide to IBM Cognos Analytics sample data sets Please visit our IBM Cognos Analytics channel on YouTube.

Blog

New Base Samples for IBM #Cognos Analytics 11.0.10

There are two types of samples that have been created exclusively for IBM Cognos Analytics. The Extended Samples require the use of a database and database connections to host the sample Great Outdoors data. They must be installed and configured. Here are the instructions for installing the Extended samples. We have also created a set of Base Samples in a deployment that can be easily imported in one step. These samples exclusively use Data Modules as their underlying data sources (no cubes, databases, or packages). Here is a video that explains how to find and import the Samples_for_Install_11_0_10.zip deployment file. After you import the deployment, you will see the following new Base Samples: Team content > Samples > Dashboards California website visits This sample showcases the new latitude/longitude mapping functionality in dashboarding. Multiple maps use regions, points, and latitude/longitude to display California website visits data for the fictional Samples Outdoors Company website. Policy analysis This sample dashboard has been updated to include a drill-through definition to the "Customer lifetime value analysis" report. Team content > Samples > Data NYPD motor vehicle collisions This sample data provides a breakdown of every collision in NYC from 2015 to 2017 by location and injury. Each record represents a collision in NYC by city, borough, precinct and cross street. Source: Police Department (NYPD), NYC OpenData Sales staff This sample data contains sales staff information for the fictional Sample Outdoors Company. Source: IBM. Note: This uploaded file is now included in the Sample data module. Audit Samples We have added one new sample audit report in 11.0.10: Deleted user account report This sample audit report lists user accounts that have been deleted during a specified time period. It provides information about the deleted user ID, the time deleted, the account type, and the status of the request. To learn more about the audit samples and how to install them, please visit this Blog post. JavaScript Samples All of the JavaScript samples now use data modules as their data source, rather than the Sample Outdoors Company database. Please visit this Blog post for more details. Related posts: New Audit samples for IBM #Cognos Analytics 11.0.7+ Updated JavaScript samples for IBM #Cognos Analytics 11.0.10 Samples landing page Supplementary (Legacy) IBM Cognos Analytics 11 samples Guide to IBM Cognos Analytics sample data sets Please visit our IBM Business Analytics Support channel on YouTube.

Blog

Updated JavaScript samples for IBM #Cognos Analytics 11.0.10

The JavaScript samples have been updated to use data modules rather than the Sample Outdoors Company database, making them easier for you to set up. You no longer need to install the full Extended Samples in order to use the JavaScript samples. The setup instructions and JavaScript sample files are installed (but not configured or imported) with the product in an Easy installation, and if the Samples option is selected in a Custom installation. After product installation, you can find them here: <Cognos Analytics installation location>\samples\JavaScript\ List of JavaScript Samples App bar: This sample report uses JavaScript to create an application bar to switch between a list, charts, and a crosstab. App bar data: This sample report uses JavaScript to create a data-driven application bar. App bar static labels: This sample report uses JavaScript to create an application bar with static labels. Basic control: This sample shows how to include a basic JavaScript control. Bootstrap button bar: This sample report uses JavaScript to create a bootstrap button bar to switch between order methods. Bootstrap tabs: This sample report uses JavaScript to create both data-driven tabs and static tabs. Collapse regions: This sample report uses JavaScript to show or hide prompts. D3 bar chart: This sample report uses JavaScript to generate a D3 bar chart. Data store viewer: This sample report uses JavaScript to access the data store and display rows of data. Displayable regions: This sample report uses JavaScript to show or hide the prompts, and to show or hide individual prompts within that region. Events: This sample shows how to use JavaScript to respond to events. Full screen: This sample report uses JavaScript to show a pie chart, a list, or a crosstab in full screen mode. Google bar chart: This sample report uses JavaScript to generate a Google bar chart. Google organization chart: This sample report uses JavaScript to generate a Google organization chart. HTML select: This sample report uses JavaScript to create an HTML drop-down list. HTML slider: This sample report uses JavaScript to create an HTML slider to set a minimum value. List column display: This sample report uses JavaScript to allow the user to select which list columns to display. Loading text: This sample demonstrates loading text with JavaScript. Page module: This example shows how to author a page module and access a control in the page module. (This is the base template for a page module.) Prompt API buttons: This sample report uses JavaScript to show the results of various method calls. Prompt validation: This sample demonstrates using JavaScript to validate the content of prompt values entered by the user. Save csv: This sample report uses JavaScript to allow the user to render a report as a CSV file. Related posts: IBM Knowledge Center: Adding JavaScript to a report Technote: Adding JavaScript to reports JavaScript support in the Interactive Viewer Video: Overview: Scriptable reports (11.0.4+) How to use a custom control with JavaScript to hide and show a filter panel in IBM #Cognos Analytics 11.0.7+ Samples landing page Guide to IBM Cognos Analytics sample data sets Please visit our IBM Business Analytics Support channel on YouTube.

Blog

New Base Samples for IBM #Cognos Analytics 11.0.8

There are two types of samples that have been created exclusively for IBM Cognos Analytics. The Extended Samples require the use of a database and database connections to host the sample Great Outdoors data. They must be installed and configured. Here are the instructions for installing the Extended samples. We have also created a set of Base Samples in a deployment that can be easily imported in one step. These samples exclusively use Data Modules as their underlying data sources (no cubes, databases, or packages). Here is a video that explains how to find and import the Samples_for_Install_11_0_8.zip deployment file. After you import the deployment, you will see the following new Base Samples: Team content > Samples Version 11.0.8 base samples This new report is a table of contents for the base samples. It lists all the available samples in sections (dashboards, stories and reports) and provides a direct link to each sample. It identifies the core features that the sample is intended to demonstrate, and provides a description. Team content > Samples > Reports Corporate website visits We added a map that is generated from latitude and longitude coordinates. This sample report demonstrates the new client-side mapping functionality in reporting. Three maps display 2016 website visit data for the fictional Sample Outdoors Company website by Zip Code and Latitude/longitude in California. Team content > Samples > Stories Animated path scene transition This sample Story demonstrates the new animated paths feature for scene transitions, and timeline highlights. Like many other cities, Boston, MA logs hundreds of thousands of requests each year for services such as snow plowing, street cleaning, and pot hole repair. Source: City of Boston. Team content > Samples > Data California website visits We added data columns for Latitude and Longitude for use with the client-side mapping functionality in reporting. This sample data module contains 2016 website visit data for the fictional Sample Outdoors Company website by Zip Code and city in California. Source: IBM Note: Latitude and longitude must be in separate columns of decimal degrees coordinates, with latitude in the range of -90 to 90, and longitude in the range of -180 to 180. Extension Samples There are two new sample Extensions for IBM Cognos Analytics 11.0.8. These sample files are installed with the product in an Easy Installation, and are an option in a Custom Installation. After product installation, you can find them here: <cognos_analytics_installation_location>/samples/extensions/ SampleExtensionCustomMediaAll.zip This sample extension will add eight custom images to the Image Library tab in the Widgets panel in Dashboarding and Stories. It will also add the eight custom images to the Image Picker dialog in Reporting in the Image Gallery. Only JPG and PNG files are supported at this time. SampleExtensionMenuUrlLinks.zip This sample extension demonstrates how to add a menu to the AppBar that contains two menu items that open external URLs. The URLs are opened in a separate browser tab. Please note: Themes and Extensions are an incremental feature that changes with each product release. The samples included with each release have been verified with that release only, and may not support backward or forward compatibility. Related posts: Samples landing page Supplementary (Legacy) IBM Cognos Analytics 11 samples Guide to IBM Cognos Analytics sample data sets New Base Samples for IBM Cognos Analytics 11.0.7 Please visit our IBM Business Analytics Support channel on YouTube.

Blog

How to use a custom control with JavaScript to hide and show a filter panel in IBM #Cognos Analytics 11.0.7+

Filters (prompts) tend to take up a lot of valuable space on a report. It is often useful to provide users with the ability to hide and show these filters in a panel. There is a new sample in IBM Cognos Analytics 11.0.7 titled Global sales that demonstrates how to use a Block, a Custom Control, and JavaScript to hide and show a panel of filters (Year and Product Line) at the top of the report: Here is a document that explains step-by-step how we created the sample report. Samples There is a set of samples for Scriptable Reports. These sample files are installed (but not configured or imported) with the product in an Easy installation, and are an option in a Custom installation. You can find them here: <Cognos installation directory>\samples\JavaScript\ For your convenience, you can also obtain the samples here. Download the following three files: 1. Follow these setup instructions. If you are using a Gateway, please read Step 6 carefully! 2. Unzip and place these javascript files. 3. Import this report deployment. Related posts: JavaScript support in Interactive Viewer Video: Overview: Scriptable reports (11.0.4+) New Base Samples for IBM Cognos Analytics 11.0.7 Please visit our IBM Business Analytics Support channel on YouTube.