Blog

Blog

Portal Visibility Filter

The Portal Visibility Filter defines a set of rules that determine which content, reports, folders and so on, are visible to users. Generally, this means content the user cannot access is not shown in the portal (i.e. not visible) and content the user can access is shown. The default visibility filter is: read, write, execute, traverses, setPolicy meaning that any user with any of these permissions on a given content item will see that item. Note: While visibility filter rules work in tandem with permissions, they are not the same and should never be confused as such. Permissions determine access. The visibility filter determine if the user sees the item. There are some use cases where the default visibility filter rules are insufficient to meet the business need. For example, some customers have reports that must only be run as drill through targets . To run the report as a drill through target, the users need (at least) run security permission. The default visibility filter rules would allow the users to see the all reports they can run. This would allow the user to run the report directly, rather than as a drill through target, thus failing to meet the business need. In Cognos BI 10.x, the portal visibility rules could be customized by editing the C:\Program Files\IBM\cognos\c10_64\templates\ps\portal\system.xml file. In Cognos Analytics 11 Release 11, the portal visibility filter rules can be customized using the ConfigSetter utility. As with Cognos BI 10.x, visibility rules are global. However, in Cognos Analytics 11 R11, the configuration is centralized and does not require changes to each server nor a server restart. Invoke the ConfigSetter utility To invoke the ConfigSetter utility: 1. Open your browser 2. Go to Cognos Analytics 11 Release 11 (or later) with a URL such as • http://server:9300/bi 3. Login as a System Administrator user 4. Invoke the ConfigSetter utility: • http://server:9300/bi/utils/ConfigSetter.html 5. You will see a web page like this:   Note: There is no need to restart servers/services after making the change. On the other hand, it may take longer than 10 seconds before changes take effect.   Set the Visibility Filter Rule To set the Visibility Filter Rule, change the parameter: Content_Service.permissionsFilter By default the parameter is set to all valid values: read,write,execute,traverse,setPolicy The parameter can be customized with any subset of these values such as: read,write,setPolicy To change the parameter value, enter the parameter name and new value such as:   Press the Submit button. Wait 20 seconds. Log out of the system administrator user. Login as a user with more limited content permissions to see the change take effect.  

Blog

Data caching in dashboards

In continued efforts to ensure Dashboards perform at their best we are introducing the ability to control data caching at the overall dashboard level. You will find Data cache under the properties of the dashboard. The default value is Automatic which picks up the corresponding setting from the data source a widget is connected with. In version 11.0.11 the Automatic setting only applies if you are using a Framework Manager package but it is expected that future versions of Cognos Analytics will support caching properties within data modules. The corresponding setting in Framework Manager is a governor called Allow usage of local cache. The dashboard data cache property also has options to turn it On (cache is used whenever possible) or Off (never cache data). These apply to live connections to data servers within a package or data module but are not applicable to data sets or uploaded files. This data cache contains results from SQL queries to data servers that retrieved the data presented in dashboard widgets. In processing a dashboard widget, the system determines whether the widget is a candidate for reusing cached data. If so, the system will check whether the results for a compatible SQL statement have been cached for the same data server connection. If so, that cached data will be reused. Results that are cached from one user’s dashboard can be reused for a different user’s dashboard only if both users have the same data security profiles. No need to worry about users seeing data that they should not. This cached data is retained in a Cognos Analytics server’s memory for as long as the original connection to the underlying data server remains open. These connections have a default idle timeout of 300 seconds (5 minutes) which can be modified in the Administration console. When the dashboard widget property Refresh Automatically is turned on, data caching won’t occur for that widget no matter what.

Blog

Mapbox hosted custom polygons in reports and dashboards

