Monday 26 September 2016

OBIEE11g: All the Column Values are not shown in Prompts drop down for Check Box, Radio Buttons and List Box


Scenario:

We have created a column prompt on a column which has about 450 values. When we click on the Prompt Drop down all the column values are not displayed in the prompt when we are using Check Box or Radio Buttons or List Box the same prompt is displaying all the values when we select the check boxes option. The prompt shows first 256 values only, there is no option to see or select the values other than these 256.
  

Solution:

1. Please make a backup copy of the instanceconfig.xml located in <INSTANCE_HOME>/config/OracleBIPresentationServicesComponent/coreapplication_obips1 folder.

2. Add or modify the following tag <MaxDefaultValues> into instanceconfig.xml and set a proper value (in the below example, it is set to 1000).
Also check the <MaxDropDownValues> value.

<Prompts>
<MaxDefaultValues>1000</MaxDefaultValues>
<MaxScrollValues>100</MaxScrollValues>
<MaxDropDownValues>10000</MaxDropDownValues>
</Prompts>

3. Restart Presentation Services.

4 comments:

  1. This comment has been removed by a blog administrator.

    ReplyDelete
  2. The choice of a fun walk.
    Royal1688Online Casino Site Betting gambler at anyone. I can come to chance. Investors can gamble all the way every day. Gambling can be played easily. There are many types of gambling. Provides complete comfort. Gambling is a place where you can enjoy gambling at the chance to play at any time. Exposure to all types of gambling. You just like to gamble to get the full service at the online gambling site that you can play this thrilling.

    With gambling and gambling in various ways. Gambling everywhere Make a substantial income. Always gambling. No matter how gambling is exposed. Gamblers are always available with online casino sites that are standard with us. Ensure that investors who come into contact with our gambling will not be disappointed. It can make a good income and more. Have fun at every moment, even more with online casino sites. Games that players can play at any time can easily play just to play to our online gambling games here.Royal1688

    ReplyDelete
  3. Online gambling is one alternative that the player can choose.
    Royal1688A gambling website that gives you all the bets on the selected gambler. Make profits to bet on every single day with the selected gambler. Always give good returns. The profit is very high. Gambling and betting on the best bet. The return of the lot. Want to bet on real gambling, easy to play gambling everywhere.

    By betting to play as you like. To play good luck. It is a bet that will fill in and be exposed to various forms of gambling. To play gambling, bet easy. Ready to play realistic online gambling. Live from the real casino. What kind of bets are you betting on at the site by gambling to play it like. Gambling is good. Gambling is a complement to and exposure to gambling in various forms. Get more easy gamblers. Ready to play a realistic online gambling. Live from the real casino. How to play gambling?Royal1688

    ReplyDelete