How can I create a dynamic column name in Cognos

Hi,

As you said

.Select Properties, and then click the Headers/Footers tab.

I didnt find the option Headers/Footers tab.

Which version you are talking about ??

Thanks in advance

Vishwas

use nested if/else or case structure in calculated columns or use conditional formating to show dynamically the column names

Hi,

What do you exectly mena by Dynamic column, do you mean dynamicaly calculated column.

Hi
Mr. Jagan
We can create Dynamic columns in both level like frame work manager level and Report level also

Using Macroswe can create in Frame Work Manager Level
Using QueryCalculations we can create in Report Level
ok

We can create dynamic columns in two ways

1. by changing sql query

2. using macromacro use the perameter map to create column dynamically

For making a column dynamic you have to insert layout calculations from the objects pane in COGNOS 8 report studio. I was a bit confused with the previous answers from different ppl.

1. add a data item to the query(the query on which the report is based)
2. define an expression which u want to use for the dynamic column label
3. from the report page click on the column label
4. from properties pane look for "column label" the default would be "data item label/name" change that to "data item value"
5. in the same pane change the "data item" property to have the data item that u created for the column label.

Hi Dear

Dynamic column is same as Hiding of a column.

Select the required column in your report.
Go to it's property.
Set the Box Type as "None"

Then you can see that the selected column is hidden.
 

Create dataitem by using cast function and use that data item value for the dynamic column name by changing the source value (name under properties) for the column you need.

The requirement was some thing like, the heading's of a list report is
supposed to be dynamic. Column Name should be in the format as shown: Total
Budget XXXX, where XXXX represents year like next year or previous year etc. (ie.
XXXX can be 2009,2008..)

1. Add a data item to the query (the query on which the report is based)

2. Define an expression which u want to use for the dynamic column name

3. Go to the report page and then unlock the lock at the top menu.

3. On report page, click on the Source Type and change that to the data item
value

5. In the same pane change the Data Item Label property to have the data item
that was created for the column label.

Expression that i used was: (to get next year)

TO_CHAR(_add_years(TO_DATE(TO_CHAR({SYSDATE},'YYYY'),'YYYY'),1),'YYYY')

Hope that was helpful !!

You can use the following steps to have a dynamic column title

1. Click the unlock button and unlock the report design
2. Delete the column title
3. Place a text item on the column
4. Go to the query explorer
5. Drag a data item into the query
6. write the expression that you want for dynamic change in the column name
7. Open the report page
8. select the previously placed texr item and from the properties menu change the source to data item value
9. Select the data item that you just created

Should work fine with this

Cheers !!

In all Cognos 8 Versions you can implement the above things

Simply,

Add the query calculation or data item(i.e Current_Date) to the main query which you are using for your List or cross tab.

For example add to_char({sysdate},'MM/DD/YYYY') .

Click unlock and then insert the data item or query calculation you created earlier.

That's all, your data item will always have current date in your column header, similarly you can drag any data item from your main query to List Header

Drag and drop a calculation layout next to the right side of the header text title and connect your prompt (with a bar sapce left on the right side of the text heading) i.e year "1999". It will read as
"Report for year 1999"
Dynamic header title.

Mgani,

How we can create the column headers dynamically using parameter maps. Here is what I am facing, in the data table we have following columns

Id, Fact Period

And in a Translation Table I have row says

Fact Period Name , Fact Period Value
----------------------------------------------------
Fact Period , Q1 2012

How I can use parameter map here. Pls help thanks.

Two ways to used in dynamic columns in Report Studio

1.Query Calculation
2.DataItem