List of values in prompts are getting categorized in Folders

[Former Member]

Hi,

We have a webi wherein prompt values are getting categorized in folders. Is there a way to resolve the issue and display a list in prompts without folders being created.

Also if we increase the following parameter in CMC ,will this lead to resolution.

Attached herewith is the snapshot for Prompt values and Server settings in CMC

[Former Member · Accepted solution]

Hi Rohit,

This is because of parameter 'List of Values Batch Size' on Webi server properties.

You can modify the same and restart the Webi server for this setting to take effect.

Regards,

Mithilesh

[Former Member · Accepted solution]

Thanks Mithilesh

So if we change  the 'List of Values Batch Size ' from 1000 to 2000 then will the folders will get removed from prompts as there are 1500 prompt list .

[Former Member · Accepted solution]

It will depend upon the number of values present in DB for that object.

List of Values Batch Size specifies, maximum number of Entries/Values for each batch.

If your object has values are less than 2000, it will not create any group. If values are suppose 5000 for an object and LOV Batch size setting is set to 1000, you will see 5 folders.

Hope this helps.

Regards,

Mithilesh

[former_member198519]

Is the prompt created in hierarchical structure at the universe level? If yes you can get that converted to a normal LOV instead of LOV based on custom hierarchy.

I would say try doing the reverse of what is mentioned in the link mentioned by Niraj.

[Former Member]

Hello Rohit,

Your LOV is on a hierarchical structure as shown below

How to create a cascading List of Values (LOV) in UNX with hierarchical display - Business Intellige...

You need to make sure you create LOV accordingly at Universe level.

Regards

Niraj

[Former Member]

Also worth looking at below thread.

BO4 - lovs showing folder list | SCN

Regards

Niraj

[Former Member]

Thanks Niraj

We had checked the thread based on which we have attached one snapshot for server settings wherein List of values batch size is set to 1000. What if we increase the batch size to 2000. Probably since the batch size is set to 1000 prompt values more than 100 are getting categorized in folder.