With Cognos Analytics 11.0.11 users will be able to visualize custom polygons hosted on Mapbox within reports and dashboards! Here’s how you can start visualizing your custom geospatial polygons in Cognos! You can refer to the instructions below or watch the video that shows you how to add custom polygons. If you don’t have a MapBox studio account already the first step would be to create one (each organization/department can host all their polygons on one account). For many of our users the free account with 5GB of storage space should be more than sufficient to host all their polygons. Then upload your geoJSON custom polygon file to Mapbox as a tileset. Custom polygons in different formats such as .shp and .KML can be easily converted to geoJSON using several open-source software (QGIS is recommended). A tile-set is essentially a compiled set of geoJSON optimized to render fast on a browser. If your geoJSON is under 5MB, you will also be able to edit the geoJSON directly in Mapbox-datasets through an intuitive UI. Once edited it can be exported into a tileset. Each polygon will need to have at least one uniquely identifying property (we recommend that this be an abstract identifier) Ensure the tileset is made Public (Tilesets are public by default) Once you have you tileset created in Mapbox you will need 3 keys from the tileset page. 1 – MapID, 2 – Layername, 3 – Property Name (unique identifier)   Mapbox tileset In the Cognos Map visualization expand the properties pane and enter the 3 keys from the step above. This workflow is identical in both Cognos reporting and dashboards. Then simply drag your Property name (unique identifier) into the locations slot and a measure (s) under the location colour/Point colour/point size slot. That’s it!     Note – if your custom polygons are points then enter the 3 keys in the points layer instead. Best practices Do not add any confidential or sensitive information as a polygon property. Although, not common, if your existing geoJSON has sensitive information in its properties, we recommend that you remove them before uploading your polygons to Mapbox. Best practice would be to make the geoJSON property an abstract identifier. Share the 3 keys to your Mapbox tiles on a need-to-know basis. For better performance and to guarantee polygons appearing at zoom level 0 (world view) it is recommended to compress larger geoJSON files to less than 10MB. http://mapshaper.org/ is a fantastic free tool to do this. a. geoJSON larger than 10MB will be set default zoom extents that may not begin at worldview – level 0 (this is a mapbox optimization technique). However, if you want to manually change the zoom extents there are few ways to do so. i. Tippecanoe APIs (Linux, MacOS) ii. Download Mapbox studio classic on your desktop (windows) and change min/max zoom levels iii. Mapbox documentation here: https://www.mapbox.com/help/adjust-tileset-zoom-extent/ To ensure that autozoom works in Cognos reporting we recommend setting the unique polygon identifier as a string value. For those working with custom polygons in small areas (postcode level) we recommend turning off auto zoom after the initial map render. This will result in a better experience when filtering as the map will not have to reset zoom and pan in multiple times. Related posts: New Base Samples for IBM Cognos Analytics 11.0.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 Please visit our IBM Business Analytics Support channel on YouTube.

Blog

New version of Cognos Analytics trial

A new GDPR-focused version of the Cognos Analytics trial will be made available prior to May 25, 2018. This new version of the trial will be called the Cognos Analytics on Cloud Trial. For information on GDPR, please see www.ibm.com/gdpr. For any users of the existing Cognos Analytics trial, be aware that all content that you created in your 'My Content' folder will be lost in the transition to the new version of the trial. When the Cognos Analytics on Cloud Trial is made available, all existing links within IBM that reference the existing trial will be updated. New terms and conditions of use for the trial will also be available at that time. Clients are responsible for ensuring their own compliance with various laws and regulations, including the European Union General Data Protection Regulation. Clients are solely responsible for obtaining advice of competent legal counsel as to the identification and interpretation of any relevant laws and regulations that may affect the clients’ business and any actions the clients may need to take to comply with such laws and regulations. The products, services, and other capabilities described herein are not suitable for all client situations and may have restricted availability. IBM does not provide legal, accounting or auditing advice or represent or warrant that its services or products will ensure that clients are in compliance with any law or regulation.

Blog

GDPR and Cognos Analytics

