How to display more than 4000 customer name in a value prompt

[Chandrasekar]

Hi Guru's,

I want to know about how to display more than 4000 customer name in a value prompt/drop down list.

Tell what kind of methods can used in this situation from both Relational and dimensional model.

In this scenario i am not getting from the report, My senior reporter ask to me.

Please tell your points.

Thanks & Regards,
Chandrasekar.

[Lynn]

Hi Guru's,

I want to know about how to display more than 4000 customer name in a value prompt/drop down list.

Tell what kind of methods can used in this situation from both Relational and dimensional model.

In this scenario i am not getting from the report, My senior reporter ask to me.

Please tell your points.

Thanks & Regards,
Chandrasekar.

I think a search and select prompt would be a better choice.

[Chandrasekar]

Hi Lynn,

Thanks for your valuable points, Any other solutions?

Maximum how many  names displayed in value prompts?

Regards,
Chandrasekar.

[Lynn]

I think the limit is a practical one rather than a technical one. It isn't sensible to present a user with a list of 4,000 or more things to scroll through and select from. If it is a multi-select control then imagine how difficult that would be for a user to understand if they've selected everything they intended to!!

Personally, I think that if the number of choices even approaches 100 it is time to explore cascading prompts or search and select.

Have you actually tried to produce a prompt with that many values and run into a technical difficulty or is the question simply an academic one?

[Chandrasekar]

Hi Lynn,

Actually i am in learning process, So my task is if the situation occur in feature how to taggle.

And one more issue, If the prompt is multiselect, possible data is 40 or else, user can allow to select only 20. If select 21th data generates the notification("Your able to select up to only 20 customers").

In this scenario is possible to get the solution?

Thanks & Regards,
Chandrasekar. 

[Lynn]

Hi Lynn,

Actually i am in learning process, So my task is if the situation occur in feature how to taggle.

And one more issue, If the prompt is multiselect, possible data is 40 or else, user can allow to select only 20. If select 21th data generates the notification("Your able to select up to only 20 customers").

In this scenario is possible to get the solution?

Thanks & Regards,
Chandrasekar. 

There are probably javascript approaches to deal with the customer selection limitation, but I don't go that route due to potential issues that can happen on upgrade. Not sure if the new prompt API might have some controls in that regard, but maybe others will chime in with further advice.

There is a function ParamCount ('parameterName') to get the parameter count for a particular parameter. You could use this as a render variable to display a page containing a message if the number exceeds what is allowed. Then include a link for drill through back to the same report to let them try again.

[sunny bachan prasad]

I am in support of the Lynn answer.Because if you try to display 4000 or more value in prompt then surely it will give performance hit.I was facing the same problem earlier.Better option in search and select prompt.

[vetteheadracer]

There used to be a setting somewhere in the configuration (cognos.ini) file for this on the server.

Don't know where it would be set within Cognos 10.2

[MFGF]

There used to be a setting somewhere in the configuration (cognos.ini) file for this on the server.

That was in a totally different architecture - Impromptu 7. As Lynn said originally, a search and select prompt is the way to go here :)

MF.

[Chandrasekar]

Hi Guru's,

Now i am cleared about this. Possible solutions i get from your side is,

1. Search and select prompt
2. Value prompt using cascading

And one more solution get from Javascript. Fix number of selections if exceeds the selections alert message will execute else run the report.

Reference site: http://biprofessional.net/

Thanks & Regards,
Chandrasekar