Blog

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

Archive Results

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

Latest Capabilities of #Cognos Analytics - Client Success Webinar Session 1 Replay

Thanks for attending the webinar delivered by the IBM Analytics SaaS Client Success team.  Here is the recording from: Cognos Analytics Session 1 - Latest Capabilities of Cognos Analytics During the first session, we covered: New capabilities going from Cognos 10 to Cognos Analytics 11 Benefits of moving to the Cloud Demonstrations of the latest features including integration with Watson Analytics [video width="1024" height="768" poster="https://community.watsonanalytics.com/wp-content/uploads/2017/09/Cognos-Blog-1.jpg"][/video] Recorded - Wednesday, September 20, 2017 Session #2, "Your Cognos Analytics Cloud Migration" occurred on September 27, 2017 and the recording is now available.

Blog

Learn what's new in the latest release of #Cognos Analytics 11.0.7

The latest release of Cognos Analytics, R7 is here and I am excited to share the details about all of the new functionality. Cognos Analytics R7 puts more capabilities at your fingertips for working with and analyzing your data, all without leaving the environment. And, creating pixel-perfect, interactive professional reports just got a lot faster. This new release is chock full of new capabilities and enhancements that cover all aspects of the product starting from the improved U.I., to dashboarding, reporting, modeling, data server, and the list goes on. Some of the highlights include capabilities that make it easier for users to use more of the data preparation, data discovery and reporting capabilities with: New, enhanced visualization types with measures as attributes on axis, support for chart values and more Calculation advancements for data modules and dashboards Filtering enhancements that enable you to do more with your filters in both your visualizations and reports Support for maps in your reports for greater readability and precision Navigation enhancements that make it easier for report users to drill down and back to change the focus of their analysis For more details on all of the new capabilities in R7 check out the series of blogs below, and you can access the free trial of Cognos Analytics which has been updated as well: Portal enhancements Dashboarding Storytelling Powerplay Planning Analytics Reporting My Parameters Interactive Performance Assistant Data server updates Data modeling enhancements User Session Logging

Blog

User Session Logging in Cognos Analytics 11.0.7

Easier administration: New user-specific logging in Cognos Analytics 11.0.7 Logging has always been problematic for administrators because files must be edited and renamed, and then services must be restarted. In Cognos Analytics 11.0.7 we have introduced a new logging framework that requires no application restarts. This framework is administered in the Cognos Analytics 11.0.7 Manage UI. The new “User Session” logging functionality is specific to a user or a session. It is useful when diagnosing a user-specific issue. Please note: User Session logging does not affect any other user on the system. User Session logging must be enabled by a Server Administrator or System Administrator.   To enable User Session logging Go to Manage -> Configuration -> System and then select the “Diagnostic logging” tab. From there you can enable or disable user session logging. This setting applies system wide. Once disabled, User Session logging is not available for any user on the system. When enabled system-wide, the user trying to reproduce the issue can begin a log via their profile in the portal. When the user selects Log my session they are presented with the “User session logging” screen. On this screen, they are given a unique log identifier. This identifier must be given to an administrator with access to the ../logs directory. The log file or files that result from the user’s logging session will have this unique session identifier appended to them. This will happen in the logs directory on each server that has a component that the user’s action uses. For example, if the user is creating logs for an issue that occurs when running a report, then the following logs are created: cognosserver-session-3cdbb1c9-b8b2-471b-b7b1-0fd7163ee458.log dataset-service-session-3cdbb1c9-b8b2-471b-b7b1-0fd7163ee458.log The administrator can use these files to determine specific issues associated with a set of user actions. Once logging is enabled, there are three ways to disable it for a user: 1- Disable logging in the browser session. 2- Close the browser. 3- Wait one hour until the session times out.

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.

Blog

Samples for IBM #Cognos Analytics 11.0.7 on AIX

