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

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

VIDEO: #Cognos Analytics Report Authoring Basics – Part 4: Visualizations

Report Authoring Basics This is a series of short videos aimed at Cognos Analytics Report Authoring beginners. Part 4 - How to create a Visualization Report This video describes some common aspects of creating a Visualization report: Sorting Formatting Color Palettes Labels Titles Legends

Blog

How to connect #Cognos Analytics to DashDB on IBM Cloud

The purpose of this blog is to demonstrate the capabilities of connecting an on premise instance of  Cognos Analytics to  a cloud-based database service instance hosted on IBM Cloud. This is a great environment for testing purposes and provides insight into Cognos Analytics full capabilities against IBM DB2 Warehouse on Cloud for Analytics. The following are the actual steps taken to get this working using your free IBM Cloud account. To setup a free account go to https://console.eu-gb.bluemix.net and sign up. Environment: Cognos Analytics Server 11 Video: Steps: Create a Test DashDB instance: Create a IBM Cloud account and log in, then select "Services" and click on "Db2 Warehouse". 2. Then give the Service a unique name and click on the "Create" button. 3. Once the service has been created the following page will be displayed: Create the credentials: 4. Next, click the service that has been created and  click on “Service credentials” then “New credential”. 5. Next, give the credential label a name and click “Add”. 6. This will generate a json document with all the connection and signon details. You can see entries for an SSL connection string  "ssljdbcurl" and a non SSL connection string  "jdbcurl" as well as Port and password information. Download and Install the JDBC driver: 7. The next stage is to download/install the drivers. From the console click on “Manage” and then click on “Open”. 8. Click on the “Download” section and download the drivers based on the OS platform. 9. In this case, since CA 11  is on Windows 2016, download the “Driver Package for Windows 64-bit” and install on the CA 11 Server. The next section is specific to setting up the CA 11  Datasource Connection to IBM DB2 Warehouse on Cloud From the Driver Package installation locate the JDBC Driver (<installation>\IBM DATA SERVER DRIVER\java\db2jdbc4.jar) Copy this over to the CA 11 R6 /drivers directory (<installation>\ibm\cognos\analytics\drivers) Restart the Cognos Analytics service. Creating the Dynamic Datasource using the JDBC Driver Information In Cognos Analytics: 10. Login to Cognos Analytics and select “Manage” – “Administration Console” – “Configuration” – “Datasources”. 11. Create a new JDBC Type Datasource Connection. 12. With regards to the signon, use the credentials as generated in the JSON document above. 13. Test the connection, then go to the properties of the datasource and enable the “Allow web-based modeling” option so it’s visible in CA11. 14. You can now create a new Framework Manager Model, import the datasource and the table(s) and publish a package.   Please visit the IBM Cognos Analytics channel on YouTube.  

Blog

VIDEO: How to upgrade your version of #Cognos Analytics

New to Cognos Analytics 11 is the ability to install a new version of IBM Cognos Analytics over the top of your current version of the product. This installs a higher version without overwriting existing Cognos maintained configuration files from the previous installation. The new and improved upgrade procedure allows customers to take advantage of the Cognos Analytics continuous delivery model and deploy new features quickly and easily. Video   In the video we will show you: How to backup your environment and preserve any customized files. How to perform the upgrade for both the server and client tools. How to verify that the upgrade worked successfully. Environment: Cognos Analytics 11.0.6 Please visit the IBM Cognos Analytics channel on YouTube.

Blog

#Cognos Analytics - How to import the reporting templates and themes (11.0.6+)

IBM Cognos Analytics includes several report templates and color themes that you can choose from when you create a new report. If you only see two templates when you create a new report (see image below), ask your administrator to import the deployment file into Cognos Administration. The templates and themes are stored in the Samples_For_Install.zip deployment file. Here is a video that explains how to find and import the deployment file:   Tip: You can select only the Templates folder during the import process if you don't want to include all of the samples. Create your own Templates & Themes You can also create your own report templates and themes, and make them available to other users. Save your templates with a unique name to the Templates folder under Team content, and the themes to the Style Reference Reports folder under the Templates folder. Best Practice: When saving, do not use the same name as an existing Cognos template or theme because it may be over-written when your product is upgraded to a higher version. Any report or theme that is saved in the Templates folder appears in the list of templates or themes when you create a new report. Icons By default, templates or themes that you create are identified by a blank icon in the list of available templates and themes. You can associate your own icon to a template or theme. Save the icon as an SVG with the same name as the template or theme, replacing any blank spaces in the name with the underscore (_) character. For example, if you create a template that is named My template, save the icon as My_template.svg. Then, ask your administrator to add the icon to the folder <install_location>\webcontent\bi\pat\images\templateReports for templates or <install_location>\webcontent\bi\pat\images\themeReports for themes. Related posts: IBM Knowledge Center: Templates and themes Video: How to import the samples deployment (11.0.6+) IBM Knowledge Center: Four categories of Cognos samples Library of How-To Videos for IBM Cognos Analytics Samples Landing Page Please visit our IBM Business Analytics Support channel on YouTube.