Branding Cognos Connection - Corporate Look and Feel

Rob Hale said: As a site with an established and steadily growing Cognos 8 BI capability we are now starting to look at some of the more cosmetic changes we can make to BI client delivery and one area that has been flagged by clients for change is the look and feel of the Cognos Connection portal it ...

Link to directory with Microsoft excel files not working in 8.4.1

I have two small issues for the same objective.We save report outputs to a folder and have allowed users access privileges to get the report.1. In order to simplify process, I created a html link in Cognos Connection to the folder as follows:\\productionserver\Cognos Reports\When clicking on the lin ...

Cognos 7.3 / DB2 cube disable

We have recently upgraded from Cognos 7.1 to 7.3 for use with DB2 and upon finalising installation, have discovered that the PPAdminTool.exe program which was originally included in 7.1, is not included in the 7.3 install.We require the PPAdminTool.exe to disable cognos cubes whilst refreshing them. ...

Cognos Impromptu-Catalog Creation

HiI want to use Cognos Impromptu.I have query about creating Catalogs in impromptu.Is it possible to create Database in impromptu using two databases from MS SQL database.For example I want to create database in Impromptu with master and msdb fro MSSQL so I can create report with data from master an ...

COGNOS version question for DB2 v 9.7

We are using DB v9.7 and are having intermittent problems with the instance crashing. We are using COGNOS 7.4 MR3. I see a COGNOS 7.4 MR4 listed as being compatible with DB2 v 9.5 but no mention of 9.7. Is there a MR5 or some fixpack or anything for COGNOS 7.4 for DB2 v 9.7? ...

Configuring Cognos 8.4.1 Gateway on Sun Java System Web Server 7

Has anybody Configured Cognos 8.4.1 Gateway on Sun Java System Web Server 7, if so can you please send me the steps to how configure ...

Oracle Cognos Installation setup

I want to compare the features of two.I am trying my hands on Hyperion. Can I get Cognos 8.3 setup anywhere?I heard that Cognos has come up with very cool features in this new version ...

Enabling Single Signon to Cognos 8.2 Secured against Active Directory on Unix Environment.

Charlene Leichter said: Hi,We are Using OS: Solaris , Database: Oracle , Product Version: 8.2 .I kindly request if any one can help in Enabling Single Signon to Cognos 8.2 Secured against Active Directory on Unix Environment.I Need the steps involved in Security Implementation.Thanks in advance.Cogn ...

COGNOS report studio in Firefox

Tod Jurke said: My Internet Explorer is down and my help desk is having trouble figuring out the problem. I wanted to use Firefox as a work around. I can get COGNOS to open in Firefox but with less menu options than IE. I can access "Cognos Connection" from the Welcome screen but upon launching, I d ...

Cognos 8.2 Deployment Process for Cube and its Analysis Studio Reports from DEV to QA or to PROD

Charlene Leichter said: Hi,I need the Process of deploying the Cube and its Reports from Development Environment to QA and then to UAT or Production Environment.Since the Cube published on to Development Environment cognos connection will contain Development database data only, now when we deploymen ...

Cognos Locks Up on Cognos 8.2 BI.

Support TOSM said: This in the second day in a row I was playing with thepermissions (as in adding users to groups and such long LDAP lookups) and itlocks up.I am running COGNOS 8.2 BI. Here is what I am try to do: I am trying to add users from my university's namespace to a group in the Cognos name ...

Connection Problem with PCConn utility - Cognos 8.3

Pablo Sebastian Labbe Ibaceta said: Hi folks, I'm trying to implement an batch file that calls pcconn utility (the new replacement of cubeswap), but I'm having some problems when trying to run in script mode. Interactive mode works fine. Support Knowledge Base don´t have any references to pccon iss ...

Do you know how to copy all reports under public folder in zip file from Cognos 7 to Cognos 8 environment?

Fiserv Norcross said: Do you know how to copy all reports under public folder in zip file from Cognos 7 to Cognos 8 environment? ...

Cognos 8.2 - RQP-DEF-0177 - ORA-00972: identifier is too long error in PDF ??

said: Has anyone everyone ever come across the error RQP-DEF-0177 - ORA-00972: identifier is too long??This happens on a report when it is run in PDF. The report prompts, validates and runs fine in HTML mode, in PDF it prompts and validates, but throws this error right before it should render??Does ...

Using cognos 8 to read a delimited table.

Kevin Xu said: Hi, I have a LDAP data source that format s like this.Group | users<hr originalText="----"/>group1 | CN=user1,OU=Users,OU=All Users,DC=spipowernet,DC=com,DC=au,CN=user2,OU=Users,OU=All Users,DC=spipowernet,DC=com,DC=au,CN=user3,... group2 | CN=user4,OU=Users,OU=All Users,DC=spip ...

Looking for any suggestion for installing Cognos 8.3 BI

Deepali Patel said: I would like to know the better way to start with installing Cognos 8.3 BI. We have cognos reportnet 1.1 and I want to install 8.3 and migrate crn to cognos 8.3.Any idea how the migration of reports, packages, cubes(drill through reports) would look like after migration. Any suge ...

Cognos 8.2 Report issue DPR-ERR-2077 after Upgrade

Jim Giardinelli said: Hi - Some of our more complex reports (multiple joins & unions) have errors since going to 8.2. I am getting this error on one of the reports 'DPR-ERR-2077 - The request failed because the associated report service process is unavailable'. The report has multiple queries an ...

Migration from Cognos series 7 to 8 version

Jakkampudi Ravitej said: Hi,Could you please let me know the steps how to proceed the migrating from Cognos series 7 version to Cognos 8? ...

Receiving a java.lang.OutOfMemoryError when navigating in Cognos Connection

Madhurima Somaraju said: Hi All,We are having an issue with Java.Lang OutofMemory Exception.When this happens everyone gets locked out of Cognos..memory is set to 1152 MB and when we monitor the process in the Task Manager the memory goes to 1292637 and this exception occcurs..When this occurs the s ...

quota limit of report on Cognos Connection

said: Is it possible to limit the number of report (or view) that every user creates himself on Cognos Connection in C8.3? ...

Cognos 8.2 - Integrating BI and Planning

Gayan Godage said: Hi, We have two Cognos 8.2 environments. One for BI and other for Planning. These are separate in every possible way, different servers (web and application), diffrent content stores etc.Currently I am looking into the options of integrating the BI capabilities for the Planning Co ...

Cognos 7.0.7 to 8.3

said: We have been using Cognos 7.07 (Impromptu --> Transformer --> Powerplay). We use csv files into Impromptu, use the IQD into Transformer). Now we have purchased 8.3. We have installed the 8.3 products currently on one server. We are unsure how to bring in the csv file. We have however, im ...

Moving to New Server 2K3R2, should I install Cognos 8.3

Dino Cehic said: Hi, on my old server, which is Windows 2000 I have PPES 7.3 with Transofmer 7.3, Access Manager 7.3, Upfront 7.3 and Cognos 8.2 Framework Manager, Cognos Connection 8.2, Report Studio 8.2, Query Studio 8.2. The question is: What Cognos Products I should install, and what are the bas ...

I want to konw whether Cognos 8.3 has already contained the Cognos 8.2 SP1.

said: Dear all: On January 4, 2008, Cognos distributed 8.2 sp1. In the document of "8_2_sp1_fix_list.pdf", it lists all the bug fixed in this patch. I want to konw whether Cognos 8.3 has already contained this patch. If Cognos 8.3 does not contain them, how can i get this patch. Now, i can get the i ...

Build a PowerCube in Cognos 8

Andreas Weissenboeck said: Good Morning, I have installed Cognos 8 on muy computer, Framework Manager, MetricDesigner and Data Manager as well. After working with these tools, Iwant to buil a PowerCube with Data which I have modelled on DataManagerand FrameWork. My question is, Whichi tool for Cogno ...

Build a PowerCube in Cognos 8

Andreas Weissenboeck said: Good Morning, I have installed Cognos 8 on muy computer, Framework Manager, Metric Designer and Data Manager as well. After working with these tools, I want to buil a PowerCube with Data which I have modelled on DataManager and FrameWork. My question is, Whichi tool for Co ...

Is there anyway to make a URL object in Cognos Connection (8.2) open in a new window

said: Is there anyway to make a URL object in Cognos Connection (8.2) open in a new window?I have found some areas in the backend code to possibly make some duct-tape code changes... but was wondering if there was a simpler way to make it so if I user clicks on a URL (Hyperlink) object in Cognos Con ...

Unable to login as Cognos Admins

said: Hi,The User IDs in our company that had cognos admin roles assigned to them were deleted accidentally and nobody else can login as cogos admins. To assign the user IDs cognos admin roles we need to login as cognos admins to gain access to the directories tab. So as you can see the problem loop ...

Cognos 8.2 -- MS Access Data Source

Olga Gedroit said: Hello: I have an access database (.mdb) that exists on a server that my Cognos server has a mapping to. I would like to experiment with the following: to create a data source in Cognos and then essentially build a package to this Access DB. However, when I go to create a data sour ...

Sharepoint as a data source for Cognos BI applications

said: Has anyone out there had any experience using Sharepoint as a data source for Cognos BI applications? I've experimented a bit with Composite Information Services trying to see if I could get it to consume Sharepoint (lists, surveys, etc) as a web service, but haven't landed on the right config ...

How to migrate Cognos (v7.3 and v8.2) from One server to another server

Arun Vasavan said: Hi,We have production server and planning to have a backup server. we have installed cognos 7.3 and 8.2 and has powerplay reports, cubes, cognos 8 reports and packages.So to migrate all from one server to another server is there any step by step procedure. I just need to replicate ...

Cognos 8.2 -- LDAP Namespace Authentication

Olga Gedroit said: I have the following scenario: We have an LDAP namespace setup in Cognos and our users get authenticated against this namespace. Inside the built-in Cognos namespace, we then have the default roles (i.e., All Authenticated Users, Everyone, Consumers, Query Users, etc.). We manage ...

Customizing Cognos 8 UI