The following samples are not available after installing IBM Cognos Analytics Server 11.0.7 on AIX: The Samples directory: <cognos_analytics_server_install_location>/samples The Base Samples deployment (Samples_for_Install.zip) under the <cognos_analytics_server_install_location>/deployment folder To install the samples on AIX, please follow these instructions. Please visit our IBM Business Analytics Support channel on YouTube.

Blog

Administration – Changing the behaviour of Object Copying in Cognos Analytics

Retaining target object ID’s when copying objects By default, when you copy objects to a new location, the copied object completely overwrites the existing object, including any links for the object. This behavior ensures that reports reference packages properly. However, you can change the default copying behavior. For example, you can change the copy behavior if you are overwriting reports that do not reference packages, and you want to maintain a job schedule to run the reports.  You can update a configuration so that when you copy objects, the content of the target object is overwritten, but the ID of the target object is retained.  You can then refresh a report by copying a newly authored or modified report and overwriting the target report; the job continues to run the report successfully. To enable 'update' behavior when copying objects overwrites existing objects launch a browser and update the sample URL shown below to the name of any dispatcher in your environment or gateway in your environment: http://dispatchernameOrip:9300/bi/utils/ConfigSetter.html The configuration setting that needs to be updated is: Portal.updateTargetObjectWhenOverwrite Value: true or false Default: false In the Name property enter: Portal.updateTargetObjectWhenOverwrite In the Value property enter: true There is no restart of the system required but they system needs approximately 10 seconds to make the change. Once completed you will be able to copy a report overtop of an existing report, choosing overwrite but the objects Object ID will not be updated. The setting can be changed back to the default setting by setting the value back to “false”.

Blog

Administration – OpenID Connect is available in #Cognos Analytics 11.0.7

OpenID Connect (OIDC) is a simple identity layer on top of the OAuth 2.0 protocol for federated identity and authentication with other applications in your organization that are also configured to use the same OIDC identity provider (IDP).   OIDC support is built into our product and available for both on premise and our Cognos Analytics on Cloud customers.  OIDC is our direction for web-based authentication providers for customers wishing to federate Cognos Analytics 11 with other applications.  OpenID Connect is a modern standard and takes all the best things from SAML, OpenID and Oath2 using lessons learned from these older standards. Most of the tradition SAML 2.0 IDP’s are already releasing new versions with OIDC support in their product.   Check the administrator of your companies IDP or with the IDP sales or support organization. OpenID Connect in Cognos Analytics 11.07 Release 7 introduces support for: Active Directory Federation Service Azure AD Google IBMiD Okta Ping SalesForce We will continue to monitor requests for other OIDC IDP vendors using our Request For Enhancement (RFE) process which can be found at the URL below.  Make sure you search for existing RFE’s before logging a new one and if you are logging a new one, log it against Cognos Analytics. https://www.ibm.com/developerworks/rfe/ Configuration of OpenID Connect Configuration of OIDC is simple and easy to do and requires very little information and configuration. On the content manager node, select the correct OIDC namespace for your vendor.  In the configuration examples below I will be using ADFS but all OIDC IDP’s are very similar in their setup. Once the OIDC provider you are using has been selected you will need to get information from the IDP to complete the configuration. Namespace ID is used in the CAMID Discovery Endpoint, Client Identifier and OpenID Connect client secret can all be obtained from your OpenID Connect administrator Return URL needs to be updated with your gateway or dispatcher URL The last step is to import the OIDC root Certificate Authority certificate from the OIDC’s SSL certificate into the Cognos Analytics keystore using the Third Party Certificate Tool.  To get information on this see our documentation, there is a link to the OIDC documentation at the end of this blog.  Once you have completed all these steps you must do the same configuration on your backup content manager and then restart both content managers. NOTE: if you use a Load Balancer in your environment, then you will update the Return URL with the DNS entry from the Load Balancer so that all requests are handled correctly.  This is regardless of whether the load balancer is in front of many gateway or dispatcher nodes. Example if you are using a webserver with the Cognos Analytics gateway installed on it:  https://MyLoadbalancerDNS.mycompany.com:443/ibmcognos/bi/completeAuth.jsp Example if you are using a set of dispatcher nodes behind the load balancer with no webserver and Cognos Analytics gateway installed: https://MyLoadbalancerDNS.mycompany.com:9300/bi/completeAuth.jsp   Single Signon If your OIDC IDP support Single Signon and two factor authentication, then Cognos Analytics will take advantage of that as this is enforced at that IDP when Cognos Analytics sends the request for authentication.  Cognos Analytics redirects to the OIDC IDP logon page.  Once your user has provided the information required they will be redirected back to Cognos with an authorization code that Cognos Analytics redeems for an ID Token which contains the identity of the user.  If Single Signon is available from your IDP then that happens when the user makes the request and the ID Token is made available to Cognos Analytics and the users is logged in.   What about SAML? If your IDP doesn’t support OIDC but does support SAML 2.0 then you do have the option of using IBMiD.  IBMiD supports OIDC and allows customers to configure Cognos Analytics to IBMiD using OpenID Connect.  Once that configuration is completed then the IBMiD team can help you federate your Cognos Analytics to most SAML 2.0 IDP’s.  When your users log on, they are redirected to the IBMiD page and prompted to type in their email address.  Once the user does this, IBMiD will recognize them and redirect the user to your companies SAML 2.0 IDP logon page where the user can complete the authentication request by providing the required credentials.   Diagnostic Logging If you are having issues after you have the configuration correct, you can use diagnostic logging to help narrow them down.   In this case, you would want to create a new logging topic.  Download the AAA tracing and update it with this: { "loggerDefinitions": [ { "loggerName": "com.ibm.cognos.camaaa.internal.OIDC", "level": "DEBUG", "additivity": true } ], "topicName": "OIDC" } To get information on diagnostic logging see the blog below which is an overview and has a link to diagnostics logging documentation Blog on Diagnostic Logging OpenID Connect Documentation    

