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.
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
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
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…