David Kristensson said: I am trying to change the look of our Cognos 8 UI but have a problem.When I add a new skin in Cognos 8.3 by copying an existing one, Cognos Administration and Cognos Viewer does not follow the stylesheets. For instance, the backgrounds in a drop-down menu is completely transp ...

Cognos 8.2 to 8.3 Upgrade Error "canUseDirectory"

Kevin Steiner said: Hello. I was wondering if anyone experienced this error after upgrading from Cognos 8.2 to 8.3? " RSV-AOM-0001 The specified value 'canUseDirectoryTool' is not a valid enumeration value". There seems to be a disconnection somewhere in the Java Script classes, but it is not 100% c ...

In which situation, the category code role should be use for association when creating a level in Cognos Transformer ?

Yves Beliveau said: In which situation, the category code role should be use for association when creating a level in Cognos Transformer ? ...

Upgrade of Cognos databases (BI and EP) from Oracle 9i to Oracle 10g

said: Hello everyone, We (IMF) are about to upgrade all our Oracle 9i environments to Oracle 10g. The strategy that we are planning to follow is to upgrade one environment at the time. After an environment has been upgraded, then test it for few days before upgrading the next environment. We are pla ...

Customize look & feel of Cognos Connection - Concepts and Examples...

Marko Langer said: Hi folks,after a year of using a Vanilla-Cognos 8.2 with few users and low usage to get experience we plan upgrade to 8.3 and to raise the things some steps higher.A big point in our actual beginning evaluations is to customize the look and feel in Cognos Connection. We want to of ...

Cognos 8.3 Model Reusability

Lily Tsai said: Hi,I would like to know if anyone has tried to create a Cognos 8 model that is resuable in other models. We currently are an Impromptu environment that will be migrating to Cognos 8.3 in the next year. We currently have some Impromptu catalogs that are the same, except that there are ...

Cognos Connection - Tabs, Skins - Look and Feel

said: Hello,We are interested in viewing other Cognos Connections that have been changed. More specifically, I'd like to see how portlets are layed out within tabs. We're trying to make our Cognos Connection "pretty" with new tabs that we will be giving our users soon. Please provide any screen shot ...

Migrating Cognos 1.1 MR3 Published Powerplay report to Cognos8 Analysis Studio

Venu Guduri said: Hello All,Please could you provide the steps for migrating Cognos 1.1 MR3 Published Powerplay reports to Cognos8 Analysis Studio? ...

Optimizing Cognos SQL in Framework Manager

Richard Kazanecki said: I am working on a FM package that will be used as a datasource in Transformer. The package references a couple of the largest tables in my data warehouse. Unfortunately, because my data warehouse is an exact replica of the tables in our ERP package, no primary or foreign keys ...

Email Burst option in Cognos Connection

Madhurima Somaraju said: Hi All,Has anyone tried the Email Burst option in Cognos Connection. Did it work? I am trying to validate that option.Any answer will be helpful. Appreciate your response! ...

How do I sort Cognos Group members???

Terri Johnston said: Can someone help me figure out how I can sort the members that belong to a Cognos group? I have one group that has more than 50 members and it is difficult to determine if a user is a member or not. I am using Cognos 8.2 ...

Reset security of Cognos Connection 8.2

Renata Oliveira said: Hi All!Well, I would like to know if it's possible to reset security (i.e. Roles) used of Cognos Connection like after installation. Is it possible?Regards,Renata Oliveira ...

Cognos model localization

Craig Fisher said: I have a question about how to localize part of a Cognos model. Most of the model is easily localizable as names, descriptions are in metadata tags. The following calculation expression though (where enum values are converted from integer DB values to strings) is presenting a prob ...

Implementing a "Minus" Rollup in Cognos Transformer

Christopher Adrales said: Hi,Is it possible to mark a category as "negative" and apply subtraction when conducting a rollup?There is a reversed in sign functionality in transformer but the total of categories are still being accumulated positively upon rollup. (Please see KB# 91047)With the above so ...

Renewing Cognos Credentials - AD?

Olga Gedroit said: We are currently on Cognos 8.2. and have our user management implemented in Cognos. We are looking to switching our namespace to use our Active Directory, however. As I am researching the pros and cons of this, I ran into several posts on the world wide web in regards to an issue ...

Effort Estimation Matrix for estimating development efforts for Cognos 8 Reports

Vikas Pandey said: Hi All, If anyone is using any kind of estimation matrix for estimating development efforts for Cognos reports, then can you please share the same. Thanks & RegardsKumar ...

Cognos Go Mobile ! Access issues in Blackberry

Narendra Gudapati said: Hi All,We have succesfully installed Cognos 8.1.7 blackberry on one of our Sandbox longback and tested succesfully. Users would be able to check the dashboard information on thier mobiles.Recently we tried using option PUSH to install on one of the other blackberry and PUSH w ...

Trigger cognos reports from SSIS Task

Srinivasa Rao Thadepalli said: I was able to trigger the Cognos reports from ExecuteProcess Task of SQL Server by calling trigger.bat and and save them to local disk by bursting using CM.OUTPUTLOCATION and CM.OUTPUTSCRIPT. Everything worked fine until today , reports are successfully triggered but a ...