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

write a query to display the third record from the employee table?

6 Answers   HCL,

What is Clipboard? How to import XML file into Clipboard?

2 Answers   CSC, HCL,

What you mean by drill across and what is the difference between drill through, drill across?

0 Answers  

difference between drill through and master detail report?

2 Answers   HCL, Zensar,

how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance

0 Answers   HCL,

How can create users and permissions in cognos?

0 Answers  

If anybody need certification dumps like COG-112 COG-122 COG-132 THEN MAIL ME ON kris.bi121@gmail.com.all are latest dumps test taken on july-09

42 Answers  

Cognos TM1 1. What are the different windows in Turbo Integrator? 2. What is the use of advanced window in Turbo Integrator? 3. What is TM1 Workflow. How do you create a process in that? 4. Where is Portlet used. What are differnt windows in portlet. How can you access TM1 web from portlet? Cognos 8. 1. What is Drill-on? 2.How do you implement row level security in Framework Manager? 3. How do you create tree prompt?

1 Answers   HSBC,

How can we Maintain the Cube Security by Category level and Dimension level ?

0 Answers  

Is it possible to join multiple Databases in a Catalog?

0 Answers  

suppose if u burst the reports if ur reports not reached to the destination how u will identify that one???

3 Answers   CTS, iFlex,

How to select multiple values from type-in prompt?

0 Answers