Archive for the ‘Cognos’ Category

Inserting list row cells in the list header

Inserting list row cells in the list header

Create a list Report with the required data items. 2.  After creating the list report go to toolbar Structure>Headers & Footers>Create Header. 3. By using the Ancestor select the list, in properties pane change the Column Titles to “At start of details” , list header will be appear in the top. 4.  If we want [...]

Posted in Cognos | No Comments »

Cognos Mobile

Cognos Mobile

By using IBM Cognos mobile we can explore, access and analyze the reports where ever you are. You can access the reports same way as you do with IBM Cognos BI. Cognos mobile is more secure and reliable. Cognos Mobile supports the following mobile technologies: iPhone iPad BlackBerry smart phones and playBook Nokia devices using [...]

Posted in Cognos | No Comments »

Procedure to alert Cognos Admins for the Primary Content Manager down in Cognos 10

Procedure to alert Cognos Admins for the Primary Content Manager down in Cognos 10

Situation In multi server Cognos architecture, more than one content manager has been configured in order to avoid failover. Here, if any issue happened to the primary CM, the secondary CM will automatically take the control and started running as an active content manager. So, in this scenario the primary CM started running as a [...]

Posted in Cognos | No Comments »

Procedure to find out the Delta(missing reports from 8.4 PROD)reports on Cognos 10

Procedure to find out the Delta(missing reports from 8.4 PROD)reports on Cognos 10

Step1: Using MotioPI tool, open Cognos 8.4 Prod Connection http://merialbi/c8 Step 2: Extract the list of Report Studio Reports, Query Studio Reports, Analysis Studio Reports, and packages into a excel sheet (individually) Step 3: Using MotioPI tool, open Cognos 10 QA Connection http://am-usa38-cogq01/c10 Step 4: Extract the list of Report Studio Reports, Query Studio Reports, [...]

Posted in Cognos | No Comments »

File Write/Read Operation Using JavaScript

We had a requirement from one of our client where we had to store and pass parameter from one HTML page to another.  We achieved this by simply using HTML/JavaScript. We created two files write.html and read.html, each for writing into a text file and reading from a text file. Below is the sample code [...]

Posted in Cognos | No Comments »

Cognos: Master Detail Report

Cognos: Master Detail Report

Add two List, one for master and other for detail report Select Page and select Query1(Master Report Query) as Query under Data Section Select Detail Report List and Click on Master Detail Relationships Select the Relationship Select and drag the Detail Report List to at the end of Master Report list as a column. Run [...]

Posted in Cognos | No Comments »

Cognos: Creating Gantt Chart using Crosstab

Cognos: Creating Gantt Chart using Crosstab

Cognos do not include a Gantt chart as an available option in chart dialogs. We can achieve this by using Crosstab object. The steps below will discuss creating the Gantt chart. 1. Tables used We are going to use following two tables (I)Minute (II) Jobs 2. Create two Queries, Jobs and Minute, with all data [...]

Posted in Cognos | No Comments »

WHY MOVE TO COGNOS PLANNING 10.1 ?

WHY MOVE TO COGNOS PLANNING 10.1 ?

In today’s challenging business environment, it’s more important than ever for your organization to develop a plan for success, and then to communicate, track, and execute against the plan. While this is fundamentally a simple concept, it is much more difficult to make a reality, but Cognos planning makes it possible for you. Cognos Planning [...]

Posted in Cognos | No Comments »

Hiding Header and Toolbar in Cognos 10 Viewer

Hiding Header and Toolbar in Cognos 10 Viewer

By default the Cognos Header and toolbar will be visible in Cognos Report Viewer. Sometimes users of Cognos reports may request to hide header and toolbar in the Cognos viewer. If the report is called from an external application, user might want to hide the Cognos header and toolbar in that application. In Report Viewer [...]

Posted in Cognos | No Comments »

Cognos 10 – Life cycle Manager – Practical Questions and Answers.

Question: When comparing multiple Reports in Life cycle manager, few of them succeed and few of them error out. When rerun, the failed reports succeed in the next run. What is the issue? Answer: This is due to the amount of memory available to life cycle manager. For multiple reports, if memory is not available, [...]

Posted in Cognos | No Comments »
viagra