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.

6 comments:

  1. Very Useful Information
    Best Informatica Online Training INDIA, USA, CANADA, AUSTRALIA...
    Visit Best Informatica Online Training

    ReplyDelete
  2. This comment has been removed by a blog administrator.

    ReplyDelete
  3. Endless monetization channel.
    Royal1688The casino site will provide the best bet. There are investments to choose from. Get paid for the lot. Play all the luck. I like to touch betting to play all the way. Get money to play very well. Always get good returns. What kind of gambling do you like? Gambling every day every day with gambling to win a good amount of money. Full of gambling like Who wants to enjoy and experience the best bets to gamble at our online casino site here.

    Whether it is a woman or a man, it is possible to gamble all the time. Make more profits. Always give good returns. Ready to have fun Enjoy all types of gambling. More income. Play the chance to get the desired role. The profits are many. Ready to gamble? Every day the site wants to be exposed to gambling. To play the full bet. Make more money ready to bet on fun every day with the online investment games site.Royal1688

    ReplyDelete
  4. 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
  5. 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