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

Which lifecycle we will use for reporting?

0 Answers  

-----------------What is Determination Model?

0 Answers  

write a query to display to 10 max record from the employee table?

2 Answers   HCL,

What are the components required for the application tier?

1 Answers  

HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS

5 Answers   IBM, Virtusa, Wipro,

Did you find any differences in bursting feature between reportnet 1.1 & cognos 8? what are the differences?

0 Answers  

What are the types of hierarchies?

0 Answers  

How can we publish package to QA environment not cognos connection?(if we have two URL one cognos connection and qa environment how can we publish package to qa?)Please anybody give me the answer.

4 Answers   TCS,

what is the difference between aggregation and role up aggregation ?

1 Answers   Systime,

What is set to be cardinality?

0 Answers  

how can you restrict the number of values available for a prompt? i tried this by using static choices property, but i dint get result... so pls explain in detail steps....

3 Answers  

wt is scope relationship?

2 Answers