Blog

Blog

Administration: How to setup #Cognos Analytics OpenID Authentication Proxy federating with Active Directory and LDAP over AD

The purpose of this document is to walk through step-by-step in setting up OpenID Authentication Proxy Federation with Active Directory and with LDAP over Active Directory Namespaces. The following is an actual lab setup: Environment: Active Directory: Windows 2016 Domain: CASUPPORT Cognos Analytics 11 R10+ OS: Windows 2016 Identity Provider: OKTA Before we start, it’s important to assume that users can successfully authentication independently with OKTA, AD or LDAP over AD configured with their Cognos Analytics environment (See Appendix A) via SSO (if enabled) Below is a list of the preconfigured namespaces that will be federated using OpenID Authentication Proxy: Environment: Gateway URL NB: Gateway Configuration in this scenario must be setup successfully. OKTA: OKTA-DEV AD: AD2016 LDAP: ADLDAP Configuration for OpenID Authentication Proxy and LDAP over AD Namespace Steps are as follows: Open Cognos Configuration and Create a new Namespace Fill in the same details as for the OKTA Namespace i.e. Discovery Endpoint, ClientID, Client Secret and Return URL. The important parts are: Identity claim name Trusted environment name: REMOTE_USER (Default) Redirect namespace ID: <Federating to the LDAP over AD Namespace> So here are how those 3 fields are mapped: Identity claim name: sAMAccountName Trusted environment name: REMOTE_USER Redirect namespace ID: ADLDAP REMOTE_USER variable is required for SSO via Gateway Configuration for OpenID Authentication Proxy and AD Namespace 1.Open Cognos Configuration and Create a new Namespace 2. Fill in the same details as for the OKTA Namespace i.e. Discovery Endpoint, ClientID, Client Secret and Return URL. With regards to the Identity claim name field for AD it’s important that the correct “common” attribute (claim) is found that contains the user name. So, if you review the Discovery Endpoint Document list of “Claims Supported”: https://dev-297076-admin.oktapreview.com:443/.well-known/openid-configuration you will see the “name” claim. Then review the list of attributes for any authenticating user in AD and locate the “name” attribute. See below: Identity claim name: Specifies the name of the claim that will be provided to the target namespace. A string that represents the name of the claim from the id_token that will be provided to the target namespace. So here it’s the “name” claim from the id_token that will be passed to the “target namespace” (AD2016) which also has a “name” attribute which exists for all users. 3.Save and restart Switch on OIDC Tracing via the Custom Topics you will see the decoded id_token you will see the “name” claim: Additional Information Appendix A: Cognos Analytics 11 OpenID Connect - OpenID Connect Authentication Proxy Setting up Cognos Analytics 11 with OKTA Setting up Cognos Analytics 11 with AD/LDAP Setting up SSO with Cognos Analytics 11 and IIS

Blog

Planning your upgrade to IBM #Cognos Analytics 11

Development support for Cognos BI 10.2.x will reach End of Support (EOS) in April 2018. IBM will offer Continuing Support for Cognos BI 10.2.x, providing you with continued access to the same knowledgeable global Support team you are working with today. Please visit Cognos Upgrade Central. Plan your upgrade to IBM Cognos Analytics 11 The following diagram shows the four stages of the upgrade workflow: Critical configuration actions to take first! These configuration actions are critical to the success of your installation. Take these actions after you install the components. Critical issues for IBM Cognos Analytics 11.0.0 and later versions The following links identify critical issues and important updates for IBM Cognos Analytics 11.0.0 and later versions. YouTube: How to upgrade IBM Cognos Analytics and associated Technote. YouTube: How to migrate IBM Cognos Analytics content from one environment to another and associated Technote. Making the Move to IBM Cognos Dynamic Query Dynamic Query adoption or migration can provide query performance improvements, meet your users growing needs, help to balance the scales IBM Cognos Lifecycle Manager frequently asked questions (PDF) and YouTube: What’s new in Lifecycle Manager for IBM Cognos Analytics 11.0.4?. Lifecycle Manager is an application that validates Cognos BI report content during an upgrade by comparing reports that run in different versions of Cognos BI. YouTube: IBM Cognos BI 10 Upgrade Series This series of 8 videos shows users the strategies, workflow, best practices and tools needed to move to IBM Cognos BI 10. The process itself is applicable to IBM Cognos Analytics 11. Related posts: End of Service (EOS) for Cognos Business Intelligence 10.2.X Please visit our IBM Business Analytics Support channel on YouTube.

Blog

Requesting access and managing authorized support contacts in the IBM Support Community

As we transition to the new IBM Support Community at https://www.ibm.com/mysupport you might have questions about the different capabilities available to users in the community and how their access to those capabilities can be managed. The good news is that your own organization can manage your users and their level of access. And from a user perspective this is largely done through self-service capabilities, often built right in to the community. Anyone familiar with the process for requesting access and managing authorized support contacts through the IBM Service Request tool that we have used for many years to support our on-premises software and hardware will see little change. But things are quite different for those who have only ever known the now discontinued IBM Client Success Portal where we used to provide support for many of our on-cloud services. Please review the document IBM Support Community: Requesting access and managing authorized support contacts for an overview of: the user roles and their associated capabilities in the IBM Support Community; how a user can request access to the IBM Support Community in a given role or request an upgrade to a higher role; how Administrators (the client's Site Technical Contact and their delegates) can access the User administration application embedded into the IBM Support Community to manage their authorized support contacts, auto-approve rules, and more; how a site's Primary Passport Advantage contact can change the Site Technical Contact through the Passport Advantage Online (PAO) portal; and what to do if the site's Primary Passport Advantage contact has left the organization.