Pauline Salamani and I recently gave a presentation on GDPR and Cognos Analytics at IBM’s THINK conference in Las Vegas. Pauline is a Watson Analytics offering manager and has been the lead for GDPR within Business Analytics and I have been one of two offering managers responsible for GDPR within Cognos Analytics. An on-line video of the presentation is now available here: https://gateway.on24.com/wcc/gateway/eliteibmhybridcloudanalytics/1459889/1648673/being-gdpr-ready-with-cognos-analytics-think-tech-talk-series Clients are responsible for ensuring their own compliance with various laws and regulations, including GDPR. IBM does not provide legal advice and does not represent or warrant that its services or products will ensure that clients are in compliance with any law or regulation. For more information on GDPR, please see: www.ibm.com/gdpr

Blog

VIDEO: End of Service (EOS) for Cognos Business Intelligence 10.2.X

[video width="1650" height="928" mp4="https://community.watsonanalytics.com/wp-content/uploads/2018/05/Cognos-10.2-EOS-Replay.mp4"][/video] Do you need more information about the upcoming End of Service for Cognos Business Intelligence 10.2.x ? Learn from the leaders from the IBM Cognos Analytics Support team about what End of Service means and the options available to you after April 30, 2018. Also see... Continuing Support Service Extensions Upgrade Central Link to EOS announcement for 10.2 Lab Services (Business Analytics) Cloud Expert Services End of Support Lifecycle   Related posts: Planning your upgrade to IBM Cognos Analytics 11

Blog

We’ve improved your support experience!

We appreciate the opportunity to have you as a client.  IBM continually strives to seek new and better ways to improve the support experience we offer you.  With that in mind, we’re implementing some enhancements to our support model by launching a new IBM Support Community that all IBM products will move to over time. We are pleased to advise you that this weekend we have moved all client support – including discussion forums and support case management – for the following IBM Business Analytics cloud services to the new Support Community: IBM Cognos Analytics on Cloud IBM Cognos Controller on Cloud IBM Planning Analytics IBM Watson Analytics We know that you may have other IBM products that will also be migrating to this new support experience. Watch out for further information on the specific timing of this from the relevant support teams. Within the new Support Community, self-service capabilities are available to allow for better ease of use, including: Discussion forums where you can ask questions, help answer questions from other users, and interact with knowledgeable IBM staff Simplified search capability powered by IBM Watson to view knowledge artifacts, forum discussions, and support case history Support case creation/updates Ability to attach documents for review by support staff …and much more! We invite you to view the following short videos that provide an overview of the initial experience that will continue to evolve and become richer over time. Introducing the IBM Support Community: Search https://mediacenter.ibm.com/media/t/1_hjcvgybl Introducing the IBM Support Community: Forums https://mediacenter.ibm.com/media/t/1_dnpmr6oi IBM Support Community: Open and manage Cases https://mediacenter.ibm.com/media/t/1_47uqs38j During this weekend’s transition to the new Support Community your active support cases will be moved first followed by your case history, and can be found under the Cases tab once you have signed in. You can access the new support experience by following these steps: Go to  https://www.ibm.com/mysupport To participate in the discussion forums, and to submit and manage your support cases, you will need to sign in. If you sign in to your IBM Business Analytics cloud service using the same user name and password that you use on your organization’s network then you can sign in to the IBM Support Community the same way. Otherwise you should sign in using your IBMid user name and password. Note that this is not the same as your IBM Client Success Portal user name and password that you most likely use today to submit and manage your support tickets for your IBM Business Analytics cloud service. If you do not have an IBMid, you can sign up for one here: https://www.ibm.com/account/us-en/signup/register.html. Note that in the new support experience you will, by default, receive a notification email whenever an update is made to one of your ongoing cases. Please do not reply to this notification email as this will not update your case. The notification email contains a link directly to your case where you can review the details of the update and respond appropriately. You can configure your email notification preferences for support cases and discussion forum updates. Please see the following community release update for further information, https://www.ibm.com/mysupport/s/article/Case-Email-Notifications. If you experience a problem with the IBM Support Community (such as a login issue, etc.), we are here to help.  Please submit your issue via the link found near the end of each page in the community and someone will get back to you as quickly as possible. We hope you enjoy the enhancements of this new IBM support experience and always welcome your feedback.

