Possibility on the Prompt requirement in Cognos Analaytics

[kvca11]

Hi All,

I have got the requirement from the user like its like a Value prompt where we will show list of values in the prompt.

Req is,suppose if the prompt is having 200 values and if user select 1st value and he needs to scroll down to select another values in the prompt,but some times he forgot what he selected in the first value,for that if he select first value then he wants Insert button then he will insert that value to the next box like that
I think this can be achieved by using Java script,if anyone is having any advice on this.

i have created select and search and tried to convince the user but he is asking like above

Thanks
ca11

[Kiran Kandavalli]

Can we create as below

1) The first prompt is your value prompt
2) Make Auto submit as "yes"
3) Create the Second prompt like first prompt but with different query
4) You can apply cascading to second prompt and apply filter in Second Query of the new prompt.

Once the user select the first prompt -> the second prompt will show the list selected in first prompt.

hope this will be helpful to you.

[kvca11]

Hi Kiran,

Thanks for the reply.

here the req is user need to see all the values(Pre populate in the select and search prompt) and need an option to search the values also

thanks,
ca11

[dougp]

The basic concept behind Kiran's suggestion is good, but it was clearly not tested.  Here's why:

If you create a value prompt and set the Multi-select property to Yes, the only value available for the Auto-submit property is No.

IBM says that allowing auto-submit on a multi-select value prompt degrades report performance.  I say that's for the report developer to manage -- but what do I know.

However, there is a way to hack around the issue:

• Save the report (for backup)
• Copy report to clipboard
• Paste into your favorite text editor.
• Add the Auto-submit property by changing manually editing the value prompt.

Change...

Code Select Expand

<selectValue parameter="Parameter1" multiSelect="true" selectValueUI="listBox"/>
...to...

Code Select Expand

<selectValue parameter="Parameter1" multiSelect="true" selectValueUI="listBox" autoSubmit="true"/>

• Select all of the code and copy it to the clipboard.
• Open report from clipboard
• Save the report (as...)

You'll notice the Auto-submit property is set to Yes, but can only be changed to No.

Risk:  Any time you need to change the Auto-submit property, you'll need to perform a save-as, so you get a new StoreId for the report.  This will break any browser favorites that your users have set incorrectly (by using "add to favorites" in the browser rather than saving the "share" link Cognos provides).

[kvca11]

Hi Dougp,

Thanks for the response.

I have tried your solution but no luck,still its showing as Value prompt.

Here the excat req is ,where in select and search prompt the user wants to see the values like in the prompt(here there is no need to think about the value prompt),need to think about to populate the values in the select and search prompt(we can use the Value prompt beside the select and search prompt to populate the values then by using JS we can populating/load the values to the select and search prompt),this case for we need to hide the Value prompt.

I think that is the way we can try but i have tried to use the below JS but its not working.

Pls find the attached JS fr the same.

Any suggestions.

thanks,
ca11

[dougp]

The Search & Select prompt is so difficult to use, I don't know why it's even there.  Use a value prompt unless you just hate your users.

[Cape Cod Gunny]

I just started playing around with prompt pages the other day. I'm doing this with a "Multi-Select" Check box group. It works like a champ. You can even have the check boxes pre-populate if need be by providing "Default Selections".

On the result page I've added a Layout Calculation that displays the %ParamDisplayValue('xxxxxxx')%> so the end user is notified with the check boxes that were checked from the prompt page.

Cheers,
Mike

[kvca11]

Hi Dougp and Cape Cod Gunny,

Thanks for your responses.

I have explained the user with the same but still user wants the same way (need to Pre populate the values in search and select prompt).

Java script will not useful in this case?

Suggest me for any ideas

Thanks,
kvca11