Blog

Embed Cognos Analytics Dashboards into your Applications

In today’s world, data is being produced and stored at an ever-quickening pace.  In fact, according to Forrester, the number of companies storing over 100TB of data almost doubled in 2017. The ability to leverage this data to make timely and effective decisions is paramount.  In many cases, the data is surfaced in one system. Users must then break away from their current activity to extract the data from wherever it lives and bring it into a separate visualization tool to surface insights. Some have tried to solve this problem by including data visualization capabilities directly within an application.  The issue with that approach is two-fold: one, you significantly increase the coding required by your developers, and two: end users are then limited to a set of pre-defined visualizations that may not completely meet their needs. To address the problem for both developers and end users, we’ve developed a new solution that allows you to embed Cognos Analytics dashboards into your applications with ease: IBM Cognos Dashboard Embedded. For the Developer: As the name implies, IBM Cognos Dashboard Embedded, allows you to integrate a dynamic analytics workflow directly into your offering. This may take the form of a guided exploration containing pre-created dashboards with one or more visualizations. However, the true value lies in providing a full creation experience, allowing end users to select their data sources and build their own visualizations in real time to get answers to their questions. Based on Javascript APIs, Cognos Dashboard Embedded utilizes a standard and popular development language that allows developers to quickly and efficiently integrate and maintain Cognos Dashboard Embedded in their offering. For the end user: Not everyone in an organization is looking for the same answers to the same questions. Consequently, a dashboard that works perfectly for a colleague may only provide a subset of the information that meets your particular needs.  With IBM Cognos Dashboard Embedded, you have an intuitive, drag-and-drop user experience, which allows you to explore your data and create visualizations that answer the unique questions important to you. Try it for free today IBM Cognos Dashboard Embedded is now available in the IBM Cloud Catalog.  Try it for free today! Or, click here to learn more about this new offering.

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: 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

Cognos Analytics Release R11 (11.0.11) is here!

Hi Everyone, With the arrival of sunshine and warm weather in Ottawa, we have even more reason to celebrate with the availability of the latest release of Cognos Analytics, release 11.0.1(R11). It has been less than 8 weeks since the last release, which was R10, so this is a  small release in terms of content, but it addresses some of the key things that you have been asking us for. Here are some of the highlights in the new release. Add custom shapes to geographic locations in your dashboards and reports with support for Custom polygons. Read Kas's blog for more details on the new capabilities here. Portal pages in Cognos Analytics at last! -  Access all the portal pages you created in Cognos BI within the Cognos Analytics experience. This was an important Request for Enhancement (RFE) that was raised by you. Check out Chris's blog for all the details. Better Dashboard performance with support for caching, take a look at Jason's blog for more details. Reduce risk of un-authorized modification of Report details - Enables a BI Administrator to override the default visibility settings for objects. This was another popular RFE. Read more about it in Chris's blog. Here is a ppt overview of the new release, IBM Cognos Analytics R11 Overview. Stay tuned for for an update on the Smarter BI & Analytics capabilities that are coming to Cognos in 2018!. Bye for now, Nick

Blog

Portal Pages in Cognos Analytics R11

With release 11.0.11, we are pleased to announce support for Portal Pages created in Cognos 10.x. Portal Pages was a very popular feature in Cognos Cognos BI 10.x and previous versions and many customers have dozens, and in some cases hundreds, of Portal Pages in their Cognos 10.x environments. These customers will now be able to migrate their content to Cognos Analytics while maintaining the experience that many of their users have come to rely on using Portal Pages for easy access to their most commonly used reports and folders. In order to enable Portal Pages in Cognos Analytics 11.0.11, an administrator must set an advanced server setting as follows. This is a one-time step to enable Portal Pages support for the entire environment: In order to do this, an administrator will launch the Configuration Setter page at: :/bi/utils/ConfigSetter.html For example: http://myCAenvironment:9300/bi/utils/ConfigSetter.html One there, add a new setting called: ContentApps.enableMyPortalPages With a value: true There is no restart of services required once the value has been set. Once Portal Pages has been enabled the following will happen: 1. Users who had “Portal Tabs” in their Cognos BI 10.x environment will see a new “My Portal Pages” folder on the Navigation Bar when they log into Cognos Analytics. This folder will read the users profile each time they log in and will display a shortcut to a Portal Page for each Portal Tab they have access to. This is done each time a user logs on so that if an Administrator changes access rights to a Portal Page or removes a Portal Page, the list will be updated for the user. 2. Portal Pages will now launch inside the Cognos Analytics portal or Glass. The Portal Pages themselves should behave just as they did in Cognos 10.x as no changes were made in terms of the functionality and rendering of Portal Pages.   Please note that only legacy content will be rendered inside the portlets contained in a Portal Page. These portlets leverage the Classic Viewer (C10.x viewer) to render content and thus are not able to display new objects such as Dashboards, Stories or interactive reports. Video Overview: Cognos 10 Portal Page migration to IBM Cognos Analytics 11.0.11 My Portal Pages

1 2 3 4 23