In OBIEE enterprise topology, make sure the external load balancer used can terminate SSL requests at the load balancer and forward traffic to the back-end real servers using the equivalent non-SSL protocol (for example, HTTPS to HTTP).
KPI Partners Blog
The basic things to remember when configuring OBIEE 11G on Microsoft SQL Server:
Until OBIEE 188.8.131.52.0 we were limited to nesting the folders only at 2 levels. This limitation has been fixed in OBIEE 184.108.40.206.2 with a nice feature.
In general, the recommended approach for uploading the metadata repository is to use the Repository tab of the Deployment page. But you might encounter specific situations in which you must upload the repository using a different approach. For example, the size of the repository file can be too large for Fusion Middleware Control to handle, or you might be working in a development environment and have unique needs.
By default OBIEE 11G has slider value limit of 50. But most of the cases we must to change this setting to 100 or more (at least in my case). To change the default set limit, update your instanceconfig.xml file as explained below.