Blog

Creating High Performance Dashboard and Report Using Cognos Data Set

Authors: Kevin Nichols (Performance) and George Xu (Senior Software Developer)   Introduction The project timeline is tight. You need to come up with a reporting solution quickly with high performance. The data set from IBM Cognos Analytics could be your best choice. Building on top of the existing Cognos reporting platform, the new data set feature produces a data snapshot from a package, an external file or even a module. The data set provides on the fly, self-serving ETL capability without the need for a complex ETL tool and related technical expertise. A report/dashboard developer can develop a report/dashboard against a data set using a module, produce much more improved performance because of the high-efficient data storage, simplified query process and better data cache in Cognos data set service. Design Flows The following flow chart demonstrates the possibilities of utilizing this new data set capability. The first scenario delivers dashboard/report via dynamic generated queries directly against the data source, provides near “real time” data reporting. The second scenario delivers much faster performance via data set with a smaller data volume however the data freshness depends on how frequent the data set is built. The data set feature is perfectly designed to the situation when data does change, however in a manageable manner. Performance Comparisons Below is a performance comparison of a report based from a package vs a report based from the same package to a data set from a module. As you can see, first opens have increase by over 85% and subsequent run by over 58% by using this technique. How to Create Data Set Data Set/Module functionality can be used with reports that were based off a package. For creating a data set based from a package we used the following steps: Using a per-existing package, from the ellipsis select “Create data set” from the menu. New Data Set UI New Data set UI will display to the end user. From the source plain, select the desired items (essentially the same items from your report based on the package) you wish to be apart of the data set and drag them to “Add data here” window. This will pre-load the items with data from your reporting data tier, now save and load the data Note: If the contents in which you are loading is more than 100K of rows, it would be best to save and load the data as a background process Data Set Reload To reload the data outside the New data set GUI, select your newly created data set and ellipsis select “Reload” Note: This action will perform a background process data load from your data tier to your newly created data set. Data Set Data Load Through Scheduling As data changes on the data tier you may want to schedule a reload during after hours. By selecting the properties of the data set and selecting the schedule tab then New you can enter a time to best suite your needs Module based on Data Set Now that the data has been loaded into the data set you can create a new module based on the preloaded data set you just created. Select New > Data Module > Data Set Select your data set which was based off your package and select Done Module UI New Data Module UI will now appear. Select and drag the new data set pre-load data based off the package under the new New data module from the Data module plain. Save the newly created Module. Module Report / Dashboard Creation With the newly created Module, you can create a report or a dashboard to display the rows from the report data tier. The benefit of this is that on heavy server based reports, you could gain in performance up to 6 times for first hits and over 2 times with subsequent runs due to the pre-loaded parquet data set data. Summary - Data Set Advantage Empowers self serving capability without traditional ETL and IT development work Produces faster performance with reduced resource requirement to overall system

Blog

Did you miss Think 2018? Don't worry, Watson has you covered.

Yes, the Think 2018 conference is over. But, not to worry. Watson has you covered when it comes to getting caught up on all the sessions and key-notes. For a list of all the sessions, click here - https://myibm.ibm.com/events/think/all-sessions (You'll need to log in using your IBM Web ID.) From here, you can search for sessions that might interest you or use the filters on the left side of the screen. Next, try using the Ask Watson tab for more tailored search results. For example, enter "Cognos Analytics and Planning" in to the Watson Search. If there is a blue bar at the bottom of the session card, good news - that means there's a recording or a presentation from Think 2018. So you can either relive the experience or learn something new today. Don't forget the key-note speeches as well. For a complete list of the speeches heard at Think 2018, click here.    

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.

1 2 3 4 5 23