Answer / lakshmi

We can use variables for dynamically displaying column name.
In our project we given three dimensions in the prompt
value, user can switch to the dimension that they want to
see in the report.
Consider 3 dimensions A, B and C, Users want to see
measures in the report based on what is the dimension they
have selected in the report prompt having A, B and C
dimensions.

By using the Case Statement we can switch between the
dimensions
Create Dataitem as follows
Case
When ?p_Dimension?=A Then [A] (Directly take from
model)
When ?p_Dimension?=B Then [B] (Directly take from model)
When ?p_Dimension?=C Then [C] (Directly take from model)
End
This will automatically pick up the Dimension query item
names from the model based on User’s selection to display
as column name.

Answer / pamir

These are the steps -

i. Create a calculated column which contains the
information that the header is to contain, such
as "Report for year 1999" (concatenated text and
date to string sub string extraction).
ii. Highlight the report, and then right-click.
iii. Select Properties, and then click the Headers/Footers
tab.
iv. Clear the Column Title Header check box. This will
remove the headers from your columns.
v. Reinsert the rest of the column headers; insert text
will work.
vi. For the dynamic column, from the Insert menu, click
Data and select the calculated column you created and
insert it into the report.

Answer / omkar b ambulkar

In cognos 8.0, First create a Calculated Data Item, select
the list, associate it with the Query in Which Calculated
Data Item is created, then click on Structure and then List
Header and Footers. Check List Header and make the Box Type
of the Column header as None. Unlock and then drag the
Calculated Data Item into the required header which will
look like a Column Header in the report.

Answer / joydeep mukherjee

For making a column name dynamic the only thing that you
have to do is insert a layout calculations from the toolbox
tab in report studio.

Answer / nasa

for example i have the date items like 'first name' and
'last name' now i want to display 'full name'. so here 'full
name' became as a dynamic column bcz its not available in
packages.

steps:

report studio->create new report->list-> drag and drop
'firstname' and 'lastname' from staff_names query table.

now drag a QUERY CAL from toolbox and drop next to last
name.
it will ask a column name, give as a FULLNAME
in expression window write expression like firstname|| ' '||
lastname -> ok

save and run it...

Answer / fernando

I came across this answer because I wanted each column in a
cross tabulation to have a text description different from
the variable (column's) name.

Cognos's gloriously useless documentation says nothing on
how to do this and adding text isn't an allowed action in
page design mode (the error message you get goes beyond
unhelpful).

To have the column titles, row footers, etc., you want:

1)Switch to page structure view in report studio

2) expand the crosstab by clicking the plus signs until
crosstab row levels, crosstab level(variable_name), etc. are
visible

3) from the insertable objects, drag a 'Block' at the level
you'd like to add the text. This takes some experimenting

4) after the block's been added, add into the block a Text
Item from the insertable objects

5) a window will open and you can type in whatever text you
want.

It's no wonder Jim Goodnight has such harshness towards Cognos.

Cheers

What is set to be Cognos configuration?

0 Answers  

set scope level in transformer

2 Answers  

suppose there are 15 countries like (US, UK, ENGLAND,INDIA,JAPAN.......)i want a value prompt in the report and this value prompt should contain groups like group1(US,UK,ENG), group2(INDIA,US,UK), group3 (ENG,JAPAN,INDIA)and in the value prompt the values should be group1,group2,group3 how can we do this?

4 Answers  

hi, can some one give the information regarding about the best real time project institutes for IBM cognos at ameerpet in hyd

1 Answers  

if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......

0 Answers  

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

0 Answers  

What is the size of the cube?

0 Answers  

What is difference between page break and section report?

0 Answers  

What is drill down and slicing and dicing whats the difference between them?

0 Answers  

if there are list,crosstab,chart how can you apply a single filter to all object?

3 Answers   IBM, Syntel,

What is Fullouterjoin?

0 Answers  

How can create users and permissions in cognos?

0 Answers