If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Dynamic columns in list

Started by Kindness, 27 Jul 2011 02:54:12 AM

Previous topic - Next topic

Kindness

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

skmahaboobjohny@gmail.com

Hi Kindness

Yes.we can Create Dynamic Columns in list

Kindness

Can you tell me how to do that?

skmahaboobjohny@gmail.com

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

Kindness

#4
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.  :)