User defined measures in Chart type report

[raja.chanda]

Hi ,

I need a help regarding chart report in Cognos Reportnet. I have a requirement in which we have to show user defined measures in chart report. The user should have flexibility to choose his own measures from prompt that needs to be displayed in the Chart report. I have created a prompt and added measure names as static choices, Now when user selects a perticular measure name in the prompt only those measure needs to be displayed in the chartb type. Please help me in resolving this issue

[DSR]

HI

Try this once may be it can help you.

For Mesure use a Calculated Data Item and give this in the Prompt
and use following code for calculated item

Case when ?pro1?=col1 then col1
        when ?pro1?=col2 then col2
        ......
        ......
        ......
        ......
else colN(this is default mesure)

end

or

use default selection for prompt and use prompt in the same report page.
Try this May be it will work for u
Thanks
Sanjeev

[raja.chanda]

HI

Try this once may be it can help you.

For Mesure use a Calculated Data Item and give this in the Prompt
and use following code for calculated item

Case when ?pro1?=col1 then col1
        when ?pro1?=col2 then col2
        ......
        ......
        ......
        ......
else colN(this is default mesure)

end

or

use default selection for prompt and use prompt in the same report page.
Try this May be it will work for u
Thanks
Sanjeev

Hi Sanju

This will not support multiple selection. I want to select multiple mesure selection.

[COGNOiSe administrator]

Just let them use Query Studio ...  ;D