Integrating Cognos and SharePoint does not take very long with QueryVision Web Parts. The installation and deployment process can be done in less than 15 minutes. Quite frankly reading the documentation and gathering the information you need usually takes longer! Lets start with a quick overview of what the steps are and then we can [...]
There are several options for exposing metrics (metrics studio, watchlist, diagrams, …) through the QueryVision Cognos Components Web Part. The first step is to set up a portal page/portlet in Cognos Connection, the second is to expose it in SharePoint via the QueryVision Cognos Components Web Part. In Cognos connection, use an existing portal page [...]
One of the hidden gems of the QueryVision Report Viewer Web Part is that it has the ability to receive parameters and prompts that in turn drive filters in your Cognos Reports. This enables you to quickly setup a Cognos Dashboard directly within SharePoint using Cognos content as well as other data sources. This is [...]
The Challenge Administering and testing Cognos applications typically requires creating and changing administration and test user accounts, permissions and group/role memberships: Create Test users and assign group/role memberships to match each of the different Application users including groups or role assignments. Grant temporary Administrative accounts or privileges for Cognos Developers for one time or infrequent [...]
Techniques for Bursting Cognos Reports: For Cognos, bursting and multi-dimensional data sources (OLAP sources or multi-dimensional models built with Framework Manger) need to leverage some additional techniques. This includes master/detail reports that involve multi-dimensional data sources, whether purely multi-dimensional or a combination of multi-dimesional and relational sources. One key issue is linking the burst key [...]
Other blogs in this series: Overview Save Individual Report Outputs to the File System What Cognos refers to as the “Save a Copy of Report Output inside IBM Cognos” is actually the ability to save all report outputs to both the Content Manager and to a file system location. This includes burst report outputs. As [...]
Other blogs in this series: Overview Save All Report Outputs to the File System What Cognos refers to as the “Save a Copy of Report Output Outside of IBM Cognos Software” is actually the ability to save individual report outputs or burst report outputs selectively to the file system. Notes: This option (and its configuration [...]
While researching some upcoming Cognos/SharePoint and general Cognos products and features, we needed to get an in-depth understanding of the Cognos implementation of bursting and what options there are for saving individual and burst report outputs to the file system as part of the run report options vs. selecting to save a Report to the [...]
A core feature of Cognos has always been the ability to save and print the result of a Report, Query, Analysis or other Cognos BI component. For most of these components the option is either in the run options or in the report viewer with the “view in” drop-down . Where a print/save option is [...]
Note: The focus of this article is for Cognos Administrators that applies whether you are using QueryVision’s Web Parts for Cognos or accessing Cognos BI servers via Cognos Connection. Many, if not most organizations want Single Sign On (SSO) for Cognos access for their users. While relatively straightforward for NTLM (using REMOTE_USER), Kerberos is more [...]
In Part 1, we talked about use of system.xml files, permissions and the various hide/show options for controlling what individual users and groups see both in Cognos Connection and in QueryVisions’ Web parts. In Part 2, we look at controlling access to Portal Tabs, including Public Folders and the users My Folders. Controlling what [...]
Integrating Cognos and SharePoint does not take very long with QueryVision Web Parts. The installation and deployment … [Read More...]
This article focuses on setting up our SharePoint Web Parts for Cognos integration. After running through our … [Read More...]
