COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Kindness on 27 Jul 2011 02:54:12 AM

Title: Dynamic columns in list
Post by: Kindness on 27 Jul 2011 02:54:12 AM
Hi.

Is it posible to create dynamic column set in list. I need to display all level members as columns in list.

Can anyone help me.

thanks
Title: Re: Dynamic columns in list
Post by: skmahaboobjohny@gmail.com on 27 Jul 2011 04:39:40 AM
Hi Kindness

Yes.we can Create Dynamic Columns in list
Title: Re: Dynamic columns in list
Post by: Kindness on 27 Jul 2011 06:08:27 AM
Can you tell me how to do that?
Title: Re: Dynamic columns in list
Post by: skmahaboobjohny@gmail.com on 27 Jul 2011 06:49:29 AM
Hi Kindness

what is your Exact Requirement.where you would to Create Dynamic Column.if you will share with us..it will be help full to get the best Suggestions



Regards,
jhan
Title: Re: Dynamic columns in list
Post by: Kindness on 27 Jul 2011 10:42:49 AM
i have two dimensions: Questions and Organizations. and one fact table with textual responses.

fct (
question id
org id
fct_response
Last Edited dt
Last Edited by
)

So, I need to create report, which look like somehow like this.
----------------------------------------------
                | org 1           | ... | org n           |
----------------------------------------------
Last Edited| Last Edited   | ... | Last Edited   |
dt             | dt 1 1          | ... | dt 1 n          |
----------------------------------------------
Last Edited| Last Edited   | ... | Last Edited   |
by             | by 1 1         | ... | by 1 n          |
----------------------------------------------
question 1 | response 11 | ... | response n1 |
----------------------------------------------
...
----------------------------------------------
question n | response 1n | ... | response nn |
----------------------------------------------

I can't use crosstab becouse it doesn't display a textual measures. List displays textual measures, but i don't know how to display organizations from dimension as columns in list.

so if it posible to create dymanic column set in list, please, tell me! I will very thankful.  :)