Blog

New Base Samples for IBM #Cognos Analytics 11.0.7

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.zip deployment file. After you import the deployment, you will see the following new Base Samples: Team content > Samples > Reports Global sales This sample report uses a Block, a Custom Control, and JavaScript to hide and show a panel of filters. For more information, please visit this Blog post. Corporate website visits 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 in California. Team content > Samples > Data Sample data module We added State/Province, City and Zip/Postal Code to facilitate mapping. This sample data module is intended to help beginners start authoring reports and dashboards. The Sample Outdoors Company is a fictitious business operation with data for products, retailers, order methods, and year. Source: IBM California website visits We created data at the Zip Code and City level for the new 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 Extension Samples There are two new sample Extensions for IBM Cognos Analytics 11.0.7. Please visit this Blog post to learn more. Audit Samples The Audit samples have been updated for IBM Cognos Analytics 11.0.7. We have improved the look and feel, increased the overall usability of the reports, and switched all the reports to Dynamic Query Mode. Please visit this Blog post to learn more. OLAP Samples To demonstrate typical OLAP features in IBM Cognos Analytics 11.0.7, we have created a sample dashboard, report, and the underlying OLAP cube. Please visit this Blog post to learn more. Package based drill-through Samples To demonstrate package based drill-through in IBM Cognos Analytics 11.0.7, we have provided sample source and target reports that use the sample GO data warehouse (query) package and a drill-through definition. Please visit this Blog post to learn more. Related posts: Supplementary (Legacy) IBM Cognos Analytics 11 Samples Samples landing page Please visit our IBM Business Analytics Support channel on YouTube.

Blog

New OLAP samples for IBM #Cognos Analytics 11.0.7

To demonstrate typical OLAP features in IBM Cognos Analytics 11.0.7, we have created a sample dashboard, report, and the underlying OLAP cube. Here are the instructions for installing and viewing these new samples. Related posts: New Base Samples for IBM #Cognos Analytics 11.0.7 Supplementary (Legacy) IBM Cognos Analytics 11 Samples Please visit our IBM Business Analytics Support channel on YouTube.