RSS

OBIEE 11G configuration’s Maximum Limits

08 Oct

In OBIEE 11G, The instanceconfig.xml file stores the OBI PS configuration settings. Many configuration settings are available in EM and those should be controlled within EM only unless if we disabled centralConfigurationEnabled option. If any particular setting is not available in EM then we should make changes directly in instanceconfig.xml file. There are many situations where we need to change the default OBI configuration settings to a new value.

Interestingly, The OBIEE 11g have the following information on Maximum limits for these configuration settings, in system MBean called “BIDomain.BIInstance.PerformanceConfiguration”. This helps to asses a safe value without guessing.

Cache:

Be careful when you are setting the Cache attribute values. For implementations under significant stress increase this value to 1000 or a higher value as mentioned below. The main factor that affects its size is the memory consumption.

  • Maximum range of Global Cache storage size (in Megabytes) to use when BI Server cache is enabled – 9,999
  • Maximum number of cache entries; used to tune cache performance – 99,999
  • Maximum size (in Megabytes) for individual server cache entries – 9,999

Data Display/Download:

The Maximum no.of rows that we can set to display/download in the Table/Pivot views. But keep in mind OBIEE is NOT meant to be a tool to extract huge amounts of information.

  • Maximum number of rows of data to include in Table views – 9,999,999
  • Maximum number of rows of data to include in delivered emails – 9,999,999
  • Maximum number of rows to export to excel – 9,999,999

Topology:

This is the Maximum no.of OBI Components instantiated for the BI Instance within the Oracle Instance when you are scaling out the OBIEE 11G.

  • OBI Presentation Servers – 99
  • OBI Servers – 99
  • OBI Java hosts – 99
  • OBI Cluster Controllers – 2
  • OBI Schedulers – 2

IMHO, this is something every OBIEE Consultant have to know before hand to update the OBI PS configuration settings. I’ll keep this blog post updated with more information I attain and updates from you…

Stay tuned…

Thanks,
Shiva

Advertisements
 
7 Comments

Posted by on October 8, 2013 in BI apps, OBI EE, OBIEE 11g, ODI, Weblogic

 

Tags: , , , , , , ,

7 responses to “OBIEE 11G configuration’s Maximum Limits

  1. Emma Bail

    November 14, 2013 at 7:30 am

    I think this is the best information you are sharing about OBIEE 11g.Its a really worth reading.I just love the way you shared this information.Here i also want to share some relative site for OBIEE please have a look. http://www.blinkconsulting.com

     
  2. Vivek

    September 25, 2015 at 11:27 am

    Hey Which version of 11g you have written? I tried to increase the limit •Maximum number of rows of data to include in delivered emails, and it is not going beyond 99999. EM is not allowing to do this

     
    • Shikha

      October 1, 2015 at 6:46 pm

      I have Version 11.1.1.7.0 and I was able to set limit to 9999999 for Table/Pivot Views and Scheduler. Scheduler Number of rows however depends on multiple factors, if you are sending via email ,the mail server that you are trying to send the data might not be able to handle these many rows/size of data and have limits on how much big data file you can send over. Check the limits there as well.

       
  3. Santhosh Sreshta

    January 25, 2016 at 9:19 am

    Is the max values are also for 11.1.1.9 version.?????

     
  4. Chandramohan

    February 3, 2016 at 4:30 am

    Is this ResultRowLimit restrictions impact the BIP reports?

     
  5. Selma

    June 7, 2016 at 1:27 pm

    When I configure 4000, it shows an error in OBIEE when I try to export report in PDF or Excel 2007+ format. Excel 2003 works fine.

     
  6. OBIEE_USER

    May 24, 2017 at 2:59 am

    Hi Shiva,
    I’ve been following your blog from a long time. They’re really very much helpful in my day to day tasks. Thank you so much for your time.
    I have a question. Can we restrict record fetching based on the user or groups! I mean some users/ groups can download all the data but some users/groups shouldn’t be able to see all the data! Is it possible to pass a condition in OBIEE. Please help me in this.
    Thank you.

     

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: