Blog

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

Archive Results

Blog

VIDEO: Dashboarding Demo for Cognos Analytics

Welcome to our video that demonstrates the new dashboarding capabilities in Cognos Analytics.  In this video, we will walk you a use case story on how to upload a data file and build out a dashboard while gaining insights along the way. Related posts: An Overview of Cognos Analytics Data Prep and Modeling Please visit our IBM Cognos Analytics channel on YouTube.

Blog

VIDEO: Data Preparation and Modeling

Welcome to our video that demonstrates data preparation and modeling in Cognos Analytics.  In this video, we will walk you through a use case story that details how to join multiple data sources using corporate and external data, refine data properties, and build navigation groups and custom groups. Related posts: An Overview of Cognos Analytics Data to Dashboard in Minutes (Coming Soon) Please visit our IBM Cognos Analytics channel on YouTube.

Blog

VIDEO: An Overview of Cognos Analytics

Welcome to our video that showcases the capabilities of Cognos Analytics.  In this video, we will introduce you to the newly re-imagined Cognos Analytics, and illustrate the improved user interface for each feature function. Related posts: Data Preparation and Modeling Data to Dashboard in Minutes (Coming Soon) Please visit our IBM Cognos Analytics 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

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: Cognos 10 JavaScript Prompt API samples in IBM #Cognos Analytics 11

Welcome to our video about how the Cognos 10 JavaScript Prompt API samples have evolved in the IBM Cognos Analytics 11 environment. In this video we will show the 10.2.2 Prompt API samples, the equivalent 11.0.11 samples, and demonstrate what has changed. Related posts: Cognos 10 JavaScript Prompt API samples in IBM Cognos Analytics 11 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: 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

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

#Cognos Analytics 11.0.8: Adding Latitude/Longitude Maps in Reports

Cognos Analytics Release 8 adds support for Latitude/Longitude based maps in reports allowing geocoded data to be displayed on the maps shown in reports as seen below: In our example, businesses in Hawaii are shown as points located by latitude and longitude with revenue driving the size, and Profit driving the color of the points. As with the Regions and Points layers, the Latitude/Longitude layer is available on the layer selector:   The Latitude/Longitude layer requires two data numeric data items for the latitude and longitude: The label field is used to provide a meaningful tooltip for the points. That’s because, generally speaking users will know the name of the store “ABC Retail,” but not necessarily the latitude and longitude of the store. For this reason, the label, but not the latitude/longitude location is displayed in the tooltip:   Much like the Points layer, Size and Color require a measure data item to style the circular points displayed at each unique latitude/longitude location. Of course, you can define all three layer types, or any combination thereof, at the same time. In fact, in our example, there is a region layer on “State,” which resulted in the green color used to style Hawaii. Latitude/Longitude Encoding While there are several ways to store latitude/longitude , Cognos Analytics requires using a WGS 84 / World Geodetic System (WGS) encoding stored as numeric data items. WGS 84 simply means latitudes between -90 and +90 degrees, and longitudes between -180 and +180 degrees suitable for use on a Web Mercator map. An example would be the White House in Washington DC located at latitude 38.897957, and longitude -77.036560. Other formats such as degrees, minutes, second and decimal seconds for example 38° 53' 52.6452'' N, 77° 2' 11.6160'' W are not supported, nor are other X, Y coordinates systems. In such cases, the data would need to be converted to WGS 84 for use in Cognos Analytics. Errors and Null Island As part of our error checking, we determine if the latitude values in the data fall between -90 and +90 and longitudes between -180 and +180. Any values outside of these ranges cannot be mapped as they fall outside of the coordinate system. Rather than not mapping that data, we replace the query values with latitude 0 and longitude 0 which allows those data points to map so you can detect the error. For instance, the 0, 0 location is found just off the coast of Africa in the Gulf of Guinea as shown below: As there is no actual land mass there, this location is somewhat humorously referred to as “Null Island,” and is commonly used by mapping systems to display out of bounds data. If you ever see data mapped here, it’s probably in error. The likeliest cause of such an error is putting the latitude and longitude data items into the opposite data slots when defining the map. Geocoding As odd as it sounds, mapping systems, generally speaking, cannot use addresses for locations. Rather, the mapping systems need to have the address converted to an latitude/longitude which can be mapped. The process of converting an address to a latitude/longitude location is referred to as “geocoding.” Companies provide geocoding as a paid service. For example, the address of the White House “1600 Pennsylvania Ave NW, Washington, DC 20500” would be passed to a geocode service which would return the latitude 38.897957, and longitude -77.036560. These values are then stored into the RDBMS for use with Cognos Analytics. Although, it is important to note that Cognos Analytics does not provide geocoding; your data must be geocoded before being used within Cognos Analytics. Conclusion Latitude/longitude support extends the report map support nicely and give us a further foundation to build on.